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.
Delivery
Advanced DAX
Description
If you already know and use the DAX but want to move to the next level, this training day is for you.
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
The prerequisite to attend this training is good experience writing DAX measures in Power BI or Analysis Services. You must know row context, filter context, and context transition. You are comfortable with using CALCULATE. You are not afraid to learn something new. At the minimum, watch the free "Introducing DAX" video course and make weeks of practice before attending this training.
Here are a few examples of what you can learn in this workshop:
• Filter columns, not tables. Yes, you already know that, but you will learn many more reasons why it is a good idea.
• Understand when to use ALLEXCEPT, and what to use instead of ALLEXCEPT all the many times when ALLEXCEPT is not a good idea.
• Fix the circular dependency error that might appear when you create a relationship, a calculated column, or a table.
• Control data lineage and play with it by using TREATAS.
• Write granularity-aware measures when you use many-to-many cardinality relationships (yes, you can if you know what you are doing).
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
The prerequisite to attend this training is good experience writing DAX measures in Power BI or Analysis Services. You must know row context, filter context, and context transition. You are comfortable with using CALCULATE. You are not afraid to learn something new. At the minimum, watch the free "Introducing DAX" video course and make weeks of practice before attending this training.
Here are a few examples of what you can learn in this workshop:
• Filter columns, not tables. Yes, you already know that, but you will learn many more reasons why it is a good idea.
• Understand when to use ALLEXCEPT, and what to use instead of ALLEXCEPT all the many times when ALLEXCEPT is not a good idea.
• Fix the circular dependency error that might appear when you create a relationship, a calculated column, or a table.
• Control data lineage and play with it by using TREATAS.
• Write granularity-aware measures when you use many-to-many cardinality relationships (yes, you can if you know what you are doing).
Learning Objectives
• Filter columns, not tables. Yes, you already know that, but you will learn many more reasons why it is a good idea.
• Understand when to use ALLEXCEPT, and what to use instead of ALLEXCEPT all the many times when ALLEXCEPT is not a good idea.
• Fix the circular dependency error that might appear when you create a relationship, a calculated column, or a table.
• Control data lineage and play with it by using TREATAS.
• Write granularity-aware measures when you use many-to-many cardinality relationships (yes, you can if you know what you are doing).
Previous Experience
The prerequisite to attend this training is good experience writing DAX measures in Power BI or Analysis Services. You must know row context, filter context, and context transition. You are comfortable with using CALCULATE.
Tech Covered
Power BI, Delivery