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.
Data Modeling with Power BI
Description
You have data, and you have Power BI. So why can’t you glean any real insights into the information? Or maybe you’re dealing with a different problem: As you examine your data, you’re struggling to write the formula that provides the numbers you need. Either way, your problem is most likely with the data model.
This pre-con introduces the basic techniques of shaping data models in Power BI. We’ll assess real-world examples that look at your reports in a different way, and show you that with the right data model, the correct answer is always a simple one!
In this workshop, you will learn how to:
- Define business model entities and measures (dimensions and facts)
- Properly model header/details structures
- Use multiple fact tables, like sales and purchases, in a complex data model
- Manage calendar-related calculations using the proper date tables
- Track historical attributes, like previous addresses of customers or manager assignments
- Use snapshots to compute quantity on hand
Pre-requisites
Basic usage of Power BI
Laptop Required:No
Learning Objectives
Previous Experience
Tech Covered
BI, Power BI