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

Subscribe to News about Analysis Services

Title  
Blog
Blog
Blog
Blog
Video
Blog
Blog
Video
Blog
Blog
Blog
Blog
more...

Azure Documentation

1. Overview
     1.1. What is Azure Analysis Services?
     1.2. Supported data sources
     1.3. Authentication and user permissions
     1.4. Compatibility level
     1.5. High availability
2. Get started
     2.1. Create a server in Azure portal
     2.2. Create a server with PowerShell
     2.3. Deploy a model from Visual Studio
     2.4. Create a model in Azure portal (preview)
3. How-to
     3.1. Manage a server
     3.2. Manage database users
     3.3. Manage server administrators
     3.4. Install On-premises data gateway
     3.5. Get client libraries
     3.6. Backup and restore
     3.7. Connect with Excel
     3.8. Connect with Power BI
     3.9. Create an .odc file
     3.10. Tutorials
          3.10.1. Adventure Works tutorial
          3.10.2. Lesson 1: Create a new tabular model project
          3.10.3. Lesson 2: Get data
          3.10.4. Lesson 3: Mark as Date Table
          3.10.5. Lesson 4: Create relationships
          3.10.6. Lesson 5: Create calculated columns
          3.10.7. Lesson 6: Create measures
          3.10.8. Lesson 7: Create Key Performance Indicators
          3.10.9. Lesson 8: Create perspectives
          3.10.10. Lesson 9: Create hierarchies
          3.10.11. Lesson 10: Create partitions
          3.10.12. Lesson 11: Create roles
          3.10.13. Lesson 12: Analyze in Excel
          3.10.14. Lesson 13: Deploy
          3.10.15. Supplemental lesson - Detail Rows
          3.10.16. Supplemental lesson - Dynamic security
          3.10.17. Supplemental lesson - Ragged hierarchies
4. Reference
     4.1. PowerShell
     4.2. REST
     4.3. DAX
     4.4. Power Query M
     4.5. Tabular Model Scripting Language (TMSL)
5. Resources
     5.1. Analysis Services code samples on GitHub
     5.2. Analysis Services team blog
     5.3. Azure Analysis Services forum
     5.4. Azure Roadmap
     5.5. Azure status
     5.6. Feedback
     5.7. Pricing
     5.8. Pricing calculator
     5.9. Stackoverflow
     5.10. Videos

Web Content

Content Type

Online Training Content

Date Title

Tools

Tool Description

Videos

Date Title Length
7/27/2017 Azure Analysis Services with Azure SQL DB and Data Warehouse 0:14:58
7/20/2017 Azure Analysis Services with Azure SQL DB and Data Warehouse 0:14:57
5/4/2017 Don’t let data slow down your application: Learn about Azure Analysis Services 0:21:03
5/4/2017 How to build in-app analytics with Azure Data Services, an Xbox case study 0:57:46
4/24/2017 Cloud Tech 10 - 24th April 2017 0:07:02
4/10/2017 Cloud Tech 10 - 10th April 2017 0:08:50
3/20/2017 An introduction to Azure Analysis Services 0:10:59
3/20/2017 Cloud Tech 10 - 20th March 2017 0:09:57
3/7/2017 Azure Analysis Services with Josh Caplan 0:29:55
3/1/2017 Azure Analysis Services Programmability and Automation Webinar 0:45:46

Page 1 of 2

StackOverflow

Date Title