Mastering DAX Workshop On-Site

DAX is the native language of semantic models in Power BI, Fabric, Analysis Services, and Power Pivot for Excel. The training is aimed at users of Power BI and Power Pivot for Excel, and at Analysis Services developers who want to learn and master DAX.

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 syntax
User-defined functions
Filter context
Row context
Table functions
Semi-additive calculations
Time intelligence (calendar-based and classic)
Window functions
Calculation groups
Inside CALCULATE
Advanced 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, Third 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.