Microsoft Power BI Training – Level 2: Intermediate

Design complex models, transform data with Power Query and build advanced interactive reports.

Intermediate
8 Hours (Live Online)
Duration8 Hours (Live Online)
LevelIntermediate
DeliveryLive Online
CertificateCertificate of Completion

Course overview

This intermediate course builds on foundational Power BI knowledge. Participants will learn to design complex data models, optimise data relationships, and create more advanced visualisations for interactive business reporting.

Why take this course?

  • Practical, workplace-focused content rather than theory
  • Taught live by an experienced industry instructor
  • Small class sizes with time for your questions
  • Downloadable exercise files and reference guides

Who should attend?

  • Individuals seeking to enhance data modelling and dashboard interactivity skills
  • Analysts and report builders already using Power BI Desktop
  • Completion of Power BI Level 1 (Beginner) or equivalent experience recommended

Learning outcomes

  • Connect to and manage multiple data sources using different connection modes
  • Prepare and transform data efficiently using Power Query
  • Design and optimise complex data models with accurate relationships
  • Apply DAX functions to create calculated columns, measures and time intelligence formulas
  • Build advanced and interactive visualizations for dynamic reporting
  • Incorporate and manage custom visuals to enhance report functionality

Course modules

Hands-on practical activities

  • Guided hands-on lab with provided sample files

  • Scenario-based exercise drawn from a real workplace task

  • End-of-course mini project reviewed by the instructor

Software & tools used

Power BI Desktop Power Query DAX

What's included

  • PowerPoint slides
  • Hands-on exercises and practice files
  • 30 days of post-course instructor email support

Career benefits

  • Add a genuinely practical skill to your CV
  • Save hours every week on repetitive work
  • Contribute to digital projects with confidence
  • Progress toward specialist or lead responsibilities

Next online sessions

Fixed weekday dates, one session each week. All times shown in AEST.

Loading upcoming dates…

Schedule & pricing

Upcoming sessions and pricing
DeliveryFormatPrice
Live Online8 Hours (Live Online)AUD $250Book

Frequently asked questions

Keep learning

Related courses