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.
Loading And Transforming Data In Power BI
Description
Power BI has a lot of amazing functionality for transforming, reshaping and cleaning up data before you load it into your dataset. In this full-day precon, suitable for anyone with a basic knowledge of Power BI, you'll learn how to get the most out of this functionality. Topics covered will include:
- What is the Power Query engine and where else is it used?
- Understanding the difference between importing data, DirectQuery, Live connections and composite models
- Connecting to data sources and tables of data inside those data sources
- Understanding queries and steps
- Using the functionality in the Power Query Editor window to transform your data
- Credentials and authentication
- Combining data from multiple queries by merging and appending
- Data privacy and related problems
- Dimensional models and why they are so important for Power BI
- What are dataflows and why should you use them?
- The basics of the M language
- Parameters, functions and getting data from multiple data sources in one query
Pre-requisites
Some knowledge of Power BI
Laptop Required:Yes
- Software: Power BI Desktop (latest version available)
- Subscriptions: No
Learning Objectives
Previous Experience
Tech Covered
BI, Power Query, Power BI