Turn Data into Interactive Dashboards

Length: 1 Day(s)     Cost:$950 + GST

= Scheduled class     = Guaranteed to run     = Fully booked

Click on the date to book online
Please wait as we are loading the schedules...
LOCATION July August September October
Auckland
Hamilton
Christchurch
Wellington
Virtual Class

Learn how to take information from places like Excel and databases, clean it up, and turn it into interactive reports that help people understand what's happening in the business. You'll also see how Microsoft's AI assistant (Copilot) can speed up report creation.

In everyday work this helps you:

  • Replace static spreadsheets with interactive reports.
  • Combine data from different systems into one view.
  • Clean inconsistent data before reporting.
  • Create dashboards managers can filter and explore themselves.
  • Spend less time manually updating reports.
  • Use AI assistance to build reports more quickly.

Suitable for:

  • Business users
  • Analysts
  • Operations staff
  • Team leaders
  • Finance staff
  • HR professionals
  • Anyone regularly producing reports from spreadsheets or business systems

While there are no strict prerequisites, this course will be easier if you already:

  • are comfortable using Excel
  • understand basic tables and business data
  • know simple reporting concepts

By the end of the course you'll be able to:

  • Connect Power BI to different data sources.
  • Import data from Excel, databases and online services.
  • Clean and prepare data for reporting.
  • Organise data into a reliable reporting model (called a semantic modelthe structure that defines how your data relates together).
  • Create attractive, interactive reports.
  • Use Copilot to speed up report development.
  • Understand where Power BI fits within Microsoft Fabric.

Get started building with Power BI

Learn what Power BI is, how it works, and how reports are created and shared.

Get data in Power BI

Connect to Excel files, databases and other data sources so your reports always start with the right information.

Clean, transform, and load data in Power BI

Fix messy data, rename fields, change formats and prepare information so reports are accurate and easier to maintain.

Configure a semantic model

Organise your data so reports calculate and display information correctly across multiple tables.

Design Power BI reports

Build clear, interactive reports that people can filter, explore and understand easily.

Get started with Copilot in Power BI

Use Microsoft's AI assistant to help create reports, models and insights more quickly.

Introduction to end-to-end analytics using Microsoft Fabric

See how Power BI fits into Microsoft's wider analytics platform for storing, managing and analysing organisational data.