Analysis Services tutorials

APPLIES TO:yesSQL Server Analysis ServicesyesAzure Analysis Services

Tabular modeling (1400 compatibility level)
Applies to Azure Analysis Services and SQL Server 2017 Analysis Services and later. This tutorial provides lessons on how to author a basic Analysis Services tabular model for the fictitious company, Adventure Works, by using SQL Server Data Tools (SSDT).

Tabular modeling (1200 compatibility level)
Applies to Azure Analysis Services and SQL Server 2016 Analysis Services and later. This tutorial provides lessons on how to author a basic Analysis Services tabular model for the fictitious company, Adventure Works, by using SQL Server Data Tools (SSDT).

Multidimensional modeling
Applies to SQL Server 2012 Analysis Services and later. Multidimensional models are not supported on Azure Analysis Services. This tutorial provides lessons for learning fundamental skills and concepts of multidimensional modeling in SSDT. When you're finished, you will have a cube database based on Adventure Works data that you can access from Excel, Reporting Services, or any other client application that connects to Analysis Services.

Data Mining
Applies to SQL Server 2012 Analysis Services and later. Multidimensional models with Data Mining are not supported on Azure Analysis Services. This collection of tutorials describe creating data mining solutions using wizards and integrated visualizations.

Samples

Project and completed model database samples

Sample data modeling projects and completed sample model databases are available at Adventure Works for Analysis Services on GitHub.

Code samples

Open source code samples and community projects available at Analysis Services repo on GitHub.

SQL Server Database and SQL Server Data Warehouse samples

Adventure Works and Wide World Importers sample databases are available at SQL Server Sample Repository on GitHub.