clock icon

MON - FRI
9.00AM - 17.00PM

call icon

04 TRAINING
0487 24 64 64

Microsoft Power BI Intermediate

Overview

Build on your Power BI expertise with our Intermediate Power BI training 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 training 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 training 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

  • 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

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.

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

Microsoft Power BI Intermediate

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

  • 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

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.

Inclusions

classroom 16468411 1

Instructor - led Training

download 10947868

Menual & Files

service-center 12384245

Unlimited Free Support

Microsoft Power BI Intermediate

Reviews

There are no reviews yet.

Be the first to review “Microsoft Power BI Intermediate”

Your email address will not be published. Required fields are marked *

Scroll to top