Level 1
Power BI Beginner
Connecting to data, shaping it, and building your first report and dashboard.
$395ex GSTLearn more
Level 2
Microsoft
1 day
Power BI Intermediate Course
Power BI Intermediate 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 Beginner
- 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.
- Star schema, relationships, and why the totals were wrong
- Measures versus calculated columns
- Time intelligence basics
- Report design that answers a question
Course overview.
Data modelling, relationships, DAX measures and reports that answer a question rather than show everything.
The 1 day works through 13 modules and 68 individual topics, from Data model and transformation to Power BI Service. 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.
-
1Data model and transformation6 topics
- Principles of data transformation
- Fact tables and dimension tables
- What the data model is
- The star schema
- The snowflake schema
- Tuning the data model
-
2Get Data9 topics
- Choosing a data source
- Loading the dataset from Excel
- The From Folder option
- Opening Power Query Editor
- Around the Power Query interface
- The Queries pane
- The Data pane
- The Ribbon
- The Query Settings pane
-
3Data transformations14 topics
- The data model in Desktop
- Filtering data
- Renaming queries
- Removing columns
- Unpivoting columns
- Adding conditional columns
- Filling values up or down
- Reordering columns
- Combining queries
- Appending queries
- Merging queries
- Replacing values
- Building custom columns
- Checking and changing column data types
-
4Date transformations5 topics
- The Auto Date/Time setting
- Building a date dimension table
- Making the date dimension table dynamic
- Pulling date parts out as columns
- Fiscal quarters and fiscal years
-
5Loading data3 topics
- The Include in report refresh option
- The Enable load option
- Applying changes with Close and Apply
-
6Data modelling7 topics
- Why a good data model matters
- Managing relationships
- Cardinality in relationships
- Setting cross-filter direction
- Common cardinality and cross-filtering setups
- A look at the dataset
- Changing data formats
-
7Data Analysis Expressions (DAX)5 topics
- What DAX is for
- M (Power Query) language compared with DAX
- Writing and using a calculated column
- Writing and using measures
- A few simple DAX functions
-
8The X functions2 topics
- Row-by-row calculation inside a measure
- X functions compared with aggregators and calculated columns
-
9Quick measures5 topics
- The quick measure categories
- Aggregating per category
- Filters and CALCULATE
- Maths operations
- Text quick measures
-
10Time intelligence quick measures4 topics
- The auto date/time option
- Marking a table as the date table
- Visuals suited to date/time reporting
- Building a quick measure on an existing measure
-
11Field parameters3 topics
- Creating two field parameters
- Switching the slicer to single select
- Adding a bar chart driven by the parameters
-
12Bookmarks and buttons1 topic
- Formatting the buttons and attaching bookmarks
-
13Power BI Service4 topics
- Workspaces: creating a new workspace and adding people
- Comparing the access rights
- Returning to PBI Desktop
- Saving and publishing the report to your workspace
Who it is for.
People who are comfortable with the basics and have hit the ceiling of what they worked out for themselves.
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 Intermediate dates, soonest first. If none of these work, tell us the city and we will let you know when the next block is released.
| Level | Date | Location | Delivery | Price | |
|---|---|---|---|---|---|
| Power BI Intermediate | Mon 31 Aug 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Mon 31 Aug 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Tue 1 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Tue 1 Sep 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Tue 1 Sep 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Wed 2 Sep 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Wed 2 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 2 Sep 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Fri 4 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Fri 4 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Tue 8 Sep 26 | Remote West | Online | $595 | Book |
| Power BI Intermediate | Tue 8 Sep 26 | Perth | In person | $595 | Book |
| Power BI Intermediate | Tue 8 Sep 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Wed 9 Sep 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Wed 9 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 9 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 9 Sep 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Wed 9 Sep 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Fri 11 Sep 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Fri 11 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Mon 14 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Mon 14 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Tue 15 Sep 26 | Perth | In person | $595 | Book |
| Power BI Intermediate | Tue 15 Sep 26 | Remote West | Online | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Wed 16 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Tue 22 Sep 26 | Remote West | Online | $595 | Book |
| Power BI Intermediate | Tue 22 Sep 26 | Perth | In person | $595 | Book |
| Power BI Intermediate | Wed 23 Sep 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Wed 23 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 23 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 23 Sep 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Thu 24 Sep 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Thu 24 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Thu 24 Sep 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Tue 29 Sep 26 | Adelaide | In person | $595 | Sold out |
| Power BI Intermediate | Tue 29 Sep 26 | Remote West | Online | $595 | Book |
| Power BI Intermediate | Tue 29 Sep 26 | Perth | In person | $595 | Book |
| Power BI Intermediate | Wed 30 Sep 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 30 Sep 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Wed 30 Sep 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 30 Sep 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Wed 30 Sep 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Thu 1 Oct 26 | Brisbane | In person | $595 | Book |
| Power BI Intermediate | Thu 1 Oct 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Thu 1 Oct 26 | Sydney | In person | $595 | Book |
| Power BI Intermediate | Wed 7 Oct 26 | Adelaide | In person | $595 | Book |
| Power BI Intermediate | Wed 7 Oct 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 7 Oct 26 | Remote West | Online | $595 | Book |
| Power BI Intermediate | Wed 7 Oct 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 7 Oct 26 | Perth | In person | $595 | Book |
| Power BI Intermediate | Wed 14 Oct 26 | Remote East | Online | $595 | Book |
| Power BI Intermediate | Wed 14 Oct 26 | Adelaide | In person | $595 | Sold out |
| Power BI Intermediate | Wed 14 Oct 26 | Melbourne | In person | $595 | Book |
| Power BI Intermediate | Wed 14 Oct 26 | Canberra | In person | $595 | Book |
| Power BI Intermediate | Fri 16 Oct 26 | Remote West | Online | $595 | Book |
By city
Power BI Intermediate in your city
Venue, transport and the dates running there.
The rest of the category
All Power BI levels Other Power BI Levels
Level 3
Power BI Advanced
Advanced DAX, time intelligence, row-level security, performance and publishing to the workspace.
$595ex GSTLearn more
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 Intermediate
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.
The course material and Power BI features were demonstrated clearly and effectively. At times, the pace was a little fast, which made it challenging to follow all the steps. However, the instructor was very accommodating and happy to repeat the demonstrations when needed, ensuring that everyone in the class could keep up and remain on the same page.
Bernie
24 August 2026
Need to get participants to read the guides prior to the course. Will help bridge the gap between the theory and then what to select within the system.
Krystal
24 August 2026
Creating bookmarks and visualizing.
James
24 August 2026
powerquery and dax,
Joel
25 August 2026
Very straight forward instructions and moved at an easy to follow pace, which made things easy
Mathew
25 August 2026
working through some of the features.
Aluette
25 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.
How long is the Power BI Intermediate 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 Intermediate 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 Beginner, 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 Intermediate 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 Intermediate 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.