SQLBI Days – First Steps in DAX Optimization

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

Chicago, IL, US

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 »

To get the best out of this Day you must have attended Mastering DAX, either in the classroom or via the video course. Attending SQLBI Days - Advanced DAX the day before is a good idea, but that is not mandatory.

Efficient and optimized DAX code is a big part of your organization’s success: it is faster, makes users happier, and represents significant savings in terms of Power BI capacity.

If you have not had a chance to study our Optimizing DAX video course, but are working with DAX at a level where performance and capacity usage are starting to be key, you need to attend this Day. You will learn what is needed to optimize DAX and which tools to use. It will set you up to better absorb and understand farther, in-depth optimization content offered by SQLBI.

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

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

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 168 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.
 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
 Melbourne, VIC, AU Aug 9
Melbourne
Aug 6-8
Melbourne
 Sydney, NSW, AU Aug 15
Sydney
Aug 12-14
Sydney
 Brisbane, QLD, AU Aug 19-21
Brisbane
Other locations On-Site On-Site On-Site