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.
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
- 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.
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 XHAmsterdam, NL
The event is in the Matrix ONE Auditorium
View on Google Maps