Verified by DataSimHQ

Analyst

Project

Rank the hubs

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