Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
Tabular modeling (1500 and higher compatibility level)
Applies to Azure Analysis Services, Power BI Premium, SQL Server 2019 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 Visual Studio. This tutorial can also be used for tabular models at the 1400 compatibility level to be deployed to SQL Server 2017 Analysis Services.
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 Visual Studio. 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.
AdventureWorksDW is available as a sample dataset on Azure Synapse, as described in the Tabular modeling (1500 compatibility level) tutorial.
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.
AdventureWorksDW and Wide World Importers sample databases are available at SQL Server Sample Repository on GitHub.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Documentation
Analysis Services Adventure Works Internet Sales tutorial (1500)
Learn how to create a new Analysis Services tabular model in this tutorial.
Install Analysis Services sample data and projects
Learn how to install the data and project files used in the Analysis Services tutorials.
Learn about samples available for Analysis Services.