Power BI Advanced Training Courses
Dive deeper into Power BI and further your skills
All courses available in-class or remotely. To attend remotely, select "Remote East" or "Remote West" as your location on book now.
This course focuses on streamlining report creation, working with multiple date-dimension tables and role-playing dimensions, understanding filter context, using DAX to modify filter context, dynamic row-level security and using advanced report features such as drill-through, custom tooltips and report navigation.
In this one-day course you will gain a deeper understanding of evaluation of DAX measures and wider exposure to features within Power BI Desktop. Take your business intelligence analysis to the next level with our Power BI Advanced course.
Intermediate Power BI skills recommended, including data import, Power Query, visualisations, filters, basic data modelling, calculated fields, and row-level security.
Take this course as part of the PL-300 Power BI Certification and save:
PL-300 Power BI Certification
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
Course Introduction
Overview of Power BI
Data Model
Data modelling in the real world
The dataset
Themes, Parameters and Templates
Report themes
Parameters for changing the data source
Report templates
Advanced Slicing
Working with multiple date dimension tables
Create a date dimension table using DAX
Role-playing dimensions
Create hierarchies
DAX Measures and Filters
What is DAX?
DAX measures
Measures table
Filters on a measure
Filter context
DAX Measures and Filters cont'd
Measure evaluation with empty filter context
Measure evaluation with propagation of filters
Adding to the filter context
Using DAX to modify the filter context
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
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
Row-Level Security
USERNAME
Parent-child hierarchy
PATH
LOOKUPVALUE
Dynamic row-level security
Publish and test RLS
Extended Exercise – API Data Sources
Query a real API data source
HTTP and JSON terminology
Transform a JSON response
Publish to the Power BI Service
Extended Exercise – Data Streaming
Stream data from PubNub
Extended Exercise – Files in Folders
Query a folder of files
Column consistency
Understanding the folder query
View Query Dependencies
Extended Exercise – Power Query M Language
Syntax
Lots of hashes
The let and in statements
Basic exercises in M
Values, records and lists
Operators
Extended Exercise – Power Query M Language cont'd
Conditional testing – 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 Power BI?
Power BI is Microsoft’s business intelligence and data visualisation platform. It helps users connect to data, clean and transform datasets, build reports, create dashboards and share insights across an organisation.
What Power BI courses does Nexacu offer?
Nexacu offers Power BI Beginner, Power BI Intermediate, Power BI Advanced, Power BI DAX, Data Transformation with Power Query, Power BI Desktop Advanced Reporting, Data Visualisation with Power BI Desktop and PL-300 Power BI Certification.
Which Power BI course should I start with?
If you are new to Power BI, start with Power BI Beginner. If you already understand the basics, Power BI Intermediate is a suitable next step. More experienced users may choose Power BI Advanced, Power BI DAX, Data Transformation with Power Query or Power BI Desktop Advanced Reporting, depending on their goals.
Are Power BI courses suitable for beginners?
Yes. Power BI Beginner is designed for people who are new to Power BI and want to learn how to create reports, dashboards and visualisations. Basic confidence working with data, especially in Excel, is helpful.
What will I learn in Power BI training?
Depending on the course level, you may learn how to connect to data, transform data with Power Query, create data models, build visualisations, design dashboards, write DAX measures, manage filters, publish reports and share insights through the Power BI service.
Is Power BI training relevant for workplace reporting?
Yes. Nexacu’s Power BI courses are designed around practical workplace reporting and business intelligence tasks, including interactive dashboards, data models, automated reporting, DAX calculations, Power Query transformations and shared reports.
How difficult is Power BI to learn?
Power BI is accessible for beginners, but the difficulty depends on your experience with data, Excel, reporting and business intelligence concepts. Most learners start with the basics, then progress into data modelling, Power Query, DAX and advanced reporting as their needs grow.
Do I need Excel experience before learning Power BI?
Excel experience is helpful, especially if you work with spreadsheets, tables, PivotTables, charts or business data. It is not always required, but basic data confidence will help you get more from Power BI training.
Does Power BI training include DAX?
Yes. DAX is introduced in some Power BI courses and covered in more depth in Power BI Advanced and Power BI DAX. Learners who need stronger calculation, measure and modelling skills should consider the dedicated Power BI DAX course.
Does Power BI training include Power Query?
Yes. Power Query is included in relevant Power BI courses and covered in detail in Data Transformation with Power Query. This course is useful for learners who need to clean, reshape, combine and prepare data before reporting.
Can I attend Power BI training online?
Yes. Nexacu offers live online Power BI training through Remote East and Remote West sessions. Remote courses are instructor-led, so participants can ask questions, join discussions, complete exercises and receive trainer support during the class.
Where are face-to-face Power BI courses available?
Nexacu offers face-to-face Power BI courses in major Australian cities where scheduled, including Sydney, Melbourne, Brisbane, Canberra, Adelaide and Perth. Live online attendance is also available for remote learners.
Is Power BI training available for corporate teams?
Yes. Nexacu provides Power BI corporate training for teams and organisations that need consistent skills in reporting, dashboards, data modelling, DAX, Power Query and business intelligence workflows.
Is PL-300 Power BI Certification available?
Yes. Nexacu offers PL-300 Power BI Certification as part of its Power BI course pathway. This pathway is suitable for learners who want to develop broader Power BI capability and prepare for Microsoft Power BI certification.
How many students are typically in a Power BI course?
Class sizes vary by session, but Nexacu generally keeps Power BI classes small so participants can ask questions, take part in discussion and receive trainer support throughout the course.
Will I receive a certificate after completing Power BI training?
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 across 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
Learn with expert instructors, wherever you are
Valued by Individuals
