SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Advanced DAX
Description
If you already know and use the DAX, but you want to move to the next level, by unleashing the full power of evaluation context manipulation, learn about shadow filter context, author complex queries and solve advanced scenarios, then this is the workshop for you.
IMPORTANT: attending the pre-con “From 0 to DAX” or having an equivalent experience if a re-requisite of this session; knowing how to create a measure and a calculated column, understanding the concepts of row context, filter context, and context transition, and being able to write good expressions in CALCULATE and CALCULATETABLE functions. Remember, this is the prerequisite!
In this workshop, you will learn how to:
IMPORTANT: attending the pre-con “From 0 to DAX” or having an equivalent experience if a re-requisite of this session; knowing how to create a measure and a calculated column, understanding the concepts of row context, filter context, and context transition, and being able to write good expressions in CALCULATE and CALCULATETABLE functions. Remember, this is the prerequisite!
In this workshop, you will learn how to:
- Manipulate the filter context in an efficient way reducing the granularity of complex filters
- Use expanded table or CROSSFILTER depending on the requirements
- Control data lineage and play with it using TREATAS
- Read the content of the filter context to identify user selection vs. cross-filters
- Control materialization caused by context transition
Pre-requisites
Attending the pre-con “From 0 to DAX” or having an equivalent experience: knowing how to create a measure and a calculated column, understanding the concepts of row context, filter context, and context transition, and being able to write good expressions in CALCULATE and CALCULATETABLE functions.
Laptop Required: Optional
- Software: Laptop is not required but it could be helpful. If you bring one you should have Power BI Desktop (free download from Microsoft) and DAX Studio installed (free download: https://daxstudio.org)
- Subscriptions: No
Learning Objectives
Previous Experience
Tech Covered
BI, DAX, Power BI