Business Data Analytics & Advanced Excel · Intermediate level

Intermediate level · Module 1 of 6 · 15 guided hours

Power Query for Analysts

Connect to several data sources, clean and reshape data and design queries that refresh reliably.

Learning objectives

  • Connect to files, folders and databases
  • Clean and reshape data with Power Query
  • Design maintainable queries that refresh reliably

Topics

  • data source connections
  • folder imports
  • unpivot and pivot
  • merge and append
  • query naming and staging
  • refresh errors

Lessons

  1. Lesson 1 Connecting to Data Sources

    Connect Power BI to the files, folders and databases where business data lives.

    data connectorsfolder sourcedatabase connectionimport mode

  2. Lesson 2 Cleaning and Reshaping

    Clean, unpivot, merge and append data into tidy tables.

    data typesunpivotmerge queriesappend queries

  3. Lesson 3 Maintainable Queries

    Organise queries so others can understand them and refresh problems are easy to fix.

    query names and groupsstaging queriesstep namesrefresh errors

Practical activity

Combine monthly branch files from a folder, a budget sheet and a product list into clean tables ready for modelling.

Expected outcomes

  • Reliable, repeatable data preparation
  • Data ready for modelling

Assessment

Practical: add a new month's file and refresh without errors; queries reviewed for clarity.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.