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.
Analytics
DAX - Beyond the basics
Description
❓ Have you been using PowerBI for a while but your users are now asking for more complex measures and reports?
❓ Would you like to step beyond these simple reports and take your DAX to the next level to solve your organisation’s challenges?
❓Are you comfortable with basic DAX and CALCULATE, but:
Seeking solutions to complex business problems using DAX.
Working in industries like finance, sales, supply chain, or analytics, where advanced calculations are essential.
Your DAX is limited and you end up with solutions that don’t perform.
You solve problems by duplicating and precalculating data – which is slow to iterate on – rather than in DAX.
You are looking forward to review several DAX concepts with practical applications you can easily reuse.
You want more DAX tools in your DAX toolbox to help you excel.
Overview
This workshop will advance your DAX skills to bridge the gap between basic and advanced concepts. Through real-world scenarios, you’ll learn to write efficient expressions, solve complex business challenges, and create dynamic, impactful reports with DAX.
Here are a few examples of what you can learn in this workshop:
✅Using OR conditions between slicers in DAX.
✅Creating a slicer that filters multiple columns in Power BI.
✅ Learn how to use REMOVEFILTER / VALUES for “natural” hierarchical calculations.
✅Show updated year-to-date actuals and forecasts in the same chart.
✅When and how to use visual calculations in DAX.
✅Optimize cumulative totals using variables and windows.
✅Implement different types of ranking calculations.
✅Aggregate relative periods (like each new customer's first 30 days of purchase) efficiently.
❓ Would you like to step beyond these simple reports and take your DAX to the next level to solve your organisation’s challenges?
❓Are you comfortable with basic DAX and CALCULATE, but:
Seeking solutions to complex business problems using DAX.
Working in industries like finance, sales, supply chain, or analytics, where advanced calculations are essential.
Your DAX is limited and you end up with solutions that don’t perform.
You solve problems by duplicating and precalculating data – which is slow to iterate on – rather than in DAX.
You are looking forward to review several DAX concepts with practical applications you can easily reuse.
You want more DAX tools in your DAX toolbox to help you excel.
Overview
This workshop will advance your DAX skills to bridge the gap between basic and advanced concepts. Through real-world scenarios, you’ll learn to write efficient expressions, solve complex business challenges, and create dynamic, impactful reports with DAX.
Here are a few examples of what you can learn in this workshop:
✅Using OR conditions between slicers in DAX.
✅Creating a slicer that filters multiple columns in Power BI.
✅ Learn how to use REMOVEFILTER / VALUES for “natural” hierarchical calculations.
✅Show updated year-to-date actuals and forecasts in the same chart.
✅When and how to use visual calculations in DAX.
✅Optimize cumulative totals using variables and windows.
✅Implement different types of ranking calculations.
✅Aggregate relative periods (like each new customer's first 30 days of purchase) efficiently.
Learning Objectives
By the end of this session, attendees will be able to:
✅Implement patterns in DAX and model design to solve practical business problems
✅Learn and practice advanced DAX concepts like data lineage
✅Adopt best practices in solving business problems with Power BI
✅Implement patterns in DAX and model design to solve practical business problems
✅Learn and practice advanced DAX concepts like data lineage
✅Adopt best practices in solving business problems with Power BI
Previous Experience
Good experience writing DAX measures in Power BI or Analysis Services is a prerequisite for attending this training. You must know row context, filter context, and context transition. You are comfortable using CALCULATE and are not afraid to learn something new.
Tech Covered
Power BI, Analytics, Grounded in Reality