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

Microsoft

7 Kanalvej - 2800 Kongens Lyngby

Copenhagen, DK

Room CUST 1.06

View on Google Maps

Teaching this course

Marco Russo

Consultant & Mentor
Trainer for 173 other courses at SQLBI

Dec 2-4, 2024

9:00am → 5:00pm

Copenhagen, DK

kr.16990

kr.17339

kr.16990

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

Marco Russo

Marco was our trainer for 173 other courses at SQLBI.

Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips. When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars.

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)

kr.2469

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

Microsoft

Teaching this course

Marco Russo

Marco Russo

Looking for another city?