Classroom Training

Advanced Power BI Data

Classroom training course - online version also available

£950 + VAT for most venues (£1,095 + 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:No classroom dates
Time:09:30-16:30

SCHEDULED DATES Course Contents - PDF

Course Contents

The contents of this course are as follows:

Column transforms

Splitting (3 methods)
Extracting data
Merging columns

Creating columns

Columns by example
Custom columns in M
Conditional columns
Index columns

Combining queries

Combining files from folders
Merging queries
Fuzzy merge
Appending queries

Manipulation transforms

Pivoting and unpivoting
Grouping queries
Transposing data

Normalising tables

Getting unique lists
Adding id numbers
Replacing text with id numbers
Final relationships

Dealing with errors

Data profiling
How Power Query handles errors
Fixing errors in situ
Fixing in a separate table

Data flows and data sets

Dataset limitations
Creating dataflows
Using dataflows in Power BI Desktop

Simple parameters

Creating parameters
Switching data sources
Using to filter data
Parameters and templates

Dropdown parameters

Dropdowns based on lists
Dropdowns based on queries

Stored procedures

Loading from stored procedures
Dynamic parameters

Dynamic connections

Dynamic SQL Server connections
Dynamic Excel workbook links
Dynamic worksheet links

Custom functions

How custom functions work
Case study - parsing postcodes
Case study - combining worksheets
Case study - combining webpages

Loading HTML

The HTML.Table function
Scraping websites in Power Query

JSON and XML

Parsing JSON
Expanding your results

APIs

How they work
Simple examples
Exchange rates
Bridging tables

Data insights

Language detection
Key phrases
Sentiment analysis
Image tagging

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 6 people per class
Proper restaurant lunch included
520 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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).

"Absolutely brilliant and engaging trainer. Really knows his stuff and was able to address any issues during the course immediately every time."

Alex Chu (Swagelok)

"Training & trainer both excellent. Nicely paced & presented."

Alan Ramsay (Durham County Council)

"The trainer was great, explained everything really well and the course was enjoyable and interesting."

Adrian Ulatowski (Jollyes)

"Course was great. Intuitive, well constructed and patiently and expertly delivered. All questions were answered and solutions were demonstrated even though they may not have been part of the structure. I'd happily choose and recommend this course to others and as part of my own professional development, would potentially be asking for further training from Wise Owl."

Andrew Smith (North Staffordshire Combined Healthcare NHS Trust)

"Very knowledgeable trainer and good resources."

Julie Ross (Thurrock Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).