Power BI Advanced Training Courses
Learn advanced Power BI reporting, DAX and data modelling techniques for more effective business intelligence.
Learn advanced Power BI reporting, DAX and data modelling techniques for more effective business intelligence.
4.74
Power BI Advanced Course
Nexacu’s Power BI Advanced course helps experienced users streamline report creation, work with complex data models and apply advanced reporting techniques in Power BI Desktop.
Training is instructor-led and available in-class or remotely. To attend online, select Remote East or Remote West when booking.
Power BI users, analysts, reporting teams, data professionals and business users who already have intermediate Power BI skills and want to build more advanced reports, data models and reporting workflows.
Work with DAX filter context, role-playing dimensions, multiple date-dimension tables, dynamic row-level security, drill-through, custom tooltips and advanced report navigation.
Prerequisite: Intermediate Power BI skills are recommended, including data import, Power Query, visualisations, filters, basic data modelling, calculated fields and row-level security.
This course can form part of the PL-300 Power BI Certification pathway. Certification is earned separately by meeting the relevant Microsoft certification requirements and passing the required exam.
Power BI Advanced is a one-day instructor-led training course for users with intermediate Power BI skills who want to deepen their reporting, modelling and DAX capability. It covers filter context, DAX measures, dynamic row-level security and advanced report navigation for practical workplace reporting.
This advanced Power BI training course is designed for learners who already understand the core Power BI workflow and want to extend their capability across reporting, modelling, calculations and security.
The course builds on intermediate Power BI knowledge by exploring how DAX measures are evaluated, how filter context affects calculations, and how relationship behaviour can influence reporting outcomes.
Participants also work with advanced report features such as drill-through, custom report tooltips, navigation buttons and dynamic row-level security. These skills are useful for workplace reporting scenarios where users need clearer report navigation, better data control and more flexible analysis.
Additional exercises include API data sources, JSON responses, data streaming, folder queries and Power Query M language, helping learners understand more advanced ways to connect, prepare and structure data for Power BI reports.
Course Benefits
Develop practical skills in advanced reporting, data modelling, DAX, report navigation and row-level security.
Power BI Advanced is best suited to learners with intermediate Power BI skills who want to improve reporting, modelling, DAX and security workflows.
Not sure which Power BI course to choose? Use the Course Finder for a quick recommendation.
Course Finder
Answer 10 quick questions to get a course recommendation based on your current Power BI skills, reporting goals and certification needs.
Recommended course
This course is recommended based on your answers.
View recommended courseStill unsure? Take Nexacu’s Power BI Skills Test for a more in-depth skills check before choosing your course.
Course Benefits
Develop practical skills in advanced reporting, data modelling, DAX, report navigation and row-level security.
Power BI Advanced is best suited to learners with intermediate Power BI skills who want to improve reporting, modelling, DAX and security workflows.
Not sure which Power BI course to choose? Use the Course Finder for a quick recommendation.
Course Finder
Answer 10 quick questions to get a course recommendation based on your current Power BI skills, reporting goals and certification needs.
Recommended course
This course is recommended based on your answers.
View recommended courseStill unsure? Take Nexacu’s Power BI Skills Test for a more in-depth skills check before choosing your course.
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Power BI Course Introduction
Overview of Power BI
Power BI Data Model
Data modelling in the real world
The dataset
Report Themes, Parameters and Templates
Report themes
Parameters for changing the data source
Report templates
Advanced Slicing in Power BI
Working with multiple date dimension tables
Create a date dimension table using DAX
Role-playing dimensions
Create hierarchies
DAX Measures and Filter Context
What is DAX?
DAX measures
Measures table
Filters on a measure
Filter context
DAX Measure Evaluation
Measure evaluation with empty filter context
Measure evaluation with propagation of filters
Adding to the filter context
Using DAX to modify the filter context
Dynamic Row-Level Security in Power BI
USERNAME
Parent-child hierarchy
PATH
LOOKUPVALUE
Dynamic row-level security
Publish and test RLS
Data Streaming Exercise
Stream data from PubNub
Basic Filtering with CALCULATE
CALCULATE basics
CALCULATE with simple filters
Filter behaviour
CALCULATE with table expression filters
CALCULATE and Filter Modifiers
USERELATIONSHIP
REMOVEFILTERS
ALLSELECTED
KEEPFILTERS
CROSSFILTER
Filter context follows relationships
Bidirectional cross filtering
Temporarily change the cross-filter direction
Advanced Power BI Report Features
Bin data
Group data
Drill through
Custom report tooltips
Manually setting a report tooltip
Add navigation
Page navigator
Page navigation buttons
Drill-through buttons
API Data Sources Exercise
Query a real API data source
HTTP and JSON terminology
Transform a JSON response
Publish to the Power BI service
Files in Folders Exercise
Query a folder of files
Column consistency
Understanding the folder query
View query dependencies
Power Query M Language Exercise
Syntax
Special identifiers and hash syntax
The let and in statements
Basic exercises in M
Values, records and lists
Operators
Power Query M Language Exercise Continued
Conditional testing using if
Errors and error handling
Accessing table data
More advanced M language exercises
Each expression
Refer to other queries
Understanding a web query
Remove rows by filtering
What is the Power BI Advanced course?
Power BI Advanced is a one-day instructor-led course for experienced Power BI users who want to deepen their reporting, modelling and DAX capability. It focuses on practical techniques for building more flexible, interactive and sophisticated business intelligence reports in Power BI Desktop.
What will I learn in the Power BI Advanced course?
You will learn advanced Power BI techniques including DAX evaluation, filter context, CALCULATE, role-playing dimensions, multiple date-dimension tables, dynamic row-level security, drill-through, custom tooltips and report navigation.
Who should attend this Power BI Advanced course?
This course is suitable for Power BI users, analysts, reporting teams, data professionals and business intelligence users who already have intermediate Power BI skills and want to build more advanced reports and reporting workflows.
Do I need Power BI experience before attending?
Yes. Intermediate Power BI skills are recommended before attending. Participants should be familiar with data import, Power Query, visualisations, filters, basic data modelling, calculated fields and row-level security.
Is Power BI Advanced suitable after Power BI Intermediate?
Yes. Power BI Advanced is a suitable next step after Power BI Intermediate. It builds on intermediate reporting and modelling skills by introducing more advanced DAX, filter context, security and report navigation techniques.
Does the Power BI Advanced course cover DAX?
Yes. The course covers DAX evaluation, DAX measures, filter context, CALCULATE and filter modifiers. These topics help participants understand how Power BI calculations respond to different filters, relationships and reporting scenarios.
Does the course cover dynamic row-level security?
Yes. The course covers dynamic row-level security, including USERNAME, parent-child hierarchy concepts, PATH, LOOKUPVALUE, publishing and testing RLS. This helps participants understand how report access and data visibility can be managed in Power BI.
What advanced Power BI report features are covered?
The course covers advanced report features including drill-through, custom report tooltips, page navigation, navigation buttons, report themes and templates. Participants also work with multiple date-dimension tables and role-playing dimensions.
Can I take Power BI Advanced online?
Yes. Nexacu offers Power BI Advanced as instructor-led live online training, with face-to-face options also available where scheduled. To attend remotely, select Remote East or Remote West as your location when booking. Remote training is delivered live by an instructor, not as a self-paced video course.
What is the difference between Power BI Advanced and Power BI DAX?
Power BI Advanced covers DAX as part of a broader advanced course that also includes data modelling, report features, dynamic row-level security and Power Query M exercises. Power BI DAX is a dedicated course for learners who want to focus more deeply on DAX calculations, functions, contexts and calculation logic.
Is Power BI Advanced part of the PL-300 certification pathway?
Yes. Power BI Advanced can be taken as part of Nexacu’s PL-300 Power BI Certification pathway. Microsoft certification is earned separately by meeting the relevant Microsoft certification requirements and passing the required exam.
What Power BI course should I take after Power BI Advanced?
After Power BI Advanced, many learners progress to Power BI DAX, Data Transformation with Power Query, Power BI Desktop Advanced Reporting or PL-300 Power BI Certification, depending on their role and goals.
Will I receive a certificate after completing this course?
Yes. Participants receive a certificate of completion, which can be added to a resumé or LinkedIn profile to acknowledge their Power BI training.
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Dates Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
PL-300 Power BI Certification
Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Power BI Training in Brisbane
View Dates
Power BI Training in Melbourne
View Dates
Power BI Training in Sydney
View Dates
Power BI Training in Adelaide
View Dates
Power BI Training in Perth
View Dates
Power BI Training in Canberra
View Dates
Power BI Training in Remote Online
View Datesat Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Resit your course for free within 6 Months
Valued by Individuals
