Wizard Corporate Training is part of Nexacu — Microsoft and Adobe courses run on the shared Nexacu schedule, so you get every date in every capital. See the schedule

1300 886 190
Level 3 Microsoft 1 day

Power BI Advanced Course

9:00am – 4:00pm Six capitals or live online Prerequisite: Power BI Intermediate

Power BI Advanced at a glance.

Duration
1 day, 9:00am – 4:00pm
Price
$595 per person, ex GST — purchase orders welcome
Delivery
In person, or live online with a facilitator
Where
Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney — or online
Prerequisite
Power BI Intermediate
Class size
Small — everyone practises out loud more than once
You take away
A printed workbook, exercise files, and your own notes
In-house
Available for teams of four or more, at your office or ours

What you'll learn.

  • Advanced DAX — CALCULATE, context transition, iterators
  • Performance and model size
  • Row-level security
  • Workspaces, apps and deployment

Course overview.

Advanced DAX, time intelligence, row-level security, performance and publishing to the workspace.

The 1 day works through 15 modules and 69 individual topics, from Course opening to Extended exercise: the M language continued. 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.

  • 15 modules
  • 69 topics
  • 1 day in the room
  • 1Course opening1 topic
    • Power BI at a glance
  • 2The data model2 topics
    • Data modelling on real projects
    • The dataset used in this course
  • 3Themes, parameters and report templates3 topics
    • Applying report themes
    • Parameters that switch the data source
    • Saving report templates
  • 4Advanced slicing and dimensions4 topics
    • Handling multiple date dimension tables
    • Building a date dimension table with DAX
    • Role-playing dimensions explained
    • Creating hierarchies
  • 5Measures and filters in DAX5 topics
    • What DAX is
    • Writing DAX measures
    • The measures table
    • Filters applied to a measure
    • What filter context means
  • 6DAX measures and filters continued4 topics
    • Evaluating a measure with an empty filter context
    • Evaluating a measure as filters propagate
    • Extending the filter context
    • Modifying the filter context with DAX
  • 7Filtering with CALCULATE4 topics
    • The basics of CALCULATE
    • Simple filters inside CALCULATE
    • How filters behave
    • Table expression filters inside CALCULATE
  • 8Filter modifiers with CALCULATE8 topics
    • USERELATIONSHIP
    • REMOVEFILTERS
    • ALLSELECTED
    • KEEPFILTERS
    • CROSSFILTER
    • Filter context travels along relationships
    • Cross filtering in both directions
    • Temporarily changing the cross-filter direction
  • 9Report building blocks9 topics
    • Binning data
    • Grouping data
    • Drill through
    • Building custom report tooltips
    • Setting a report tooltip manually
    • Adding navigation
    • The page navigator
    • Buttons for page navigation
    • Buttons for drill-through
  • 10Row-level security6 topics
    • USERNAME
    • Parent-child hierarchies
    • PATH
    • LOOKUPVALUE
    • Making row-level security dynamic
    • Publishing and testing RLS
  • 11Extended exercise: querying APIs4 topics
    • Querying a live API data source
    • The HTTP and JSON terms you need
    • Transforming a JSON response
    • Publishing to the Power BI Service
  • 12Extended exercise: streaming data1 topic
    • Streaming data from PubNub
  • 13Extended exercise: folders of files4 topics
    • Querying a folder of files
    • Keeping columns consistent
    • How the folder query works
    • View Query Dependencies
  • 14Extended exercise: the Power Query M language6 topics
    • M syntax
    • All those hashes
    • How let and in work
    • First exercises in M
    • Values, records and lists in M
    • M operators
  • 15Extended exercise: the M language continued8 topics
    • Conditional tests with if
    • Handling errors
    • Reaching table data
    • Further M language exercises
    • The each expression
    • Referring to other queries
    • How a web query is put together
    • Removing rows by filtering

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.

Dates

Upcoming Dates

The next scheduled Power BI Advanced dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.

LevelDateLocationDeliveryPrice
Power BI AdvancedThu 27 Aug 26BrisbaneIn person$595Book
Power BI AdvancedThu 27 Aug 26Remote EastOnline$595Book
Power BI AdvancedThu 27 Aug 26Remote WestOnline$595Book
Power BI AdvancedThu 3 Sep 26Remote EastOnline$595Book
Power BI AdvancedThu 3 Sep 26BrisbaneIn person$595Book
Power BI AdvancedFri 4 Sep 26SydneyIn person$595Book
Power BI AdvancedFri 4 Sep 26Remote EastOnline$595Book
Power BI AdvancedThu 10 Sep 26CanberraIn person$595Book
Power BI AdvancedThu 10 Sep 26PerthIn person$595Book
Power BI AdvancedThu 10 Sep 26Remote EastOnline$595Book
Power BI AdvancedThu 10 Sep 26Remote WestOnline$595Book
Power BI AdvancedThu 17 Sep 26BrisbaneIn person$595Book
Power BI AdvancedThu 17 Sep 26Remote EastOnline$595Book
Power BI AdvancedFri 18 Sep 26Remote EastOnline$595Book
Power BI AdvancedFri 18 Sep 26MelbourneIn person$595Sold out
Power BI AdvancedFri 18 Sep 26SydneyIn person$595Book
Power BI AdvancedThu 24 Sep 26PerthIn person$595Book
Power BI AdvancedThu 24 Sep 26CanberraIn person$595Book
Power BI AdvancedThu 24 Sep 26MelbourneIn person$595Sold out
Power BI AdvancedThu 24 Sep 26Remote WestOnline$595Book
Power BI AdvancedThu 24 Sep 26Remote EastOnline$595Book
Power BI AdvancedFri 2 Oct 26BrisbaneIn person$595Book
Power BI AdvancedFri 2 Oct 26SydneyIn person$595Book
Power BI AdvancedFri 2 Oct 26Remote EastOnline$595Book
Power BI AdvancedTue 13 Oct 26MelbourneIn person$595Book
Power BI AdvancedTue 13 Oct 26AdelaideIn person$595Sold out
Power BI AdvancedTue 13 Oct 26Remote EastOnline$595Book
Power BI AdvancedWed 14 Oct 26SydneyIn person$595Book
Power BI AdvancedWed 14 Oct 26BrisbaneIn person$595Book
Power BI AdvancedWed 14 Oct 26Remote EastOnline$595Book
Power BI AdvancedMon 26 Oct 26SydneyIn person$595Book
Power BI AdvancedMon 26 Oct 26BrisbaneIn person$595Book
Power BI AdvancedTue 27 Oct 26SydneyIn person$595Book
Power BI AdvancedTue 27 Oct 26BrisbaneIn person$595Book
Power BI AdvancedTue 27 Oct 26MelbourneIn person$595Book
Power BI AdvancedFri 30 Oct 26CanberraIn person$595Book
Power BI AdvancedTue 3 Nov 26SydneyIn person$595Book
Power BI AdvancedTue 3 Nov 26BrisbaneIn person$595Book
Power BI AdvancedTue 10 Nov 26BrisbaneIn person$595Book
Power BI AdvancedTue 10 Nov 26SydneyIn person$595Book
Power BI AdvancedTue 17 Nov 26BrisbaneIn person$595Book
Power BI AdvancedTue 17 Nov 26SydneyIn person$595Book
Power BI AdvancedWed 18 Nov 26MelbourneIn person$595Book
Power BI AdvancedWed 18 Nov 26AdelaideIn person$595Book
Power BI AdvancedFri 20 Nov 26CanberraIn person$595Book
Power BI AdvancedWed 25 Nov 26MelbourneIn person$595Book
Power BI AdvancedFri 27 Nov 26SydneyIn person$595Book
Power BI AdvancedWed 16 Dec 26MelbourneIn person$595Book
Power BI AdvancedFri 18 Dec 26CanberraIn person$595Book
Power BI AdvancedWed 23 Dec 26MelbourneIn person$595Book
Power BI AdvancedWed 23 Dec 26AdelaideIn person$595Book

By city

Power BI Advanced in your city

Venue, transport and the dates running there.

Sydney training Melbourne training Brisbane training Perth training Adelaide training Canberra training Live online
The rest of the category

Other Power BI Levels

All Power BI levels
Power BI Intermediate training in progress
Level 2

Power BI Intermediate

Data modelling, relationships, DAX measures and reports that answer a question rather than show everything.

$595ex GSTLearn more
Power BI DAX training in progress
Level 4

Power BI DAX

The language behind the numbers — row and filter context, CALCULATE, table functions and ranking.

$595ex GSTLearn more
Reviews

What people said about Power BI Advanced

4.74
from 3119 reviews collected by Nexacu

Wizard courses run on the shared Nexacu schedule, so these are reviews of this course from people who sat it. Collected by Nexacu after the course and published as written.

All of it, especially the drill through and tooltips

Katrina
17 August 2026

Principles explained in a very satisfying way. Particularly DAX.

John
17 August 2026

Stephen is great and leaves no one behind with the content.The drill throughs, security and role/group applications are handy!

Andre E.
17 August 2026

instructor explained well

Zachary P.
19 August 2026

It was clearly delivered

Jocelyn
19 August 2026

Learnt a lot of new things I dismissed as not useful functions before such as drill through and tooltips

Dylan
19 August 2026

Source: nexacu.com.au, read 27 August 2026. How feedback is collected.

Questions

Questions People Ask About This Course

Anything not answered here, call 1300 886 190 and ask a person.

Ask a question
How long is the Power BI Advanced course?
It runs for 1 day, 9:00am – 4:00pm, with a facilitator in the room the whole time. Nothing is pre-recorded and there is no platform to log into afterwards.
How much does Power BI Advanced cost?
$595 per person, excluding GST. That covers the course, the workbook and exercise files and the room. If four or more people from one organisation need it, an in-house day usually works out cheaper — tell us the numbers and we will price both.
Do I need any experience before this course?
Yes — this level assumes Power BI Intermediate, or equivalent experience picked up on the job. If you are not sure, tell us what you already do and we will place you honestly, including telling you to book the level below.
Can I do Power BI Advanced online instead of in a classroom?
Yes. Every date marked “Live online” runs over video with the same facilitator and the same practice, in breakout groups rather than a room. You use the software on your own machine, so you leave with it set up the way you actually work.
Which cities do you run Power BI Advanced in?
Adelaide, Brisbane, Canberra, Melbourne, Perth and Sydney, plus live online. Every venue is a CBD training room with a workstation for each person. If your city and date are not paired on the schedule above, ask — dates are released in blocks.
Which Power BI level should I book?
Work from what people already do rather than how long they have used it. The full course outline above shows exactly what this course covers, and the Power BI page lists every level in order. Still unsure? Call 1300 886 190 and describe a normal Tuesday.

Whole team on the same level? Run it in-house.

Your files, your templates, your workflow — the same course, taught against your own material.

How in-house works Call 1300 886 190