This three-day workshop is an advanced course on DAX and Tabular Patterns, based on DAX expressions. DAX is the native language of both Power Pivot for Excel and SSAS Tabular model in Microsoft SQL Server Analysis Services 2012.
The training is aimed at Advanced PowerPivot users and Analysis Services developers that want to master the DAX language and improve their skills in performance optimization. The course includes hands-on lab sessions assisted by our teachers, including exercises for creating queries, solving business problems and locating performance bottlenecks in DAX.
Prerequisite: Attendees need to have a basic knowledge of the SQL 2012 Analysis Services Tabular modeling or they need to be familiar with PowerPivot for Excel and have produced at least some basic reports. A prerequisite of the course is the participation to a SSAS Tabular or PowerPivot Workshop, or having equivalent experience.
Want your BI Developers and Excel users to exploit the full power of the DAX language, improving their skills in data modeling and performance optimization? Advanced DAX course is the training for your company! The course is very intense and is structured as a seminar with a high level of interaction with attendees. Questions are welcome and it is possible to customize examples using company-specific data. This type of customization has to be discussed in advance, in order to prepare material, but grants a higher level of engagement with attendees.
» Course outline (PDF)
Due to the strong interaction between trainer and attendees, we set a limit of 15 people
in the classroom, in order to make the training more effective.
Training centers interested in offering the workshop as a public course can contact us for further information.