Mastering DAX Workshop

London, England, GB

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 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 attendees will receive a digital copy of the book, The Definitive Guide to DAX - 3rd edition.

The classroom course includes hands-on labs: you will apply the concepts using your own notebook.

Accept cookies to show this video. Cookies Policy
Allow all cookies

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
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 recommended, though the same DAX concepts can also be applied to Fabric, Power Pivot for Excel, and Analysis Services.

Location

HubHub 20 Farringdon Street

20 Farringdon Street EC4A 4AB
London, England, GB
View on Google Maps

Teaching this course

Marco Russo

 Consultant & Mentor
Trainer for 185 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 Houston, TX, US Mar 30-Apr 1
Houston
 New York City, NY, US Apr 8-10
New York City
 Copenhagen, DK May 5-7
Copenhagen
 Baltimore, MD, US May 27-29
Baltimore
 Zürich, CH Jun 10-12
Zürich
 Berlin, DE Jun 15-17
Berlin
 Amsterdam, NL Jun 30-Jul 2
Amsterdam
 Amsterdam, NL Jul 21-23
Amsterdam
Other locations On-Site On-Site On-Site