Analysis Services Tutorials (SSAS)

  • Article

This section contains tutorials for SQL Server 2014 Analysis Services.

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.

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

SQL Server 2008 R2 Tutorials
Most of the SQL Server 2008 R2 tutorials work on a SQL Server 2014 server. If you are new to Data Mining, use this link to find the SQL Server 2008 R2 Data Mining Tutorials that also work with a SQL Server 2014 instance of Analysis Services.

See Also

TechNet WIKI: SQL Server 2012 Samples
Picnic Dataset (Sample Data)