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, Row Level Security, 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. View our full Power BI Intermediate course outline below.
Power BI Intermediate Training Courses
Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
Upcoming Courses:
Remote East
Date
Course
City
Status
Brisbane
Date
Course
City
Status
Sydney
Date
Course
City
Status
Parramatta
Date
Course
City
Status
Melbourne
Date
Course
City
Status
Canberra
Date
Course
City
Status
Adelaide
Date
Course
City
Status
Perth
Date
Course
City
Status
Remote West
Date
Course
City
Status
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000
Power BI Intermediate Course Details
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Power BI Course Outlines
-
-
-
-
-
-
-
-
PL-300 Power BI Certification
Other Courses
Other Courses
Course Rating
Power BI City Pages
Skills Test
Contact Us
What do I need to know to attend?
- Source data from Excel and some other sources into Power BI service
- Build reports and dashboards in Power BI, turn data into visuals, format visuals, filter data and visuals
- Understand the basics of collaborating using Power BI (although not critical for this course)
- Basic understanding of Power BI Desktop tool (don’t need to use regularly), how to source data and basic preparation of data
Power BI Intermediate Learning Outcomes
Understand self-service Business Intelligence
- Understand Power Query
- Know how to Transform Data
- Create Custom Visuals
- Understand the basics of DAX
- Understand the basics of “M”
- How to use Quick Measures
- Sharing and Security on the Service
Power BI Intermediate Course Content
- 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
phone
email
enquiry
