| title | Analysis Services Tutorials | Microsoft Docs |
|---|---|
| ms.date | 05/08/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | |
| ms.topic | tutorial |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
| manager | kfile |
[!INCLUDEssas-appliesto-sqlas-all-aas]
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.
Sample data modeling projects and completed sample model databases are available at Adventure Works for Analysis Services on GitHub.
Open source code samples and community projects available at Analysis Services repo on GitHub.
Adventure Works and Wide World Importers sample databases are available at SQL Server Sample Repository on GitHub.