Skip to content
All courses
Data & Analytics

Power Query & Data Modeling

Master Power Query (M language) for data extraction, transformation, and loading across Excel and Power BI. Learn to automate data pipelines that clean, merge, and reshape data from any source.

03

Levels

10

Modules

1:1

Live

Enroll NowLive virtual sessions or on-site training
Power Query & Data ModelingEST. 2025 — GROWWM
Topics / 01

What you will learn.

A snapshot of every topic covered across all three levels. Detailed daily curriculum is in the next section.

10Core topics
01Connecting Data Sources
02Cleaning & Shaping
03Merge & Append
04Custom Columns
05M Language Basics
06Parameters & Functions
07Star Schema Design
08Calculated Columns
09Refresh & Scheduling
10Performance Best Practices
Curriculum / 02

Three levels.
One path.

Start where you are. Each level builds on the last — from your first formula to enterprise-grade automation.

Build a solid foundation with core concepts and essential skills.

Modules

02 / TOTAL
01

Day 1: Connecting and Cleaning Data

  • Understanding the ETL process: Extract, Transform, Load
  • Launching Power Query in Excel and Power BI Desktop
  • Connecting to Excel, CSV, web, and folder sources
  • Navigating the Power Query Editor interface
  • Removing columns, filtering rows, and sorting data
  • Changing data types and handling errors
  • Renaming columns and promoting headers
02

Day 2: Basic Transformations and Loading

  • Splitting and merging columns
  • Replacing values and trimming whitespace
  • Unpivoting and pivoting columns for reshaping data
  • Adding custom columns with simple formulas
  • Grouping rows for summarization
  • Configuring load destinations: table, connection, or data model
  • Refreshing queries and understanding applied steps

After this level

Outcomes
  • 01Connect to common data sources and load data into Power Query
  • 02Clean and shape data using essential transformations
  • 03Reshape data with pivot, unpivot, and group operations
  • 04Load transformed data into Excel tables or Power BI models
Audience / 03

Built for doers.

Prerequisites

Familiarity with Excel or Power BI basics.

  • 01Data analysts and report builders
  • 02Excel power users moving to Power BI
  • 03Anyone who prepares data from multiple sources
Reading / 05

Related articles

01
Featured · Excel & VBA

Power Query: The ETL Tool Hiding in Your Spreadsheet

Power Query can replace hours of manual data cleanup. Learn how to build reusable ETL pipelines without writing a single line of code.

7 min readRead article
Continue / 06

Keep going in Data & Analytics.

Browse all 24 courses
/ 01

Power BI

Build interactive dashboards with DAX and publish reports for your team.

Fundamental → Advanced
/ 02

SQL

Master joins, aggregations, and subqueries for any relational database.

Fundamental → Advanced
/ 03

Data Visualization & Storytelling

Go beyond charts and build data narratives that drive decisions.

Fundamental → Advanced
/ 04

Tableau

Build stunning dashboards with LOD expressions and interactive visuals.

Fundamental → Advanced
/ 05

Google Analytics

Set up GA4, track conversions, and make data-backed marketing decisions.

Fundamental → Advanced
GrowWM•Digital Transformation•Data Analytics•Training•GrowWM•Digital Transformation•Data Analytics•Training•GrowWM•Digital Transformation•Data Analytics•Training•GrowWM•Digital Transformation•Data Analytics•Training•

Ready to start?

Let us build
something great.

Get in Touch