Skip to content
2026/2027 in-house training dates are now open.Request a proposal →
Digital & AI training

Power Query for Reporting Automation (Intermediate)

Reshape, Combine and Refresh Business Data

This two-day Intermediate level covers data transformation, combining and consolidating data, merging queries with lookup lists, custom columns and refreshable reports built on PivotTables. All exercises use fictional company data, and the programme ends with a final project: a refreshable operations report combining sales and stock data from several branches.

2 days
Power Query for Reporting Automation (Intermediate) corporate training session

Learning outcomes

  • Reshape data for analysis, including unpivoting and grouping.
  • Combine and consolidate data from several branches or departments.
  • Merge queries with lookup lists such as products or staff.
  • Add calculated and conditional columns in Power Query.
  • Build refreshable reports on top of Power Query.

Course outline

  1. 1

    DATA TRANSFORMATION

    • • Reshape data for analysis.
  2. 2

    COMBINING DATA

    • • Stack weeks or months of data into one table.
  3. 3

    MERGING QUERIES

    • • Join tables the way lookups do, but at scale.
  4. 4

    AUTOMATED DATA CONSOLIDATION

    • • Consolidate branches or departments automatically.
  5. 5

    CUSTOM & CONDITIONAL COLUMNS

    • • Add the fields the report needs.
  6. 6

    REFRESHABLE REPORTING

    • • Reports that update with one click.

Quick facts

How long is the programme?
2 days. The schedule can be adjusted, for example split into half-day sessions, to suit your operations.
Who should attend?
Executives, Analysts, Managers, Administrative Staff.
Where is it held?
In-house at your premises, at an external venue or hotel of your choice, or virtually, anywhere in Malaysia including Kuala Lumpur, Selangor, Penang and Johor.
Can the content be customised?
Yes. We tailor examples, case studies and activities to your industry, KPIs and company values while keeping the programme's learning outcomes.

Related programmes