For educators
Use graded, refresh-checked Power Query exercises and 8 capstone projects with your students.
- A class space where you invite students by email, set assignments with due dates and export progress as CSV
- Students decide whether to share their assignment progress with you, and can change their mind at any time. You never see their code, other practice or AI tutor conversations
- Free educator access is reviewed individually. If a request is approved, access is granted for a set number of seats and months, not indefinitely
- The AI tutor is not included in class seats
How progress is measured
Every exercise is graded by running the learner's query against the visible sample and against hidden datasets with new values, more rows and a different row order, so a query that only fits the sample doesn't pass. Passes are recorded as independent or with help (after a hint or the solution), which tells you more than a completion tick. Timed assessments mix tasks from several modules, and learners who pass can earn a certificate with a public verification page.
What your students practise
80 lessons and 418 graded exercises across these modules:
- 1. How Power Query thinks4 lessons · 25 exercises
- 2. Importing and inspecting data4 lessons · 18 exercises
- 3. Data types, locale and nulls4 lessons · 21 exercises
- 4. Working with columns4 lessons · 21 exercises
- 5. Filtering and sorting rows4 lessons · 28 exercises
- 6. Text transformations4 lessons · 24 exercises
- 7. Numbers, dates and conditional columns4 lessons · 28 exercises
- 8. Profiling, errors and validation4 lessons · 18 exercises
- 9. Duplicates and keys4 lessons · 18 exercises
- 10. Fill down and report layouts4 lessons · 16 exercises
- 11. Appending tables4 lessons · 17 exercises
- 12. Merging (joining) tables4 lessons · 20 exercises
- 13. Group by and aggregation4 lessons · 26 exercises
- 14. Pivot and unpivot4 lessons · 18 exercises
- 15. Combining files and parameters4 lessons · 17 exercises
- 16. M language basics4 lessons · 21 exercises
- 17. Functions, each and scope4 lessons · 21 exercises
- 18. Nested data and JSON4 lessons · 18 exercises
- 19. Refresh robustness and performance concepts4 lessons · 21 exercises
- 20. Projects, debugging and interviews4 lessons · 22 exercises
All lessons, the sample datasets and the practice packs are free to use for learning and teaching, with or without seats. See pricing for individual plans.
Request educator access
Tell us about your course. We reply by email either way.