Microsoft Analysis Services (AS) is an analytical data engine that provides data models for business reports

Analysis Services can be used with two different approaches:

Tabular      Multidimensional

Want to learn how to master
Analysis Services in Tabular mode?

The Mastering Tabular course teaches Tabular modeling, administration, and maintenance in SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), and Power BI Premium. The course is updated to the latest versions of these products available in 2021.

Are you developing analytical models with Analysis Services as part of your daily job? AS is a powerful tool to manage large amount of data and to manage every detail of the semantic model.

You need to master many details to get the best from Tabular models:

  • Create an optimal data model for space and speed
  • Use the best development tools to improve your productivity
  • Choose between Import and DirectQuery modes depending on your requirements
  • Implement aggregations to improve DirectQuery performance
  • Manage partitions the right way
  • Design an efficient and trustable security model
  • Define an ideal processing strategy
  • Automate deployment and management of the data model

Any issue in one of these areas can damage the robustness and performance of your hard work. Make sure you start right. Take your first steps following the instructions provided by our trusted authors, who will teach you how to move with confidence in the maze of available choices.

Are you looking for a book on SSAS Tabular?

If you learn better by reading, here is the book for you: Optimizing DAX, Second Edition, written by our senior trainers, Marco Russo and Alberto Ferrari, and published by Microsoft Press.

Get the book

Are you looking to learn SSAS in Multidimensional mode?

Unfortunately, we don't have any course for this technology at the moment. Nonetheless, you can read our latest book on the topic - it was published in 2014, and the information provided are still valid to this day.