Power BI Intermediate Training Courses
Learn to work with data, measures, power query and more in Power BI.
Learn to work with data, measures, power query and more in Power BI.
All courses available in-class or remotely.
To attend remotely, select "Remote East" or "Remote West" as your location on book now.
Students will work on data transformations, measures, DAX, using Power Query and creating Advanced Visualisations. Our Microsoft-certified trainers make it easy to learn how to manipulate data in Power BI.
Learn how to enrich data models to produce powerful interactive dashboards with our one-day course. After the completion of this course, you will be able to work with data from many sources, build calculations in the data model to produce intelligent, interactive dashboards in one of the premier BI tools on the market. You will be able to collaborate with colleagues and publish to the web.
A basic understanding of Power BI Desktop, including sourcing and preparing data, is recommended. Familiarity with building visuals and dashboards in Power BI is helpful but not essential.
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 AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
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
Data Model & Transformation
Data transformation principles
Fact and dimension tables
The data model
Star schema
Snowflake schema
Optimising the data model
Get Data
Data sources
The dataset from Excel
From Folder
Power Query Editor
Power Query user interface
Queries pane
Data pane
Ribbon
Query Settings
Data Transformations
Data Model in Desktop
Filter data
Rename queries
Remove columns
Unpivot columns
Conditional columns
Fill values
Reorder columns
Combine queries
Append
Merge
Replace values
Custom columns
Evaluate and change column data types
Date Transformations
Auto Date/Time
Create a date dimension table
Dynamic date dimension tables
Extract date components as columns
Fiscal quarter and fiscal year
Load Data
Include in report refresh
Enable load
Close and Apply
Data Modelling
The importance of a good data model
Manage relationships
Relationship cardinality
Cross-filter direction
Typical cardinality and cross filtering
The dataset
Modify data formats
Data Analysis Expressions (DAX)
What is DAX?
M (Power Query) language vs DAX
Create and use a calculated column
Create and use measures
Simple DAX functions
The X Functions
Calculating values row-by-row in a measure
X functions vs aggregators and calculated columns
Quick Measures
Quick measure categories
Aggregate per category
Filters / CALCULATE
Mathematical operations
Text
Time Intelligence Quick Measures
Auto date/time option
Mark as date table
Visuals for date/time reporting
Quick measure using an existing measure
Field Parameters
Create 2 Field parameters
Change the slicer setting to single select
Add a bar chart using the parameters as fields
Bookmarks
Format the buttons and assign bookmarks
Power BI Service
Select Workspaces → create new workspace → Add people
Explore different Access Rights
Return to PBI Desktop
Save and Publish report to your workspace
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 AdvancedAdvance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.
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
