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 three-day, classroom course is for the expert trainer to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. All the attendees will receive a copy of the book, The Definitive Guide to DAX - 2nd edition.

The classroom course includes hands-on labs: you will apply the concepts 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

Mastering DAX Outline (PDF)

Prerequisites

Attendees need basic knowledge of Power BI Desktop, or Analysis Services Tabular, or Power Pivot for Excel.

We strongly suggest attendees watch the free Introducing DAX video course prior to attending the Mastering DAX classroom course. This ensures proper basic knowledge of the language to start Mastering DAX. A minimum of 3-6 months of DAX experience is usually suggested to get the most out of the Mastering DAX classroom course.

All hands-on labs are based on Power BI - reasonable user interface knowledge is suggested, though the same DAX concepts can also be applied to Power Pivot for Excel and to Analysis Services Tabular.

Location

BCN Amsterdam Arena

Atlas Arena Complex, Gebouw Azië - 5e etage, Hoogoorddreef 5

Amsterdam, NL

You can reach the training center in less than 15 minutes from Amsterdam Airport Schiphol with a direct train.

View on Google Maps

Teaching this course

Alberto Ferrari

Consultant & Mentor
Trainer for 143 other courses at SQLBI

Feb 11-13, 2025

9:00am → 5:00pm

Amsterdam, NL

€2199

€2548

€2199

Courses confirmed

At this point, it is safe for you to make travel arrangements.

Quote

What is included

3-day
Course
3 days
+ Videos

Courses

+ Videos
Expert
Trainer
Lunch &
Coffee
Courses
Book
Student
Certificates

Classroom Courses
Both coursesThe course will take place in a classroom where each student has access to their own chair, a desk and their own space.

Students may ask about their specific issues at dedicated times during the courses.

Each attendee must bring his/her laptop for exercises (Hands-on Lab). We will provide the configuration required.

Video Courses
You benefit from 36 months of access to the recorded version of the classroom courses on both mobile and desktop browsers. The video courses are valid study companions is a valid study companion to review the concepts learned in the classroom, and they are to be used as a reference.

Note that you can watch the video courses before class, as a good exercise to familiarize yourself with the main training.

In person

Alberto Ferrari

Alberto was our trainer for 143 other courses at SQLBI.

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology. Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities. Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

Each attendee will receive a copy of the book, The Definitive Guide to DAX – 2nd Edition (Paperback or eBook - written by Marco Russo & Alberto Ferrari - published by Microsoft Press) to use as study companion.

Coffee breaks and a light lunch are included for all days.

Please communicate any dietary requirements in the Order Notes field during checkout.

At the end of the courses, 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.

Free
Videos
Group
Discount

A free version of the recorded versions of the classroom courses. EachThe video course contains most of the content of its classroom equivalent, making it a good study companion.

Mastering DAX Video Course (25 hours)

€331

FREE

This offer is reserved to students who register to the classroom course.

You can get a group discount by registering more than two attendees. To obtain the discount, just press the Register now button and select the number of attendees in the next step.

Attendees	Discount
3	20%
4	25%
5	25%
6	25%


2024
Copenhagen, DK		Dec 2-4 Copenhagen
Amsterdam, NL	Dec 10-12 Amsterdam
2025
Amsterdam, NL		Feb 11-13 Amsterdam
Phoenix (Tempe), AZ, US		Feb 18-20 Phoenix
Dallas, TX, US		Feb 24-26 Dallas
Other locations	On-Site	On-Site	On-Site

Topics

Prerequisites

Location

BCN Amsterdam Arena

Teaching this course

Alberto Ferrari

Alberto Ferrari

Looking for another city?