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.
Course outline (PDF)