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.
Students will work on data transformations, measures, DAX, Row Level Security, using Power Query and creating Advanced Visualisations.
Learn how to manipulate data and enrich data models to produce powerful interactive dashboards on 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. You will be able to collaborate with colleagues and publish to the web. View our full Power BI Intermediate course outline below.
Courses will commence at 11am New Zealand standard time, and are delivered remotely.
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
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
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.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
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 Remote Training?
Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
Which courses are available remotely?
All of our Public Courses scheduled in across South East Asia and New Zealand are available to be delivered remotely. Book any course and you will receive login details to access our student portal. The Student portal contains all our your course information, instructions on getting set up for a remote class and free webinars.
What is Power BI?
Power BI is Microsoft's Data Visualization tool. The BI stands for Business Intelligence. Power BI enables users to connect with their data, cleanse it and build interactive dashboards to gain insights that drive actions.
Will the content in these Power BI Courses be relevant for the workplace?
Yes, our course writers and trainers have industry backgrounds. Our core principle is to deliver training that our students can not only use in the workplace but will actually drive increased efficiency and productivity gains. We teach the key elements of Power BI from Beginner to Advanced; starting with a focus on visualizations and quickly progressing to data manipulation and modelling. We also offer a DAX course.
How many students are typically in a Power BI Training Course?
While this varies from session to session, we typically have 5-8 students in our Power BI classes. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.
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.
DA-100 Power BI Certification
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
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
Australia
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia