clock icon

MON - FRI
9.00AM - 17.00PM

call icon

04 TRAINING
0487 24 64 64

Microsoft Power BI Intermediate Course

Overview

Build on your Power BI expertise with our Microsoft Power BI Intermediate Course! This session focuses on mastering Data Analysis Expressions (DAX), the powerful formula language that enables advanced calculations and data manipulation in Power BI.

You’ll also dive into creating and optimizing date tables, a cornerstone of effective time-based analysis. By the end of this course, you’ll be equipped to perform complex data modeling, uncover deeper insights, and create more dynamic, interactive reports. Perfect for users ready to take their data skills to the next level!

What you’ll learn:

  • Gain insight into business intelligence and how to use DAX in Power BI.
  • Learn about Data Modelling and connect multiple data tables.
  • Create a Date Table for better date related insights.
  • Create a range of interactive visualisations including a range of charts, tables, matrixes and maps.
  • How to publish and share your data.

Microsoft Power BI Intermediate course in Melbourne and across Australia.  We can come to you for Face-to-face Power BI training or you can join us online for Live online Power BI courses.

Course Materials

Power BI Desktop Intermediate Training Course Outline
785 KB
Power BI Intermediate Exercise Files
3 MB
2 items
All Download

Detailed Course Outline

Course prerequisites

Due to some similarities between Excel and Power BI, participants will need to be familiar with Excel to an Advanced level, including a good understanding of Charts, Tables and PivotTables.

No previous experience with Power BI is required.

  • Advanced data transformation
  • Cleaning irregularly formatted data
  • Adding Columns
  • Merge and Append Queries
  • Query from a Folder
  • View and Edit M Code
  • Text and dates Date functions
  • Column from Examples
  • Custom Column Functions
  • Blank queries
  • Create Date tables
  • CALENDERAUTO function
  • Working with time-based data
  • Date based data comparisons with DAX
  • SAMEPERIODLASTYEAR function
  • TOTALYTD and TOTALMTD functions
  • Columns and Measures
  • CALCULATE
  • SUMX, AVERAGEX etc.
  • FILTER
  • ALL, ALLEXCEPT, ALLSELECTED
  •  IF, SWITCH, FIND
  • RELATED
  • Manage Measures
  • DAX Structure
  • Use Measures to populate Fields in
  • Visualisations
  • Conditional Formatting
  • Tooltip Page
  • Applying Tooltips
  • Creating a Workspace
  • Managing Workspace Access
  • Publish to a Workspace
  • Create and Publish an App

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

What topics are covered in the Power BI Intermediate Course?

The Intermediate course builds on the fundamentals and covers advanced topics such as data modelling, advanced DAX calculations, complex data transformations, relationships between tables, advanced visualisations, report optimisation, and sharing/publishing interactive dashboards. 

Microsoft Power BI Intermediate Course
Who is the Power BI Intermediate Course designed for?

This course is ideal for users who already know the basics of Microsoft Power BI, such as analysts, business intelligence professionals, or individuals transitioning from fundamental skills, and want to develop more powerful, sophisticated data-analytics and reporting capabilities. 

Microsoft Power BI Intermediate Course
Do I need to complete the Fundamentals course before enrolling in Intermediate?

While not always mandatory, it’s highly recommended that you have a good grasp of Power BI basics, such as data import, simple transformations, and basic report building, before enrolling, to make the most of the intermediate topics. 

Microsoft Power BI Intermediate Course
What skills will I gain after completing the Power BI Intermediate Course?

You’ll gain the ability to build complex data models, write and optimize DAX formulas, create advanced visuals and dashboards, handle multiple data sources and table relationships, and design efficient, interactive reports suitable for business reporting or data-driven decision making. 

Microsoft Power BI Intermediate Course
Is special software required for the course?

Yes, you’ll need access to Power BI (Desktop and/or Service) to fully participate. The course is designed to work with the standard Power BI versions used in professional settings.

Microsoft Power BI Intermediate Course
How long does the Power BI Intermediate Course take and what is the expected outcome?

Duration depends on the format (e.g., multi-hour workshop or multi-day training), but typically learners can expect to complete the intermediate curriculum over a few sessions. On completion, participants should be competent to create advanced dashboards, build data models for real-world data, and contribute effectively in a business-intelligence environment. 

Microsoft Power BI Intermediate Course
Microsoft Power BI Intermediate Course

Course Details

Duration 1 day
Level Intermediate

Private Sessions

Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.

Public Sessions

Join a public course session conducted LIVE ONLINE via Microsoft Teams.

$395

SKU: N/A Category:

Detailed Course Outline

Course prerequisites

Due to some similarities between Excel and Power BI, participants will need to be familiar with Excel to an Advanced level, including a good understanding of Charts, Tables and PivotTables.

No previous experience with Power BI is required.

  • Advanced data transformation
  • Cleaning irregularly formatted data
  • Adding Columns
  • Merge and Append Queries
  • Query from a Folder
  • View and Edit M Code
  • Text and dates Date functions
  • Column from Examples
  • Custom Column Functions
  • Blank queries
  • Create Date tables
  • CALENDERAUTO function
  • Working with time-based data
  • Date based data comparisons with DAX
  • SAMEPERIODLASTYEAR function
  • TOTALYTD and TOTALMTD functions
  • Columns and Measures
  • CALCULATE
  • SUMX, AVERAGEX etc.
  • FILTER
  • ALL, ALLEXCEPT, ALLSELECTED
  •  IF, SWITCH, FIND
  • RELATED
  • Manage Measures
  • DAX Structure
  • Use Measures to populate Fields in
  • Visualisations
  • Conditional Formatting
  • Tooltip Page
  • Applying Tooltips
  • Creating a Workspace
  • Managing Workspace Access
  • Publish to a Workspace
  • Create and Publish an App

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

What topics are covered in the Power BI Intermediate Course?

The Intermediate course builds on the fundamentals and covers advanced topics such as data modelling, advanced DAX calculations, complex data transformations, relationships between tables, advanced visualisations, report optimisation, and sharing/publishing interactive dashboards. 

Microsoft Power BI Intermediate Course
Who is the Power BI Intermediate Course designed for?

This course is ideal for users who already know the basics of Microsoft Power BI, such as analysts, business intelligence professionals, or individuals transitioning from fundamental skills, and want to develop more powerful, sophisticated data-analytics and reporting capabilities. 

Microsoft Power BI Intermediate Course
Do I need to complete the Fundamentals course before enrolling in Intermediate?

While not always mandatory, it’s highly recommended that you have a good grasp of Power BI basics, such as data import, simple transformations, and basic report building, before enrolling, to make the most of the intermediate topics. 

Microsoft Power BI Intermediate Course
What skills will I gain after completing the Power BI Intermediate Course?

You’ll gain the ability to build complex data models, write and optimize DAX formulas, create advanced visuals and dashboards, handle multiple data sources and table relationships, and design efficient, interactive reports suitable for business reporting or data-driven decision making. 

Microsoft Power BI Intermediate Course
Is special software required for the course?

Yes, you’ll need access to Power BI (Desktop and/or Service) to fully participate. The course is designed to work with the standard Power BI versions used in professional settings.

Microsoft Power BI Intermediate Course
How long does the Power BI Intermediate Course take and what is the expected outcome?

Duration depends on the format (e.g., multi-hour workshop or multi-day training), but typically learners can expect to complete the intermediate curriculum over a few sessions. On completion, participants should be competent to create advanced dashboards, build data models for real-world data, and contribute effectively in a business-intelligence environment. 

Microsoft Power BI Intermediate Course
Microsoft Power BI Intermediate Course

Reviews

Scroll to top