Power BI Intermediate Training Courses
Learn how to transform data, build measures and create more advanced Power BI reports.
Learn how to transform data, build measures and create more advanced Power BI reports.
4.72
Build stronger Power BI reporting and data modelling skills in one day.
Nexacu’s Power BI Intermediate course helps professionals extend their Power BI skills by working with data transformations, measures, DAX, Power Query and advanced visualisations.
This instructor-led course is designed for users who already understand the basics of Power BI and want to build more effective reports, enrich data models and create interactive dashboards from multiple data sources.
Quick Answer
Power BI Intermediate is a one-day course for users who already have basic Power BI knowledge and want to improve their reporting, modelling and data transformation skills. The course covers Power Query, data transformations, measures, DAX, advanced visualisations, interactive dashboards and publishing reports. A basic understanding of Power BI Desktop is recommended.
Who should attend?
Power BI users, analysts, reporting teams, Excel users, managers and professionals who already understand basic reports and want to work more confidently with data models, measures and transformations.
What will you learn?
Learn how to transform data with Power Query, create DAX measures, enrich data models, build advanced visualisations, publish reports and create more interactive dashboards.
Prerequisite: 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.
This course can also be taken as part of the PL-300 Power BI Certification pathway.
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
An introduction to the different Power BI Products
When to use Power BI Desktop
Free, Pro and Premium
Online services and databases that Power BI can connect to
The Business Intelligence Process
Power BI in the business intelligence industry
A day in the life of Power BI
Data Model & Transformation
Data transformation principles
Data normalisation
Fact and dimension tables
The data model
Star schema
Snowflake schema
Optimising the data model
Get Data
Data sources
The dataset
Get data from a SharePoint list
Get data from an Excel worksheet
Get data from an Azure SQL database
Import vs DirectQuery
Power Query Editor
Power Query user interface
Queries pane
Data pane
Ribbon
Query Settings
Data Transformations
Filter data
Rename queries
Group queries
Remove top rows
Use first row as headers
Rename columns
Duplicate columns
Split columns
Rename Applied Steps
Format data
Data Transformations
Unpivot columns
Conditional columns
Fill values
Reorder columns
Combine queries
Append
Merge
Replace values
Custom columns
Remove columns
Evaluate and change column data types
Check the Data: Profiling
Column quality
Column distribution
Column profile
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
Query dependencies
Advanced Editor
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
What is DAX?
M (Power Query) language vs DAX
Calculated columns
Create and use a calculated column
Measures
Create and use measures
Implicit vs explicit measures
Filter context and measures
Referring to measures and calculated columns
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
Totals
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
Secure and Share Data
Online sharing
Introduction to row-level security (RLS)
Multi-row cards
Testing row-level security
Power BI workspaces
Apps
Add users to RLS roles
Unpublish an app
Delete a workspace
Extended Content: More Visualisations
Combo charts
Small multiples
Waterfall charts
Drill-down charts
What if
Bookmarks
Buttons to navigate bookmarks
Appendix: Database Normalisation
The Normal Forms
1st Normal Form
2nd Normal Form
3rd Normal Form
Primary Keys
Relationships
What is Power BI?
Power BI is Microsoft’s business intelligence and data visualisation platform. It helps users connect to data, transform information, create reports, build dashboards and share insights across an organisation.
What will I learn in the Power BI Intermediate course?
You will learn how to transform data, create measures, use DAX, work with Power Query, enrich data models, create advanced visualisations and publish interactive reports and dashboards.
Who should attend this Power BI Intermediate course?
This course is suitable for Power BI users, analysts, reporting teams, Excel users, managers and professionals who already understand basic Power BI reports and want to build stronger reporting, modelling and dashboard skills.
Do I need Power BI experience before attending?
Yes. A basic understanding of Power BI Desktop is recommended, including sourcing and preparing data. Familiarity with building visuals and dashboards in Power BI is helpful but not essential.
Is this course suitable after Power BI Beginner?
Yes. Power BI Intermediate is a suitable next step after Power BI Beginner. It helps learners move from basic reports and dashboards into data transformations, measures, DAX, Power Query and more advanced reporting techniques.
Does this course cover Power Query?
Yes. The course covers Power Query concepts and data transformation techniques to help participants clean, shape and prepare data for reporting in Power BI.
Does this course cover DAX?
Yes. Participants are introduced to measures and DAX concepts used to create calculations and improve the analytical value of Power BI reports.
Will I learn advanced visualisations?
Yes. The course includes advanced visualisation techniques to help participants build clearer, more interactive and more useful Power BI reports and dashboards.
Can I take this Power BI course online?
Yes. Nexacu offers this course 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.
What is remote Power BI training?
Remote Power BI training is delivered live online by an instructor. Participants can ask questions, join discussions, complete exercises and receive trainer support during the session.
Is Power BI Intermediate part of the PL-300 certification pathway?
Yes. Power BI Intermediate can be taken as part of Nexacu’s PL-300 Power BI Certification pathway, which is designed for learners who want to build a broader Power BI skill set.
What Power BI course should I take after Power BI Intermediate?
After Power BI Intermediate, many learners progress to Power BI Advanced, 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.
Ready to build stronger Power BI skills?
Choose an upcoming Power BI Intermediate course date and learn how to transform data, create measures and build more effective reports and dashboards.
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 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
