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
Blog
Video
Video
Blog
Video
Podcast
Blog
Blog
Video
Video
more...


Azure Documentation

1. Overview
     1.1. About Analysis Services
     1.2. Supported data sources
     1.3. Authentication and user permissions
     1.4. Connecting to on-premises data sources
     1.5. Compatibility level
     1.6. High availability
2. Get started
     2.1. Create a server in Azure portal
     2.2. Create a server with Azure PowerShell
     2.3. Deploy a model from Visual Studio
     2.4. Create a model in Azure portal (preview)
3. How-to
     3.1. Install and configure an on-premises data gateway
     3.2. Backup and restore
     3.3. Refresh with REST API
     3.4. Configure scale-out
     3.5. Server management
          3.5.1. Configure a server name alias
          3.5.2. Manage a server
          3.5.3. Manage database users
          3.5.4. Manage server administrators
          3.5.5. Monitor server metrics
          3.5.6. Setup diagnostic logging
     3.6. Connect
          3.6.1. Get client libraries
          3.6.2. Connect with Excel
          3.6.3. Connect with Power BI
          3.6.4. Create an .odc file
     3.7. Tutorials
          3.7.1. Data modeling - Adventure Works tutorial
          3.7.2. 1 - Create a tabular model project
          3.7.3. 2 - Get data
          3.7.4. 3 - Mark as Date Table
          3.7.5. 4 - Create relationships
          3.7.6. 5 - Create calculated columns
          3.7.7. 6 - Create measures
          3.7.8. 7 - Create Key Performance Indicators
          3.7.9. 8 - Create perspectives
          3.7.10. 9 - Create hierarchies
          3.7.11. 10 - Create partitions
          3.7.12. 11 - Create roles
          3.7.13. 12 - Analyze in Excel
          3.7.14. 13 - Deploy
          3.7.15. Supplemental lesson - Detail Rows
          3.7.16. Supplemental lesson - Dynamic security
          3.7.17. Supplemental lesson - Ragged hierarchies
4. Reference
     4.1. Azure PowerShell
     4.2. REST
     4.3. DAX
     4.4. Power Query M
     4.5. Tabular Model Scripting Language (TMSL)
5. Resources
     5.1. Samples
     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
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
11/14/2017 Azure Analysis Services Visual Model Editor 0:10:12
11/13/2017 Cloud Tech 10 - 13th November 2017 - Grafana, Linux FUSE Adapter, Azure Stack and more! 0:06:15
9/30/2017 How to provide business insight from your data using Azure Analysis Services 0:19:50
9/29/2017 Architect your big data solutions with SQL Data Warehouse and Azure Analysis Services 1:08:16

Page 1 of 4