Power Query is the data-cleaning tool built into Power BI and Excel. It records each cleaning step, so the same steps run again when the data is refreshed.
Why it matters
Most real datasets need cleaning before they can be analysed: removing duplicates, fixing text and dates, and joining two tables. Doing this by hand each time is slow and easy to get wrong. Power Query repeats the steps for you.
The steps you will use first
- Remove duplicate rows.
- Change column types, for example text to date.
- Filter out blank or test rows.
- Split or merge columns.
- Append two tables with the same columns, or merge two tables on a shared key.
Keep the steps readable
Rename each step in the Applied Steps panel, such as “Remove test orders”. A reader can then follow what happened to the data.
A practice exercise
Take a messy CSV file, and clean it in Power Query until it loads into Power BI without errors. Count the steps, and explain each one in a sentence.
Next step: see our data analytics course at ScholarLogic, or book a free demo class. A counsellor will share the fee and the next batch dates.
