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.
This 2-day workshop is a seminar that covers the Tabular modeling in Microsoft SQL Server Analysis Services 2012/2014. This special edition is a seminar and does not include hands-on-labs. Exercises will be provided as homework.
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.