Full star Half star Star PDF
The Ultimate Training Experience.

Power BI Advanced Course

(4.89 out of 5) 1085 Student Reviews

Microsoft Partner - Dynamic Web Training

About the Course

This 2-day course covers the latest functionalities and updates in Power BI while diving deep into practical solutions of the common challenges faced by a business user while performing analytics. During this course, students will learn how to perform more sophisticated data manipulations, best practices and do’s and don’ts of data modelling, AI-enhanced features and visuals and managing the security to build an enterprise-level solution.

Who should do this course?

This course is suitable for business users who wants to implement BI to create reports and dashboard or SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

This Power BI course is suitable for the people who have completed the Power BI essentials course or have equivalent skills. Familiarity with interface and navigation of Microsoft Power BI Desktop tool is required.

Course Details

$990 incl GST

  • Duration:2 Days
  • Max. Class Size:10
  • Avg. Class Size:5
  • Study Mode:
    Classroom Online Live
  • Level:Advanced
  • CPD Hours:12 hours
  • Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
  • Download Course PDF
Pay Later

Course Dates

Sydney Class Dates

Level 11, 32 Walker Street, North Sydney , NSW 2060

10-11 Mar 26 Tue - Wed Online Live
17-18 Mar 26 Tue - Wed Classroom
19-20 Mar 26 Thu - Fri Online Live
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
15-16 Apr 26 Wed - Thu Classroom
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
07-08 May 26 Thu - Fri Online Live
12-13 May 26 Tue - Wed Classroom
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
04-05 Jun 26 Thu - Fri Online Live
10-11 Jun 26 Wed - Thu Classroom
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
07-08 Jul 26 Tue - Wed Classroom
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
05-06 Aug 26 Wed - Thu Classroom
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
01-02 Sep 26 Tue - Wed Classroom
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live
Melbourne Class Dates

Level 12, 379 Collins Street, Melbourne , VIC 3000

10-11 Mar 26 Tue - Wed Online Live
19-20 Mar 26 Thu - Fri Online Live
24-25 Mar 26 Tue - Wed Classroom
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Classroom
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
04-05 May 26 Mon - Tue Classroom
07-08 May 26 Thu - Fri Online Live
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
02-03 Jun 26 Tue - Wed Classroom
04-05 Jun 26 Thu - Fri Online Live
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
23-24 Jun 26 Tue - Wed Classroom
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
14-15 Jul 26 Tue - Wed Classroom
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
11-12 Aug 26 Tue - Wed Classroom
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
07-08 Sep 26 Mon - Tue Classroom
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live
Brisbane Class Dates

All courses facilitated in, Online Live format , QLD

10-11 Mar 26 Tue - Wed Online Live
19-20 Mar 26 Thu - Fri Online Live
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
07-08 May 26 Thu - Fri Online Live
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
04-05 Jun 26 Thu - Fri Online Live
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live
Canberra Class Dates

All courses facilitated in, Online Live format , ACT

10-11 Mar 26 Tue - Wed Online Live
19-20 Mar 26 Thu - Fri Online Live
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
07-08 May 26 Thu - Fri Online Live
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
04-05 Jun 26 Thu - Fri Online Live
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live
Adelaide Class Dates

All courses facilitated in, Online Live format , SA

10-11 Mar 26 Tue - Wed Online Live
19-20 Mar 26 Thu - Fri Online Live
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
07-08 May 26 Thu - Fri Online Live
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
04-05 Jun 26 Thu - Fri Online Live
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live
Perth Class Dates

All courses facilitated in, Online Live format , WA

10-11 Mar 26 Tue - Wed Online Live
19-20 Mar 26 Thu - Fri Online Live
26-27 Mar 26 Thu - Fri Online Live
01-02 Apr 26 Wed - Thu Online Live
09-10 Apr 26 Thu - Fri Online Live
13-14 Apr 26 Mon - Tue Online Live
22-23 Apr 26 Wed - Thu Online Live
28-29 Apr 26 Tue - Wed Online Live
07-08 May 26 Thu - Fri Online Live
13-14 May 26 Wed - Thu Online Live
18-19 May 26 Mon - Tue Online Live
26-27 May 26 Tue - Wed Online Live
04-05 Jun 26 Thu - Fri Online Live
11-12 Jun 26 Thu - Fri Online Live
15-16 Jun 26 Mon - Tue Online Live
24-25 Jun 26 Wed - Thu Online Live
02-03 Jul 26 Thu - Fri Online Live
15-16 Jul 26 Wed - Thu Online Live
27-28 Jul 26 Mon - Tue Online Live
13-14 Aug 26 Thu - Fri Online Live
25-26 Aug 26 Tue - Wed Online Live
10-11 Sep 26 Thu - Fri Online Live
21-22 Sep 26 Mon - Tue Online Live

Course Units

Unit 1: Introduction

  • Overview of BI Process
  • Overview of Different Power BI Products
  • Latest Features and Top Enhancements in Power BI

Unit 2: Power Query - Advanced Data Transformation

  • Data Transformation Principle
  • Pivot and Unpivot
  • Merging Queries
  • Appending Queries
  • Using Basic Group By functionality
  • Using Advanced Group by Functionality
  • Choosing Columns
  • Duplicating a Query
  • Referencing a Query
  • Difference between Duplicate and Reference
  • Extracting Columns
  • Formatting Columns
  • Copying Queries across reports

Unit 3: Power Query - Creating Columns

  • Creating Date Columns
  • Creating Standard Columns
  • Creating Scientific Columns
  • Creating Statistical Columns
  • Creating Information Columns
  • Creating Index Columns
  • Creating Conditional Columns
  • Creating Custom Columns
  • Creating Columns by Examples

Unit 4: Fuzzy Match

  • Using Fuzzy Match to Merge Queries
  • Changing Similarity Threshold
  • Working with Fuzzy Merge Options
  • Creating and Using Transformation Table

Unit 5: Data Profiling

  • What is Data Profiling and its use case?
  • Column Distribution
  • Column Quality
  • Column Profile

Unit 6: Converting Flat File into a Data Model

  • Duplicate Queries
  • Removing Columns
  • Removing Duplicates
  • Building Relationships

Unit 7: Data Modelling - Fundamental Concepts

  • Understanding a Data Model
  • Understanding a Fact Table
  • Understanding a Data Table
  • What Is a Dimension?
  • Working with Look-Up Table
  • Understanding Star Schema
  • Understanding Snow Flake Schema
  • How Filter Propagation Work?
  • Understanding Double Vs Single Cross Filtering Direction
  • Understanding Active Vs Inactive Relationships

Unit 8: Data Modelling - Common Issues and Solutions

  • What Questions To Ask Before Starting?
  • Good Practices of Data Modelling
  • Having No Unique Identifier
  • Relation between Two Different Dimensions
  • Understanding Loops
  • Creation of Surrogate Key
  • Creation of Bridge/Fact-Less Fact Table
  • Creation of Calculated Tables
  • Building Calendar Table

Unit 9: Latest Features in Data Modelling

  • Many to Many Relationship
  • Applying Security Filter in Both Direction
  • Working with Views and Perspectives
  • Composite Model
  • Writing Properties for Tool Tip
  • Creating Hierarchies

Unit 10: DAX Introduction and Core Concepts

  • Understanding DAX Rules and Concepts
  • Filter Context
  • Row Context
  • Calculated Columns
  • Calculated Measures
  • Calculated Tables

Unit 11: Common DAX Functions

  • Related/Related Table function
  • Sum function
  • Count Function
  • SumX function
  • Calculate function
  • Filter Function
  • Userelationship function
  • Using Variables for DAX

Unit 12: Quick Measures

  • Introduction to Quick Measures
  • Quick Measure - Year to Date
  • Quick Measure - Filter
  • Quick Measure - Rolling Average
  • Quick Measure - Percentage Difference

Unit 13: Data Visualization

  • Drilling through Filters across Reports
  • Creating KPI Score Card
  • Working With Uni Char Symbols
  • Slicer Synchronization across Multiple Pages
  • Working With Selection and Book Marks Pane
  • Q&A Improvements
  • Creating infographics

Unit 14: Conditional Formatting in Power BI

  • By Back Ground Colour
  • By Font Colour
  • Data Bar
  • By Rule
  • By Another Column
  • Dynamic Chart Titles
  • Switch DAX Function
  • For Chart Visuals using Measures

Unit 15: AI Enhanced Visualization

  • What are AI visuals?
  • Key Influencer Visual
  • Clustering using Scatter Chart

Unit 16: Performance Analyzer

  • What is Performance Analyzer?
  • Start Recording
  • Understanding the Results
  • Drilling Down into the Visual
  • Renaming the visual using Selection Pane
  • Analyze Results to Modify Slicer
  • Analyze Results to Refresh a Particular Visual

Unit 17: Working with Row Level Security

  • Creating Roles
  • Writing Table Filter Expressions for a Single Field
  • Writing Table Filter Expressions for Multiple Fields
  • Viewing as Roles
  • Creating Dynamic Row Level Security
  • Creating Dynamic Row Level Security According to
  • Reporting Line
  • Assigning Members to Roles
  • URL Filtering
  • Dynamic URL Filtering

Unit 18: Work Space App

  • Testing Scenarios in Power Bi Service
  • Creating Work Space Apps
  • Assigning Permissions in Work space Apps
  • Collaborating on Shared Reports
  • Sharing Reports Using Apps

Unit 19: Working with Parameters and Functions

  • Create New Parameter
  • Importing web query using parameter
  • Creating functions
  • Invoking functions
  • Defining a list
  • Converting List to Table
  • Adding Column by invoking custom functions

Training Packages

Power BI Training Package

$ 2541 incl GST
(You save $330)
Total Duration
6 days
Pay Later

Related Courses

Power BI Essentials Course
Power BI Essentials
(4.85 out of 5)
$396.00
Learn More
Power BI Report Design Course
Power BI Report Design
(4.87 out of 5)
$495.00
Learn More
Power BI DAX Essentials Course
Power BI DAX Essentials
(4.91 out of 5)
$990.00
Learn More
ChatGPT Essentials for Data Analytics Course
ChatGPT Essentials for Data Analytics
(4.77 out of 5)
$594.00
Learn More

Student Reviews

(5.0)
02 March, 2026

Great explanation and demonstration. All my questions were answered, and very satisfied with the course.

Sharmila D
(4.7)
02 March, 2026

This course was very useful and Paul is very good at explaining. Got through a lot of different features. Would have liked more time at the end to ask questions even if that meant staying over.

Beth C
(4.4)
02 March, 2026

Paul was a great instructor. He kept it interesting and engaging over the two days. He kept everyone up to speed and didn't have anyone fall behind. Even his jokes were good.

Jim C
(5.0)
02 March, 2026

It was a great course with Paul. Even I have done the course 8 months ago with Adam, it's very valuable to have this opportunity to resit the course. I learnt a lot of new things, as well as refreshed for the things I learnt before. I really like the error table, and there're a few other things I learnt in a different way. A resit with a different instructor is highly recommended.

Shirley Z
(4.1)
17 February, 2026

The course covered a wide range of topics and was very informative, with excellent practical exercises and real-world data sets.

Gaganpreet K
(5.0)
04 February, 2026

It has been a very helpful course - the instructor is knowledgeable and is always willing to answer questions and provide clarifications.

Leann
(5.0)
04 February, 2026

Excellent course, delves deeper into the Power BI data and models, helps to understand the bigger picture and the way Power BI works in great detail as well. Adam was a great instructor, providing lots of examples and making sure everyone is on the same page. Very patient and enthusiastic.

Dagmara L
(5.0)
15 January, 2026

The course content covered everything that I wanted to know about that wasn't in the previous two courses. The instructor was extremely engaging and went above and beyond to ensure everyone was catered to.

Luke
(5.0)
18 December, 2025

The presenter, Danny, was wonderful. He provided clear information and was exceptionally knowledgeable. The course content was great.

Lisa E
(5.0)
18 December, 2025

The course was well structured and covered key Power BI concepts in a logical sequence. The hands-on exercises were particularly valuable and helped reinforce the theory. The trainer explained concepts clearly and was responsive to questions. To further improve the course, more time could be allocated to practical exercises and real-world scenarios, particularly around data modelling and performance considerations. Overall, it was a useful and informative course.

Virginia W
(5.0)
18 December, 2025

Trainer Danny has been fantastic during this course. Very knowledgeable onh all topics and able to connect queries to real time examples.

Desiree T
(5.0)
18 December, 2025

It is a great course to recap my previous knowledge and explore new Power BI functions. The trainer is really, really good

Frank H
(5.0)
17 December, 2025

Training was interesting. Learned some new tricks. Some topics I am aware of already and would have loved to get more complex DAX measure examples.

Arjay L
(4.9)
10 December, 2025

This course sets up to start working to produce PowerBI reports, with efficiencies. Instructor has excellent experience.

Julie G
(5.0)
08 December, 2025

I appreciated the opportunity to redo the course, the professionalism of the presenter and the quality of presentation.

Allan M
Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Note: Form fields marked with * are required.

Your details
Please enter a valid email address for shipping updates.
I am enquiring about a...
Complete Power BI Package

Book our 4 core Power BI course together and
SAVE $330


For more info please

Call 1300 888 724

View Package Details

REQUEST A CALLBACK
A team member will call you at a time convenient to you.
Your message was sent, thank you!
Contact us

Level 11, 32 Walker Street, North Sydney NSW, 2060