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.How Power Query thinks
4 lessons · 25 exercises · quizSources, previews and applied steps: why every transformation is a repeatable recipe.
2.Importing and inspecting data
4 lessons · 18 exercises · quizCSV, table-like Excel sheets and JSON fixtures; headers, delimiters and encodings.
3.Data types, locale and nulls
4 lessons · 21 exercises · quizTypes, culture-aware conversion of numbers and dates, and the difference between null, blank and error.
4.Working with columns
4 lessons · 21 exercises · quizChoose, remove, rename, reorder and duplicate columns, and keep queries stable when columns change.
5.Filtering and sorting rows
4 lessons · 28 exercises · quizFilter by value, combine conditions, sort on several keys and keep top or bottom rows.
6.Text transformations
4 lessons · 24 exercises · quizTrim, clean, change case, split, merge, extract and replace text with exact semantics.
7.Numbers, dates and conditional columns
4 lessons · 28 exercises · quizRounding, date parts, durations and conditional logic.
8.Profiling, errors and validation
4 lessons · 18 exercises · quizFind and handle errors, missing fields and bad values with try … otherwise.
9.Duplicates and keys
4 lessons · 18 exercises · quizRemove duplicates deliberately, choose the right row to keep and add index columns.
10.Fill down and report layouts
4 lessons · 16 exercises · quizFill down/up and turn report-style exports into tidy tables.
11.Appending tables
4 lessons · 17 exercises · quizStack tables, align schemas and handle mismatched columns.
12.Merging (joining) tables
4 lessons · 20 exercises · quizJoin kinds, composite keys, expanding results and predicting row counts.
13.Group by and aggregation
4 lessons · 26 exercises · quizSummaries with sums, counts, averages and all-rows tables.
14.Pivot and unpivot
4 lessons · 18 exercises · quizReshape wide and long tables and survive new columns on refresh.
15.Combining files and parameters
4 lessons · 17 exercises · quizCombine folder-like file packs with one reusable transformation.
16.M language basics
4 lessons · 21 exercises · quizValues, let … in, records and lists.
17.Functions, each and scope
4 lessons · 21 exercises · quizeach, custom functions, branching and error handling in M.
18.Nested data and JSON
4 lessons · 18 exercises · quizExpand records, lists and nested tables; flatten JSON.
19.Refresh robustness and performance concepts
4 lessons · 21 exercises · quizWriting queries that survive new data, and what query folding and privacy levels mean.
20.Projects, debugging and interviews
4 lessons · 22 exercises · quizIntegrated projects, debugging workflows and interview practice.