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.

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.

Consolidated experience in DAX.
Previous completion of the Mastering DAX course or equivalent experience.
Attending the SQL Days - Advanced DAX event is recommended but not required.

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 139 other courses at SQLBI

May 29, 2024 May 28-29, 2024

9:00am → 5:00pm

Amsterdam, NL

€895

€1790

€1590

€1790

€1590

Courses confirmed

At this point, it is safe for you to make travel arrangements.

Quote

What is included

1-day
Course
1 day
+ Videos
2 days
Courses
2 days
+ Videos
Expert
Trainer
Lunch &
Coffee
Slides &
Demos
Student
Certificates

Classroom Courses
Both days areThis day is similar to a technical conference. Interaction will be possible but limited.

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

Alberto Ferrari

Alberto was our trainer for 139 other courses at SQLBI.

Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology. Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities. Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

Each attendee will receive slides and demos of the days they attend. The material will be available a few days before the delivery and notified by email.

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.

Bundle
Discount
Group
Discount

Register also to SQLBI Days – Advanced DAX - May 28, 2024 - Amsterdam, NL at the same location as this course, to get an additional €200 discount.

€895

Add

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%


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					Copenhagen
Amsterdam, NL	May 27 Amsterdam	May 28 Amsterdam	May 29 Amsterdam
Chicago, IL, US					Jun 25-27 Chicago
Amsterdam, NL				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
Calgary, AB, CA					Sep 18-20 Calgary
Vancouver, BC, CA				Sep 23-25 Vancouver
Other locations				On-Site	On-Site	On-Site

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

Topics

Prerequisites

Location

Matrix Innovation Center

Teaching this course

Alberto Ferrari

Alberto Ferrari

Looking for another city?