INSYNTIVEAcademy
IDEN
Sign inSign up freeSign up

Module 02 · Transform data (Power Query)

Clean & shape data

Remove, filter, retype and fix values — the everyday moves.

Step by step9 minLesson 7 of 21 Free

Power BI practice fileSales, Product and Region tables, plus July & August data for the append exercise. Used in every module of the Power BI course.Excel · ~1,200 rows · free Download

  1. Step 1: Select the columns you don’t need (in the practice file: Notes and InternalCode) → right-click → Remove columns.

  2. Step 2: Click the filter arrow on the Region column to remove blanks (null) or unwanted categories.

  3. Step 3: Set each column’s data type via the icon in the column header (Text, Whole number, Decimal number, Date).

    Watch out: Wrong types break everything downstream — money stored as text won’t sum. Fix types early.

  4. Step 4: Use Replace values to fix typos (for example jakarta → Jakarta), and Transform → Format → Trim to remove extra spaces.

  5. Step 5: Click Close & Apply to push the cleaned table back into the model.