Training for teams
Give your analysts hands-on Power Query practice on realistic messy data, with progress you can see.
- The same lessons, graded exercises, 8 capstone projects and timed assessments as individual Pro
- An organization space: owners and instructors invite people by email (invitations expire after 7 days) and set assignments with due dates
- Progress on assignments for each learner who chooses to share it, with a CSV export. Instructors never see learners' code, other practice or AI tutor conversations
- Seats and the access period are agreed with us and switched on by our team; invoicing is arranged directly (there is no self-serve team checkout)
- The AI tutor is not included in organization 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 learners 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.
Tell us about your team
A person reads every enquiry and replies with options for your group size.