Power QueryExercises

Power Query foundations for Excel and Power BI

A guided route through Power Query for Excel and Power BI users, from your first import to merges, group by and pivots, each skill building on the last.

  1. 1.How Power Query thinks

    4 lessons · 25 exercises · quiz

    Sources, previews and applied steps: why every transformation is a repeatable recipe.

  2. 2.Importing and inspecting data

    4 lessons · 18 exercises · quiz

    CSV, table-like Excel sheets and JSON fixtures; headers, delimiters and encodings.

  3. 3.Data types, locale and nulls

    4 lessons · 21 exercises · quiz

    Types, culture-aware conversion of numbers and dates, and the difference between null, blank and error.

  4. 4.Working with columns

    4 lessons · 21 exercises · quiz

    Choose, remove, rename, reorder and duplicate columns, and keep queries stable when columns change.

  5. 5.Filtering and sorting rows

    4 lessons · 28 exercises · quiz

    Filter by value, combine conditions, sort on several keys and keep top or bottom rows.

  6. 6.Text transformations

    4 lessons · 24 exercises · quiz

    Trim, clean, change case, split, merge, extract and replace text with exact semantics.

  7. 7.Numbers, dates and conditional columns

    4 lessons · 28 exercises · quiz

    Rounding, date parts, durations and conditional logic.

  8. 8.Profiling, errors and validation

    4 lessons · 18 exercises · quiz

    Find and handle errors, missing fields and bad values with try … otherwise.

  9. 9.Duplicates and keys

    4 lessons · 18 exercises · quiz

    Remove duplicates deliberately, choose the right row to keep and add index columns.

  10. 10.Fill down and report layouts

    4 lessons · 16 exercises · quiz

    Fill down/up and turn report-style exports into tidy tables.

  11. 11.Appending tables

    4 lessons · 17 exercises · quiz

    Stack tables, align schemas and handle mismatched columns.

  12. 12.Merging (joining) tables

    4 lessons · 20 exercises · quiz

    Join kinds, composite keys, expanding results and predicting row counts.

  13. 13.Group by and aggregation

    4 lessons · 26 exercises · quiz

    Summaries with sums, counts, averages and all-rows tables.

  14. 14.Pivot and unpivot

    4 lessons · 18 exercises · quiz

    Reshape wide and long tables and survive new columns on refresh.

  15. 15.Combining files and parameters

    4 lessons · 17 exercises · quiz

    Combine folder-like file packs with one reusable transformation.

  16. 16.M language basics

    4 lessons · 21 exercises · quiz

    Values, let … in, records and lists.

  17. 17.Functions, each and scope

    4 lessons · 21 exercises · quiz

    each, custom functions, branching and error handling in M.

  18. 18.Nested data and JSON

    4 lessons · 18 exercises · quiz

    Expand records, lists and nested tables; flatten JSON.

  19. 19.Refresh robustness and performance concepts

    4 lessons · 21 exercises · quiz

    Writing queries that survive new data, and what query folding and privacy levels mean.

  20. 20.Projects, debugging and interviews

    4 lessons · 22 exercises · quiz

    Integrated projects, debugging workflows and interview practice.