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
Blog
Blog
Blog
Blog
Video
Video
Video
Video
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. 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. Manage a server
     3.2. Manage database users
     3.3. Manage server administrators
     3.4. Monitor server metrics
     3.5. Install and configure an on-premises data gateway
     3.6. Get client libraries
     3.7. Backup and restore
     3.8. Connect with Excel
     3.9. Connect with Power BI
     3.10. Create an .odc file
     3.11. Tutorials
          3.11.1. Adventure Works tutorial
          3.11.2. Lesson 1: Create a new tabular model project
          3.11.3. Lesson 2: Get data
          3.11.4. Lesson 3: Mark as Date Table
          3.11.5. Lesson 4: Create relationships
          3.11.6. Lesson 5: Create calculated columns
          3.11.7. Lesson 6: Create measures
          3.11.8. Lesson 7: Create Key Performance Indicators
          3.11.9. Lesson 8: Create perspectives
          3.11.10. Lesson 9: Create hierarchies
          3.11.11. Lesson 10: Create partitions
          3.11.12. Lesson 11: Create roles
          3.11.13. Lesson 12: Analyze in Excel
          3.11.14. Lesson 13: Deploy
          3.11.15. Supplemental lesson - Detail Rows
          3.11.16. Supplemental lesson - Dynamic security
          3.11.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
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
9/29/2017 Creating enterprise grade BI models with Azure Analysis Services 1:06:44
9/29/2017 DirectQuery in Analysis Services: Best practices, performance, use cases 1:15:18
9/28/2017 Delivering enterprise BI with Azure Analysis Services 1:15:30
9/27/2017 Enterprise Power BI deployments with Microsoft Power BI Solution Templates 0:52:04
7/27/2017 Azure Analysis Services with Azure SQL DB and Data Warehouse 0:14:58
7/25/2017 Cloud Tech 10 - 24th July 2017 - Analysis Services Web Designer, Data Lake Policies & more ... 0:05:04
7/20/2017 Azure Analysis Services with Azure SQL DB and Data Warehouse 0:14:57
6/21/2017 Cloud Tech 10 - 19th June 2017 - Cloud Foundry, Azure Functions, VPN Gateways and more! 0:08:30

Page 1 of 3