SSAS Tabular Workshop

The training is aimed to professionals who want to exploit the full power of the Tabular models in Analysis Services 2016/2017.

This two-day classroom course covers the Tabular modeling in Microsoft SQL Server Analysis Services 2016/2017 and includes a large number of demos that each student can try on his own notebook to make practice with Tabular modeling and administration. Most of the topics are valid also for versions 2012/2014.

No knowledge of previous versions of Analysis Services (Multidimensional) is required, because Tabular is based on different concepts and on the DAX language (instead of MDX). You will also learn the differences between the two technologies (Tabular and Multidimensional) and when to choose one over the other.

After this classroom course, you should attend the Mastering DAX Workshop in order to learn how to write complex measures and queries using the DAX Language, which is just shortly introduced in the SSAS Tabular Workshop course. This classroom course was refreshed in 2016 and covers all the new features introduced by Analysis Services 2016 and 2017.

The 3-day workshop covers the Tabular modeling in Microsoft SQL Server Analysis Services 2012/2014.

The new online version has 4 hours of lecture every day.
You will receive exercises to complete after each online session. Please, consider other 2 hours in your schedule after each day session if you want to complete exercises. Our teachers will answer to your questions during online sessions or by mail.

The course is aimed to professionals who want to exploit the full power of the new Tabular models in Analysis Services. No knowledge of previous versions of Analysis Services and Unified Dimensional Model (UDM) is required, because Tabular is based on different concepts and on the new DAX language.
You will also learn the differences between the two technologies (Tabular and Multidimensional) and when to choose one over the other.

Topics

Prerequisites