Module 1 · From question to model Lesson 2 of 15

Shaping data in Power Query

Worked example

Removing a top row, promoting headers, changing a type and filtering blanks are four recorded steps. Retyping the same cleanup by hand next month is what makes an analyst look slow.

Your practice task

Import a messy CSV, clean it entirely in Power Query — no formulas — and save the file. Then add a row to the source and refresh.

Do this before moving on. Reading a solution teaches the shape of it; typing it teaches you.

Key takeaway

Power Query records your cleaning steps and replays them on every refresh. That is the difference between a one-hour job every Monday and a report that maintains itself.

Almost there

15 lessons left of 15

Finish every lesson to unlock the certificate. Each one ends in a practice task — do them and the final project brief writes itself.

Next recommended course Data Analytics with SQL & Excel