Analysis Services Tutorials (SSAS)

 

Applies To: SQL Server 2016

This section contains tutorials for SQL Server 2016 Analysis Services (SSAS).

Tabular Modeling (Adventure Works Tutorial)
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 (Adventure Works Tutorial)
This tutorial teaches the fundamental skills and concepts behind multidimensional modeling in SQL Server Data Tools (SSDT). When you are 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
This collection of tutorials describe creating data mining solutions using wizards and integrated visualizations.

AdventureWorks Sample Databases on Codeplex
This link takes you to the codeplex download page that has the AdventureWorks sample databases for SQL Server 2014.

AMO Code Sample for Creating Tabular Models Programmatically
This link takes you to a Codeplex download page that has the AMO sample for SQL Server 2014.

Community Additions

ADD
Show: