Verified by DataSimHQ

Analyst

Samuel Adeniyi

Analyst

Project

Find the worst hubs

FlowRoute Logistics Co. · SQL · Beginner

The brief

From: Funmi Alade, Head of Customer Experience

Now the part that starts arguments: which hubs are actually underperforming? I need this defensible - per-hub numbers, not vibes.

What I need from you: 1. Every hub with its city, total shipments, delivered count, failed count, and delivery rate percentage - worst delivery rate first. 2. Complaints per hub: join complaints to their shipments' destination hub, and give me complaints per 1,000 shipments for each hub so big hubs are not unfairly punished for volume. 3. Tell me which hub I should be most worried about, considering BOTH delivery rate and complaint rate - and if the data does not actually single one out, say that plainly. I would rather hear "it is everywhere" than a scapegoat.

Hint from the data team: logistics.v_hub_performance…

Independent grading

88/100

Achieved 28 Oct 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