SQLBI Days – Advanced DAX

SQLBI Days – Advanced DAX + SQLBI Days – First Steps in DAX Optimization

Amsterdam, NL

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.

SQLBI Days – Advanced DAX + SQLBI Days – First Steps in DAX Optimization

These two consecutive Days will allow Marco or Alberto to cover advanced DAX content that they have delivered in pre-conference workshops at international conferences only a handful of times in the past. This is updated and exclusive content they’ve cooked up for you, which you will not find anywhere else. This bundle is for you if you work with DAX every day; if you’ve become the go-to person on your team for DAX related questions; if you are one of the top DAX people in your organization; if you understand the financial consequences of authoring poor quality DAX code, as this requires a larger capacity. These two Days will hone your skills to a higher level and in turn help your company save money with efficient models so you can stay on your current Power BI capacity. Better performance means financial savings!

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
  • 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
  • Tabular query architecture
  • VertiPaq engine
  • Isolating performance issues
  • Performance Analyzer
  • Query plans and Server Timings in DAX Studio
  • DAX query fundamentals
  • Optimization patterns

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

Matrix Innovation Center

301 Science Park 1098 XH
Amsterdam, NL
The event is in the Matrix ONE Auditorium
View on Google Maps

Teaching this course

Alberto Ferrari

Consultant & Mentor
Trainer for 136 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.
 Amsterdam, NL Mar 4-6
Amsterdam
 New York City, NY, US Apr 15-17
New York City
 Chicago, IL, US Apr 30
Chicago
May 1
Chicago
May 2
Chicago
 Seattle, WA, US May 6-8
Seattle
 Hamburg, DE May 14-16
Hamburg
 Copenhagen, DK May 22-24
Copenhagen
 Amsterdam, NL May 27
Amsterdam
May 28
Amsterdam
May 29
Amsterdam
 Chicago, IL, US Jun 25-27
Chicago
 Amsterdam, NL Jul 2-4
Amsterdam
Other locations On-Site On-Site On-Site