IN-STEP V.I.S.I.O.N. - Intelligent Data Analysis with Power Query and Power Pivot

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme is for analysts, finance staff, managers, executives and administrators who handle large volumes of data in Excel. It teaches them to combine and clean data in Power Query and model it in Power Pivot.

Participants pull data from tables, workbooks and folders of files, fix blanks, data types and regional date formats, and append or merge tables. They then load the results into the Excel Data Model, relate tables to each other and write DAX measures with functions such as CALCULATE and TOTALYTD.

Participants leave able to build PivotTable reports and KPIs from several related tables, and to refresh them when the source data changes.

Module topics

  • Power Query basics and data extraction
  • Row and column transformations
  • Appending and merging tables
  • Loading and refreshing data
  • Power Pivot and the Excel Data Model
  • Table relationships and simple DAX
  • DAX time intelligence and KPIs
  • Refreshing reports from source data

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