Analyst
Analyst
Project
FlowRoute Logistics Co. · Excel · Beginner
The brief
From: Funmi Alade, Head of Customer Experience
Same workbook, harder question: which hubs should worry me? The Hub_Performance sheet has every hub's shipment totals and delivery rate. The Complaints sheet tells you where complaints land.
On a new sheet: 1. A hub table: hub name, city, total shipments, delivery rate - sorted worst delivery rate first. 2. Add a complaints column: complaints counted per hub from the Complaints sheet (live formulas referencing the sheet, not pasted values). 3. Add complaints per 1,000 shipments per hub, using each hub's total_shipments from Hub_Performance as the denominator, so volume doesn't distort the picture. 4. A one-line verdict: the hub I should be most worried about - and if no hub truly stands out, say exactly that. I need the truth, not a scapegoa…
Independent grading
72/100
Achieved 2 Nov 2026
Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.
What is DataSimHQ?
A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more