Mastering DAX Workshop On-Site

DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power Pivot for Excel, Power BI Desktop and at Analysis Services developers that want to learn and master the DAX language.

The goal of this 3-day workshop is to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios.

The course includes hands-on labs: you will make practice using your own notebook.

Topics

DAX Basics
Table Functions
Evaluation Contexts
Filter and Row Context
Evaluation Contexts and Relationships
CALCULATE
Context transition
Iterators
Time Intelligence Calculations
DAX as a Query Language
Advanced Table Functions
Advanced Evaluation Context
Understanding Cross filters
Data lineage
Advanced Relationship Handling
Physical Relationships
Weak Relationships
Examples of Complex Relationships

The outline may be adjusted on customer request.

Mastering DAX Outline (PDF)

On-Site Course

EU Price (T&E Incl.)

€48000

The rate is inclusive of travel costs in the continental European Union. Contact us to know the rates for other countries.

What is included

3 days
Course
Expert
Trainers
Course
Book
Student
Certificates

This course will take place at your company.

Due to the strong interaction between trainer and attendees, we set a limit of 30 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 with the form below.

The course will be taught exclusively by one of our expert trainers. No external trainers will be involved.

Taught by

Marco Russo

Taught by

Alberto Ferrari

The course includes 10 copies of the book, The Definitive Guide to DAX – 2nd Edition (Paperback or Kindle - written by Marco Russo and Alberto Ferrari - published by Microsoft Press) to use as study companion.

At the end of the course, each attendee will receive a certificate of attendance via email in PDF format. Along with the file, every student will get a special page on our website that can be shared on social networks.