Power BI Advanced Course
(4.89 out of 5) 1106 Student Reviews
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
Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
| 01-02 Jun 26 | Mon - Tue | 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 |
| 22-23 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 |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | 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 |
| 03-04 Sep 26 | Thu - Fri | Online Live |
| 10-11 Sep 26 | Thu - Fri | Online Live |
| 21-22 Sep 26 | Mon - Tue | Online Live |
| 30 Sep-01 Oct 26 | Wed - Thu | Classroom |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 27-28 Oct 26 | Tue - Wed | Classroom |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 25-26 Nov 26 | Wed - Thu | Classroom |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 15-16 Dec 26 | Tue - Wed | Online Live |
| 16-17 Dec 26 | Wed - Thu | Classroom |
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
| 01-02 Jun 26 | Mon - Tue | Online Live |
| 02-03 Jun 26 | Tue - Wed | Classroom |
| 11-12 Jun 26 | Thu - Fri | Online Live |
| 15-16 Jun 26 | Mon - Tue | Online Live |
| 22-23 Jun 26 | Mon - Tue | Online Live |
| 24-25 Jun 26 | Wed - Thu | Online Live |
| 02-03 Jul 26 | Thu - Fri | Online Live |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 14-15 Jul 26 | Tue - Wed | Classroom |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | Online Live |
| 27-28 Jul 26 | Mon - Tue | Online Live |
| 13-14 Aug 26 | Thu - Fri | Online Live |
| 20-21 Aug 26 | Thu - Fri | Classroom |
| 25-26 Aug 26 | Tue - Wed | Online Live |
| 03-04 Sep 26 | Thu - Fri | 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 |
| 06-07 Oct 26 | Tue - Wed | Classroom |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 04-05 Nov 26 | Wed - Thu | Classroom |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 03-04 Dec 26 | Thu - Fri | Classroom |
| 15-16 Dec 26 | Tue - Wed | Online Live |
Brisbane Class Dates
All courses facilitated in, Online Live format , QLD
| 01-02 Jun 26 | Mon - Tue | Online Live |
| 11-12 Jun 26 | Thu - Fri | Online Live |
| 15-16 Jun 26 | Mon - Tue | Online Live |
| 22-23 Jun 26 | Mon - Tue | Online Live |
| 24-25 Jun 26 | Wed - Thu | Online Live |
| 02-03 Jul 26 | Thu - Fri | Online Live |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | 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 |
| 03-04 Sep 26 | Thu - Fri | Online Live |
| 10-11 Sep 26 | Thu - Fri | Online Live |
| 21-22 Sep 26 | Mon - Tue | Online Live |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 15-16 Dec 26 | Tue - Wed | Online Live |
Canberra Class Dates
All courses facilitated in, Online Live format , ACT
| 01-02 Jun 26 | Mon - Tue | Online Live |
| 11-12 Jun 26 | Thu - Fri | Online Live |
| 15-16 Jun 26 | Mon - Tue | Online Live |
| 22-23 Jun 26 | Mon - Tue | Online Live |
| 24-25 Jun 26 | Wed - Thu | Online Live |
| 02-03 Jul 26 | Thu - Fri | Online Live |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | 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 |
| 03-04 Sep 26 | Thu - Fri | Online Live |
| 10-11 Sep 26 | Thu - Fri | Online Live |
| 21-22 Sep 26 | Mon - Tue | Online Live |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 15-16 Dec 26 | Tue - Wed | Online Live |
Adelaide Class Dates
All courses facilitated in, Online Live format , SA
| 01-02 Jun 26 | Mon - Tue | Online Live |
| 11-12 Jun 26 | Thu - Fri | Online Live |
| 15-16 Jun 26 | Mon - Tue | Online Live |
| 22-23 Jun 26 | Mon - Tue | Online Live |
| 24-25 Jun 26 | Wed - Thu | Online Live |
| 02-03 Jul 26 | Thu - Fri | Online Live |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | 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 |
| 03-04 Sep 26 | Thu - Fri | Online Live |
| 10-11 Sep 26 | Thu - Fri | Online Live |
| 21-22 Sep 26 | Mon - Tue | Online Live |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 15-16 Dec 26 | Tue - Wed | Online Live |
Perth Class Dates
All courses facilitated in, Online Live format , WA
| 01-02 Jun 26 | Mon - Tue | Online Live |
| 11-12 Jun 26 | Thu - Fri | Online Live |
| 15-16 Jun 26 | Mon - Tue | Online Live |
| 22-23 Jun 26 | Mon - Tue | Online Live |
| 24-25 Jun 26 | Wed - Thu | Online Live |
| 02-03 Jul 26 | Thu - Fri | Online Live |
| 09-10 Jul 26 | Thu - Fri | Online Live |
| 15-16 Jul 26 | Wed - Thu | Online Live |
| 21-22 Jul 26 | Tue - Wed | 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 |
| 03-04 Sep 26 | Thu - Fri | Online Live |
| 10-11 Sep 26 | Thu - Fri | Online Live |
| 21-22 Sep 26 | Mon - Tue | Online Live |
| 06-07 Oct 26 | Tue - Wed | Online Live |
| 19-20 Oct 26 | Mon - Tue | Online Live |
| 05-06 Nov 26 | Thu - Fri | Online Live |
| 18-19 Nov 26 | Wed - Thu | Online Live |
| 30 Nov-01 Dec 26 | Mon - Tue | Online Live |
| 15-16 Dec 26 | Tue - Wed | Online Live |
Course Units
⊕ Expand full topic list
Unit 1: Introduction
- Overview of BI Process
- Overview of Different Power BI Products
- Latest Features and Top Enhancements in Power BI
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 4: Fuzzy Match
- Using Fuzzy Match to Merge Queries
- Changing Similarity Threshold
- Working with Fuzzy Merge Options
- Creating and Using Transformation Table
⊕ See more
Unit 5: Data Profiling
- What is Data Profiling and its use case?
- Column Distribution
- Column Quality
- Column Profile
⊕ See more
Unit 6: Converting Flat File into a Data Model
- Duplicate Queries
- Removing Columns
- Removing Duplicates
- Building Relationships
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 10: DAX Introduction and Core Concepts
- Understanding DAX Rules and Concepts
- Filter Context
- Row Context
- Calculated Columns
- Calculated Measures
- Calculated Tables
⊕ See more
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
⊕ See more
Unit 12: Quick Measures
- Introduction to Quick Measures
- Quick Measure - Year to Date
- Quick Measure - Filter
- Quick Measure - Rolling Average
- Quick Measure - Percentage Difference
⊕ See more
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
⊕ See more
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
⊕ See more
Unit 15: AI Enhanced Visualization
- What are AI visuals?
- Key Influencer Visual
- Clustering using Scatter Chart
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Training Packages
Power BI Training Package
Related Courses
Student Reviews
Great session. This is definitely for advanced users where a certain amount of foundation is required but the instructor also went over the fundamentals for the other students. Went over really good tips and tricks learning powerful functions to overcome problems such as cross functions. Went over performance analysis of DAX vs M language. Powerful tool for real world problems
Course was well structured. One suggestion is having a 30 min introduction on the basics in PowerBI to have the continuity in going through the advanced course.
The course was comprehensive but still easy to follow and immediately applicable. Our instructor did a really good job running the two days and answering questions, offering extension information where appropriate and being flexible to the needs/interests of our group.
It was a great course with lots of concepts covered in good time. The instructor, was very excellent. I found a lot of value in this and will be applying all the concepts learned over the last 2 days in my work place.
Gordana was excellent. She was very patient and, despite all my random questions, managed to answer them whilst still keeping the course on track and flowing well. Gordana was always willing for us to share our screen, and she would spend the time needed to help us to catch up with everyone else.
Very knowledgeable instructor and the content was well structured. I feel like I needed more time and examples to understand the concept of data modelling in more detail.
Great course, really valuable to learn more topics in PowerBI. Gordana was very knowledgeable and presented the information in a way that was easy to understand. It would be nice to have some examples that don't involve Purchasing data as that's not my focus ;) but very useful anyway.
I found the course very useful in terms of pointing out how to do things in Power BI and will definitely help me with my own Power BI Reporting Requirements.
Definitely one of the best trainings I have done. It's a steep learning curve for me but Paul has been patiently run through the steps for us. I'd love to take another course led by him (I was thinking Python).
This is a resit of the course for me. I have really enjoyed the content and the pace. Adam was fantastic. Very engaging. It felt like a different course, not sure if that is because the information was not being heard for the first time, or if it was presented so differently. I think it is actually the later. Would recommend and request Adam again.
The course was very productive. Adam is so smart and polite, always coming across our questions easily. The content of the course attended my expectations, but I could have one more day, to explore more DAX formulas using our day work.
The session was excellent. The content was in-depth and delivered in a clear, easy-to-understand way. Adam is an outstanding instructor who explained complex concepts very well. He answered all of our ad hoc questions throughout the session and integrated them seamlessly into the course content. This made the training practical and engaging.
Great explanation and demonstration. All my questions were answered, and very satisfied with the course.
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.
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.
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.
Book our 4 core Power BI course together and
SAVE $330
For more info please
Call 1300 888 724