WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Classroom training -  Advanced Power BI Data

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

  • Locations for Advanced Power BI Data coursesPossible locations:London, Manchester, Online
  • Next Advanced Power BI Data course locationNext classroom course:No classroom dates
  • Advanced Power BI Data course timesTime:09:30-16:30

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?

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

Related Courses

Advanced Power BI Reports RECOMMENDED

Advanced

2 day course

DAX

Advanced

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or DAX exercises

Power BI videos

Power BI videos

View Power BI or DAX for Power BI videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI blogs

This page has 0 threads Add post