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. 12/15/2016, Video, 0:17:03
    Christian Wade stops by Azure Friday to speak with Scott about Azure Analysis Services. Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure...
  2. 12/7/2016, Video, 0:05:53
    High level overview of Microsoft's Azure Analysis Services, which is part of Microsoft's overall BI offerings to help organizations gain insights from their data.
  3. 1/30/2017, Video, 0:17:04
    Learn about getting an unfair advantage with predictive analytics: https://aka.ms/advantageanalytics. Built on the proven analytics engine in Microsoft SQL Server Analysis...
  4. 12/8/2016, Blog
    Azure Analysis Services is a new preview service in Microsoft Azure where you can host semantic data models. Users in your organization can then connect to your data models...
  5. 1/19/2017, Video, 0:12:21
    Christian Wade returns to Azure Friday to speak with Scott Hanselman about the rich programmability APIs and automation opportunities in Azure Analysis Services that are built...



Latest Content

Subscribe to News about Analysis Services

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


Web Content

Analysis Services Documentation

1. Analysis Services Documentation
2. Overview
     2.1. What is Analysis Services?
3. Quickstarts
     3.1. Create a server - Portal
     3.2. Create a server - PowerShell
     3.3. Configure server firewall - Portal
4. Tutorials
     4.1. 1 - Add a sample model from the portal
     4.2. 2 - Configure server administrator and user roles
     4.3. 3 - Connect with Power BI Desktop
5. Concepts
     5.1. Authentication and user permissions
     5.2. Automation with service principals
     5.3. Client libraries
     5.4. Compatibility level
     5.5. Connecting to on-premises data sources
     5.6. Connecting to servers
     5.7. High availability
     5.8. Supported data sources
6. How-to
     6.1. Server
          6.1.1. Backup and restore
          6.1.2. Configure a server name alias
          6.1.3. Configure scale-out
          6.1.4. Install and configure an on-premises data gateway
          6.1.5. Use gateway for data sources on an Azure Virtual Network
          6.1.6. Manage a server
          6.1.7. Monitor server metrics
          6.1.8. Setup diagnostic logging
          6.1.9. Create service principal - Azure portal
          6.1.10. Create service principal - PowerShell
          6.1.11. Add a service principal to server administrator role
     6.2. Model
          6.2.1. Import a Power BI Desktop file
          6.2.2. Create a model in Azure portal (preview)
          6.2.3. Deploy from Visual Studio (SSDT)
          6.2.4. Refresh with REST API
          6.2.5. Data modeling in Visual Studio - Adventure Works (1400) tutorial
               6.2.5.1. 1 - Create a tabular model project
               6.2.5.2. 2 - Get data
               6.2.5.3. 3 - Mark as Date Table
               6.2.5.4. 4 - Create relationships
               6.2.5.5. 5 - Create calculated columns
               6.2.5.6. 6 - Create measures
               6.2.5.7. 7 - Create Key Performance Indicators
               6.2.5.8. 8 - Create perspectives
               6.2.5.9. 9 - Create hierarchies
               6.2.5.10. 10 - Create partitions
               6.2.5.11. 11 - Create roles
               6.2.5.12. 12 - Analyze in Excel
               6.2.5.13. 13 - Deploy
               6.2.5.14. Supplemental lesson - Detail Rows
               6.2.5.15. Supplemental lesson - Dynamic security
               6.2.5.16. Supplemental lesson - Ragged hierarchies
     6.3. Security
          6.3.1. Manage database users
          6.3.2. Manage server administrators
     6.4. Connect
          6.4.1. Connect with Excel
          6.4.2. Connect with Power BI
          6.4.3. Create an .odc file
7. Reference
     7.1. PowerShell
     7.2. REST
     7.3. DAX
     7.4. Power Query M
     7.5. Tabular Model Scripting Language (TMSL)
     7.6. Tabular Object Model (TOM)
     7.7. Resource and object limits
8. Resources
     8.1. Samples
     8.2. Analysis Services team blog
     8.3. Azure Analysis Services forum
     8.4. Azure Roadmap
     8.5. Azure status
     8.6. Feedback
     8.7. Pricing
     8.8. Pricing calculator
     8.9. Stackoverflow
     8.10. Videos

Web Pages

Content Type

Online Training Content

Date Title

Tools

Tool Description

Videos

Date Title Length
10/2/2018
Thousands of Azure data warehousing success stories - BRK2408
0:39:39
10/2/2018
Microsoft Power BI: Next generation data connectivity and data preparation using - BRK3404
1:10:28
10/2/2018
Microsoft Power BI Flow and PowerApps: Connecting to data using the on-premises data - BRK3077
0:43:21
1/5/2018
TWC9: Happy New Year, Meltdown and Spectre, REST API or Azure Analysis Services, and more
0:02:58
1/3/2018
Azure Friday | Azure Analysis Services Scale Out & Diagnostics
0:12:18
1/3/2018
Azure Analysis Services Scale Out & Diagnostics
0:12:17
12/4/2017
Cloud Tech 10 - 4th December 2017 - Location Based Services, Azure Migrate and more!
0:04:26
11/21/2017
Azure Friday | Azure Analysis Services: Desktop PowerBI to the Cloud
0:05:58
11/21/2017
Azure Analysis Services: Desktop PowerBI to the Cloud
0:05:56
11/14/2017
Azure Friday: Azure Analysis Services Visual Model Editor
0:10:13

Page 1 of 4