Power BI Data Transformation using Power Query Course

Course overview.

Cleaning and combining data once, then refreshing it — instead of redoing the same copy-paste every month.

The 1 day works through 6 modules and 19 individual topics, from Inside the data model and Power Query Editor to Parameterised custom functions. Each module is taught then practised — you do the thing rather than watch it done — on our exercise files, and on your own where you are able to bring them.

Groups are kept small enough that everyone gets hands on the keyboard, and the facilitator is in the room the whole time rather than dropping in. You leave with the workbook, the exercise files and notes in your own words.

Full course outline.

Every module we cover, and the topics inside each one. This is the same outline as the downloadable PDF — expand a module to see what sits under it.

Who it is for.

Confident users who now maintain something other people depend on — and want to stop it breaking.

How it runs.

One day, roughly 9am to 4pm, with a facilitator in the room the whole time. You get a workstation each with the software installed, in a CBD training room in any of the six capitals, or live online on your own computer.