Module 20
Projects, debugging and interviews
Integrated projects, debugging workflows and interview practice.
You'll be able to
- Debug a broken query
- Complete an end-to-end project
- Explain your approach in an interview
Lessons
- 1.Debug a broken query step by stepLocate and fix the root cause of a failing query instead of patching the symptom.
- 2.Fix DataFormat.Error at the sourceFind the raw values behind a conversion error and choose a defensible fix.
- 3.End-to-end project: from raw export to monthly reportCombine import, types, cleaning, filtering, merging and grouping into one reliable query.
- 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
- advanced~20 minPro
Project: revenue by regional manager from a raw export (kite shop)
From a messy CSV export and a manager list, produce completed revenue per regional manager, rounded to cents and sorted.
- advanced~20 minPro
Project: revenue by regional manager from a raw export (bakery)
From a messy CSV export and a manager list, produce completed revenue per regional manager, rounded to cents and sorted.
- advanced~20 minPro
Project: revenue by regional manager from a raw export (bike rental)
From a messy CSV export and a manager list, produce completed revenue per regional manager, rounded to cents and sorted.
- advanced~15 minPro
Debug a city revenue report with three bugs (kite shop)
The starter runs, but its numbers are wrong in three places. Find and fix each bug.
- advanced~15 minPro
Debug a city revenue report with three bugs (bakery)
The starter runs, but its numbers are wrong in three places. Find and fix each bug.
- advanced~15 minPro
Debug a city revenue report with three bugs (bike rental)
The starter runs, but its numbers are wrong in three places. Find and fix each bug.
- advanced~12 minPro
Interview task: second-highest salary per department (logistics)
For each department, return the second-highest distinct salary. Departments with only one distinct salary are left out.
- advanced~12 minPro
Interview task: second-highest salary per department (software)
For each department, return the second-highest distinct salary. Departments with only one distinct salary are left out.
- advanced~12 minPro
Interview task: second-highest salary per department (hospital)
For each department, return the second-highest distinct salary. Departments with only one distinct salary are left out.
- advanced~14 minPro
Interview task: month-over-month revenue change (kite shop)
Total revenue per month, then show the change from the previous month (null for the first month), in month order.
- advanced~14 minPro
Interview task: month-over-month revenue change (bakery)
Total revenue per month, then show the change from the previous month (null for the first month), in month order.
- advanced~14 minPro
Interview task: month-over-month revenue change (bike rental)
Total revenue per month, then show the change from the previous month (null for the first month), in month order.
- advanced~18 minPro
Project: budget versus actual by department and month (school)
Combine a wide budget sheet with a long list of actual spend to report Budget, Actual and Variance per department and month.
- advanced~18 minPro
Project: budget versus actual by department and month (charity)
Combine a wide budget sheet with a long list of actual spend to report Budget, Actual and Variance per department and month.
- intermediate~14 minPro
Project: build the weekly reorder list (hardware)
List the items below their reorder level with how many to order and the supplier's email, sorted for the buyer.
- intermediate~14 minPro
Project: build the weekly reorder list (pharmacy)
List the items below their reorder level with how many to order and the supplier's email, sorted for the buyer.
- intermediate~14 minPro
Project: build the weekly reorder list (cafe)
List the items below their reorder level with how many to order and the supplier's email, sorted for the buyer.
- intermediate~9 minPro
Predict how many rows each order becomes after a merge (kite shop)
Before merging Orders with Shipments (left outer) and expanding, predict the number of rows per order.
- intermediate~9 minPro
Predict how many rows each order becomes after a merge (bakery)
Before merging Orders with Shipments (left outer) and expanding, predict the number of rows per order.
- intermediate~9 minPro
Predict how many rows each order becomes after a merge (bike rental)
Before merging Orders with Shipments (left outer) and expanding, predict the number of rows per order.
- advanced~14 minPro
Debug a query that works today and breaks on refresh (retail)
The starter passes on this month's sheet but fails next month: it removes a column that may vanish and unpivots a fixed month list.
- advanced~14 minPro
Debug a query that works today and breaks on refresh (franchise)
The starter passes on this month's sheet but fails next month: it removes a column that may vanish and unpivots a fixed month list.