SSAS Tabular Workshop

– Online

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. The new online version has 4 hours of lecture every day, and each attendee will receive a set of exercises to make practice after each lesson.

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

SSAS Tabular Outline (PDF)

Prerequisites

No knowledge of previous versions of Analysis Services (Multidimensional) is required.

Looking for a course in classroom?

We bring our courses to you all over the world. Here are the current scheduled classroom events.
Please note that each course is taught exclusively by SQLBI trainers (no external trainers are involved).
 New York City, NY, US Apr 15-17
New York City
 Chicago, IL, US Apr 30
Chicago
May 1
Chicago
May 2
Chicago
 Seattle, WA, US May 6-8
Seattle
 Hamburg, DE May 14-16
Hamburg
 Copenhagen, DK May 22-24
Copenhagen
 Amsterdam, NL May 27
Amsterdam
May 28
Amsterdam
May 29
Amsterdam
 Chicago, IL, US Jun 25-27
Chicago
 Amsterdam, NL Jul 2-4
Amsterdam
Other locations On-Site On-Site On-Site