SQLBI Days – Advanced DAX

Chicago, IL, US

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of SQLBI Days – Advanced DAX is available in United States.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

 By pressing the Notify button you are agreeing to our Privacy Policy.

SQLBI Days are an exceptional type of event we are launching in 2024. We are organizing one-day lectures of various levels, with Marco Russo or Alberto Ferrari on stage.

Learn more about SQLBI Days »

This Day is for you if you have already studied Mastering DAX, whether in the classroom or on-demand with the video course. The contents of this Day have been delivered only a few times in pre-conference workshops at international conferences in the past, and they have been refreshed and updated for you.

Marco or Alberto will challenge you in your existing knowledge of DAX. Together, you will revisit the important foundations of key concepts such as row context, filter context, context transition, and functions like CALCULATE and KEEPFILTERS, which many advanced users do not actually fully understand. You will gather insights about data lineage, expanded tables, dependencies in calculated columns and tables, and different types of relationships, and this will likely shed some light on challenges you may be facing in your work with DAX.

The goal of this Day is to consolidate the more advanced concepts of DAX so you can figure out how to solve more complex calculations in DAX, or identify why an existing measure in your model does not work as expected. This Day is a good preparation for SQLBI Days - First Steps in DAX Optimization.

Topics

  • Evaluation context review
  • CALCULATE and context transition review
  • ALLEXCEPT vs. REMOVEFILTERS/VALUES
  • CALCULATE execution order
  • Data lineage and TREATAS
  • Expanded table
  • Circular dependencies
  • Calculated relationships
  • Regular and limited relationships
  • Working at different granularity

Prerequisites

  • Consolidated experience in DAX.
  • Previous completion of the Mastering DAX course or equivalent experience.
  • The initial review is a quick recap of the concepts that should be already well known: filter context, row context, context transition, CALCULATE.

Location

Gleacher Center

450 North Cityfront Plaza Drive 60611
Chicago, IL, US
View on Google Maps

Teaching this course

Marco Russo

Consultant & Mentor
Trainer for 172 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.
 Melbourne (Southbank), VIC 3006, AU Aug 9
Melbourne
Aug 6-8
Melbourne
 Sydney, NSW 2000, AU Aug 15
Sydney
Aug 12-14
Sydney
 Brisbane, QLD 4000, AU Aug 19-21
Brisbane
 Calgary, AB, CA Sep 18-20
Calgary
 Vancouver, BC, CA Sep 23-25
Vancouver
 London, England, GB Oct 14-16
London
 New York City, NY, US Oct 30-Nov 1
New York City
 Los Angeles, CA, US Nov 12-14
Los Angeles
 Amsterdam, NL Nov 19-21
Amsterdam
 Copenhagen, DK Dec 2-4
Copenhagen
 Amsterdam, NL Dec 10-12
Amsterdam
Other locations On-Site On-Site On-Site