Classroom Training
Advanced Power BI Data
Classroom training course - online version also available
£795 + VAT for most venues (£950 + VAT for London)
2 days
This two-day course covers advanced ways to extract, transform and load data, including learning a host of Power Query transforms, learning how to link to APIs, data flows and other data sources and how to work with parameters. If your data is perfect (and you just want to learn how to present it well) this course is not for you, and you should consider attending our Advanced Power BI Reports course instead (classroom or online).
Course details
Possible locations:London, Manchester, Online
Next classroom course:Mon 23 May 2022
Time:09:30-16:30
Course Contents
The contents of this course are as follows:
Advanced data sources
- Connecting to folders
- Changing the source using M
Power Query transforms (1)
- Unpivoting data
- Merge transforms
- Append transforms
Parameters
- Input parameters
- Dropdown parameters
- Dynamic connection strings
Power Query: creating columns
- Columns from examples
- Custom columns using M
- Conditional columns
- Indexing columns
Connecting to APIs
- What are APIs?
- Example: the Star Wars API
- Extracting API data
- Filtering API data
Power Query: column operations
- Merging columns
- Transposing columns
- Grouping data
Power Query transforms (2)
- Extracting data
- Parsing data
- Filtering using dates/times
- "Fuzzy" merging
Power Query: qualitative data
- Extracting frequent words
- Sentiment ratings
- Multi-response questions
- Normalising single data tables
Viewing and fixing errors
- How Power Query handles errors
- Manually replacing errors
- Removing errors using merge
- Replacing errors using merge
Power Query functions
- Report refresh timestamps
- List from examples (web connnector)
If time
Data flows
- Data flows vs datasets
- Creating data flows in PBI Service
- Connecting to a data flow
- Modifying imported data flows
To attend this course you must be familiar with creating Power BI reports, and in particular must be familiar with transforming data using Power Query Editor.
Why Choose Us?
- No more than 5 people per class
- Proper restaurant lunch included
- 545 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Gary Meyler (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
Jon Clay (Girls' Day School Trust)
Matt Saunders (Bloom Services)
Marion Israel (Warner Bros Entertainment UK Ltd)
Paul Martin (Ashton Sixth Form College)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Scheduled Advanced Power BI Data training dates
Here are the classroom Advanced Power BI Data courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Mon/Tue 23-24 May 2022 | 2 | Manchester | £795 | Book places |
| Thu/Fri 23-24 June 2022 | 2 | Manchester | £795 | Book places |
| Wed/Thu 20-21 July 2022 | 2 | Manchester | £795 | Book places |
| Date(s) | Venue |
|---|---|
| 23/05 | Manchester |
| 23/06 | Manchester |
| 20/07 | Manchester |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).
