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 And Power Query
Description
Anyone who is serious about building BI and reporting solutions using Power BI or Excel needs to know how to load and transform data. This pre-con will focus on the “Get Data” functionality in Power BI that is also shared by Power Query and Excel 2016’s “Get & Transform” feature. You will learn how to use it to connect to multiple data sources and how to shape your data appropriately for Power BI/Power Pivot.
Topics covered will include:
Topics covered will include:
- Basic concepts
- Differences between Power BI and different versions of Excel
- Building a dimensional model - or not
- Connecting to data sources
- Using the Query Editor window to transform data
- Working with multiple queries
- Writing queries and calculations in the M language
- Working with parameters and functions
- Working with web services
- Sharing queries with Azure Data Catalog
- Making sure your queries refresh when they are deployed to PowerBI.com
Learning Objectives
Previous Experience
Tech Covered
Azure, BI, Power Query, Power BI