Analysis Services

Official Documentation

Service Description

Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure Analysis Services provides enterprise-grade data modeling in the cloud.

Azure Analysis Services is compatible with the same SQL Server 2016 Analysis Services Enterprise Edition you already know. Azure Analysis Services supports tabular models at the 1200 compatibility level. DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported.

Getting Started

  1. Introducing Azure Analysis Services
    12/15/2016, Video, 0:17:03
  2. Getting Started with Azure Analysis Services
    12/7/2016, Video, 0:05:53
  3. Introducing Azure Analysis Services
    1/30/2017, Video, 0:17:04
  4. Creating your first data model in Azure Analysis Services
    12/8/2016, Blog
  5. Azure Analysis Services Programmability and Automation
    1/19/2017, Video, 0:12:21

Latest Content

RSS Feed

Building an Azure Analysis Services Model for Azure Blobs — Part 3 Blog
Invite guest users to your Azure Analysis Services by using B2B Blog
New sample model for Azure Analysis Services Blog
Building an Azure Analysis Services Model for Azure Blobs — Part 2 Blog
SSAS high availability Blog
New 400GB and 200GB caches available on Azure Analysis Services Blog
Azure Analysis Services new modeling and tooling features Blog
SQL Data Warehouse reference architectures Blog
Building an Azure Analysis Services Model for Azure Blobs — Part 1 Blog
Using modern data sources in Azure Analysis Services Blog
Don’t let data slow down your application: Learn about Azure Analysis Services Video
How to build in-app analytics with Azure Data Services, an Xbox case study Video

Azure Documentation

1. Overview
     1.1. What is Azure Analysis Services?
     1.2. Supported data sources
     1.3. Authentication and user permissions
2. Quickstarts
     2.1. Create a server - portal
     2.2. Deploy a model - SSDT
3. Samples
     3.1. Analysis Services samples on GitHub
4. Tutorials
     4.1. Create and deploy a model
          4.1.1. Adventure Works tutorial
          4.1.2. Lesson 1: Create a new tabular model project
          4.1.3. Lesson 2: Get data
          4.1.4. Lesson 3: Mark as Date Table
          4.1.5. Lesson 4: Create relationships
          4.1.6. Lesson 5: Create calculated columns
          4.1.7. Lesson 6: Create measures
          4.1.8. Lesson 7: Create Key Performance Indicators
          4.1.9. Lesson 8: Create perspectives
          4.1.10. Lesson 9: Create hierarchies
          4.1.11. Lesson 10: Create partitions
          4.1.12. Lesson 11: Create roles
          4.1.13. Lesson 12: Analyze in Excel
          4.1.14. Lesson 13: Deploy
          4.1.15. Supplemental lesson - Detail Rows
          4.1.16. Supplemental lesson - Dynamic security
          4.1.17. Supplemental lesson - Ragged hierarchies
5. How-to
     5.1. Manage a server
     5.2. Manage database users
     5.3. Manage server administrators
     5.4. Integrate On-premises data gateway
     5.5. Connect with Excel
     5.6. Connect with Power BI
     5.7. Get client libraries
     5.8. Backup and restore
     5.9. High availability
     5.10. Create an .odc file
6. Reference
     6.1. PowerShell
     6.2. REST
     6.3. DAX
     6.4. Power Query M
     6.5. Tabular Model Scripting Language (TMSL)
7. Resources
     7.1. Analysis Services team blog
     7.2. Azure Analysis Services forum
     7.3. Azure Roadmap
     7.4. Azure status
     7.5. Feedback
     7.6. Pricing
     7.7. Stackoverflow
     7.8. Videos

Web Content

Content Type

Online Training Content

Date Title


Tool Description


Date Title