Power BI Advanced Training Course
Power Bi Advanced Training Course helps business users to meet their work challenges by introducing them to the latest features such as fuzzy matching, AI visuals, and Row Level Security. This course is a complete walk-through of the BI process from data modeling, data cleaning, data manipulation, and data wrangling to data visualization using AI-enhanced visuals and infographics.
What is Included With The Microsoft Power BI Advanced Training Course
Small Class Size
Developed and Guided Learning Content
Certificate of Attendance
Highly Skilled Trainers
Our Price Beat Guarantee
Email Support
About this course:
This course helps business users to meet their work challenges by introducing them to the latest features such as fuzzy matching, AI visuals, and Row Level Security. This course is a complete walk-through of the BI process from data modeling, data cleaning, data manipulation, and data mugging to data visualization using AI-enhanced visuals and infographics. This course also introduces you to DAX and helps you build a sound foundation of DAX in Power BI based on your Excel/SQL knowledge.Prerequisites:
This course is suitable for users who are familiar with the Power BI tool. The users are expected to have completed the Power BI Essentials course or have equivalent skills. An experience in Excel with Basic VLOOKUP and Pivot table is a plus.Who should take this course?
This course is suitable for users who want to learn how to implement Business Intelligence solutions using top-notch modeling and visualization techniques. This course is also a perfect choice for users who have developed SQL reports and are looking for ways to develop visually appealing and best-performing dashboards.Course Duration: 2 Days
Skill Level: Advanced
Add-ons:
- Small Class size
- Developed and Guided learning content
- Completion certificate
- Taught by Industry Pros
- Free re-sit
- Email support
- Printed Manual
- Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth
- Online
- Classroom
- $990 Including Tax
- 9.00 am to 5.00 pm approx
Send download link to:
Sydney Class Dates
Sydney Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
07-08 Dec 23 | Thu-Fri | Classroom |
11-12 Dec 23 | Mon-Tue | Online Live |
18-19 Jan 24 | Thu-Fri | Online Live |
22-23 Jan 24 | Mon-Tue | Classroom |
Melbourne Class Dates
Melbourne Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
11-12 Dec 23 | Mon-Tue | Online Live |
13-14 Dec 23 | Wed-Thu | Classroom |
16-17 Jan 23 | Tue-Wed | Classroom |
18-19 Jan 24 | Thu-Fri | Online Live |
Brisbane Class Dates
Brisbane Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
11-12 Dec 23 | Mon-Tue | Online Live |
19-20 Dec 23 | Tue-Wed | Classroom |
15-16 Jan 24 | Mon-Tue | Classroom |
18-19 Jan 24 | Thu-Fri | Online Live |
Canberra Class Dates
Canberra Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
11-12 Dec 23 | Mon-Tue | Online Live |
18-19 Jan 24 | Thu-Fri | Online Live |
30-31 Jan 24 | Tue-Wed | Online Live |
15-16 Feb 24 | Thu-Fri | Online Live |
Adelaide Class Dates
Adelaide Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
11-12 Dec 23 | Mon-Tue | Online Live |
18-19 Jan 24 | Thu-Fri | Online Live |
30-31 Jan 24 | Tue-Wed | Online Live |
15-16 Feb 24 | Thu-Fri | Online Live |
Perth Class Dates
Perth Class Dates | Days | Training Mode |
30 Nov-01 Dec 23 | Thu-Fri | Online Live |
11-12 Dec 23 | Mon-Tue | Online Live |
18-19 Jan 24 | Thu-Fri | Online Live |
30-31 Jan 24 | Tue-Wed | Online Live |
15-16 Feb 24 | Thu-Fri | Online Live |

Learning Experience
Course Outline
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 the Snowflake Schema
✅ How does 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 Filters in Both Directions
✅ 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 the Selection and Bookmarks Pane
✅ Q&A Improvements
✅ Creating infographics
Unit 14 : Conditional Formatting in Power BI
✅ By Background Color
✅ By Font Color
✅ 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 Workspace Apps
✅ Assigning Permissions in Workspace Apps
✅ Collaborating on Shared Reports
✅ Sharing Reports Using Apps
Unit 19: Working with Parameters and Functions
✅ Create a New Parameter
✅ Importing web query using parameter
✅ Creating functions
✅ Invoking functions
✅ Defining a list
✅ Converting List to Table
✅ Adding Column by invoking custom functions
Related Courses
We are running multiple classes every month across Australia. Please complete the below form and one of our representatives will contact you shortly.
For more information on upcoming
Power BI Advanced Course
You will be redirected to our official training partner Dynamic Web Training
For Group Discounts
Why Power BI?

Business Intelligence Market
Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner

Jobs Opportunities
70 percent of the leading companies say that Analytics is integral to how they make decisions – IBM Survey

Career Growth
A Senior Business Intelligence Analyst can earn $89,000 in the United States – PayScale
Some of the companies that experienced Power BI Training With Our Trainers










