Analysis Services documentation

Analysis Services is available in Azure, Power BI, and on premises with SQL Server.

About Analysis Services

Overview

• What is Analysis Services?
• Understanding documentation

Azure Analysis Services

Overview

• What is Azure Analysis Services?

Get started

• Create a resource in Azure
• Add a sample model from the portal

Concept

• Supported data sources
• Automation with service principals

SQL Server Analysis Services

Overview

• SQL Server Analysis Services

What's new

• What's new in SQL Server Analysis Services

Get started

• Install SQL Server Analysis Services
• Install SQL Server evaluation editions
• SQL Server 2014 Analysis Services

Analysis Services in Power BI

Concept

• Analysis Services in Power BI Premium
• Semantic model connectivity with the XMLA Endpoint

Tools

Download

• Visual Studio
• Analysis Services projects extension (SSDT)
• SQL Server Management Studio (SSMS)
• DAX Studio (open-source)
• Tabular Editor (open-source)
• ALM Toolkit for Power BI semantic models (open-source)

Data modeling

Concept

• Tabular models
• Multidimensional models
• Comparing tabular and multidimensional solutions
• Tabular model solution deployment

Tutorial

• Tabular modeling
• Multidimensional modeling

Manage servers

Concept

• Monitoring overview
• Server properties
• Query interleaving
• Analysis Services PowerShell

Reference

• Install Az.AnalysisServices module
• Install SqlServer module

Developer

Overview

• Developer documentation

Download

• Client libraries

Reference

• Tabular Model Scripting Language (TMSL)
• Tabular Object Model (TOM)
• Analysis Management Objects (AMO)
• XML for Analysis (XMLA)