Power QueryExercises

Module 20

Projects, debugging and interviews

Integrated projects, debugging workflows and interview practice.

You'll be able to

Lessons

  1. 1.Debug a broken query step by stepLocate and fix the root cause of a failing query instead of patching the symptom.
  2. 2.Fix DataFormat.Error at the sourceFind the raw values behind a conversion error and choose a defensible fix.
  3. 3.End-to-end project: from raw export to monthly reportCombine import, types, cleaning, filtering, merging and grouping into one reliable query.
  4. 4.Explain your query in an interviewPresent a transformation clearly, including how you know it's correct.

Take the projects, debugging and interviews quiz (8 questions)

Exercises