Browse 545 attributed reviews, viewable separately 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

£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

  • Locations for Advanced Power BI Data coursesPossible locations:London, Manchester, Online
  • Next Advanced Power BI Data course locationNext classroom course:Mon 23 May 2022
  • Advanced Power BI Data course timesTime: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)

Covered if time allows 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?

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

"Wise Owl are brilliant at virtual training which cannot be easy currently. I had my doubts it would be as effective as a classroom, but I was reassured with the pre-test before the course and it turned out to be. The admin was brilliant and our trainer was excellent and patient despite my HP laptop with no mouse. "

Gary Meyler (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))

"Fantastic course and a fantastic trainer. The entire process from booking through to logging on was simple, straightforward and hassle free. I would highly recommend Wise Owl. 10/10!!"

Jon Clay (Girls' Day School Trust)

"Engaging course & exercises are a good way to learn; course manual very well written and supportive. Impressively made graphs and coding interesting. "

Matt Saunders (Bloom Services)

"Trainer made a dry subject very interesting and engaging."

Marion Israel (Warner Bros Entertainment UK Ltd)

"Training session was great, if anything I slightly found the remote sessions a bit better than when I went to Manchester for the in class training sessions. Great trainer. I have previously used Wise Owl course and they were great."

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 £795 Book places
Thu/Fri 23-24 June 2022 2 £795 Book places
Wed/Thu 20-21 July 2022 2 £795 Book places
Date(s) Venue
23/05
23/06
20/07

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

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 or Power Apps blogs

This page has 0 threads Add post