IN-STEP V.I.S.I.O.N. - Power BI Part I: Building Reports That Deliver Insights

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme teaches business professionals, executives and analysts to turn business data into interactive Power BI reports for performance monitoring and management reporting. It needs basic Excel but no previous Power BI experience.

Participants connect to CSV, Excel and folder data in Power Query, clean it with repeatable steps, merge queries and build a fact-and-dimension model with keys and relationships. They create a date table with fiscal columns, use implicit measures to check the data before writing explicit DAX measures, and set up hierarchies, sorting and geographic categories.

Report design covers choosing visuals, cross-filtering, Edit interactions and the Filters pane. Participants then publish to the Power BI Service and learn to refresh, republish and maintain their reports.

Module topics

  • Power BI ecosystem, licences and workflow
  • Power Query: connecting and cleaning data
  • Merging queries and building the data model
  • Calculated columns and a date table
  • From implicit to explicit DAX measures
  • Organising and optimising the data model
  • Designing interactive reports and visuals
  • Publishing and maintaining reports

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry