Power QueryExercises

Debugging and interview quiz

Debugging habits and explaining your approach, as in analyst interviews.

Revise first: Debug a broken query step by step, Fix DataFormat.Error at the source, End-to-end project: from raw export to monthly report, Explain your query in an interview

Question 1

1.A query errors at step 7. What's the fastest first move?

Question 2

2.In an interview, how do you explain M vs DAX?

Question 3

3.Totals in your output are too high after a merge. What do you check first?

Question 4

4.A stakeholder asks for 'revenue by region'. What should you clarify before building?

Question 5

5.Your query works today. How do you make it more likely to work next month?

Question 6

6.A colleague's query is 40 steps with cryptic names. What's a quick improvement?

Question 7

7.Which is a data-quality check you can build in Power Query?

Question 8

8.Under time pressure in a practical test, what should you prioritise?

0 of 8 answered. Unanswered questions count as wrong.