Project
FlowRoute Logistics Co. · SQL · Intermediate
The brief
From: Kemi Oyedepo, Financial Controller
First: the full picture, all history. A shipment counts as under-declared when the hub scale reading exceeds the declared weight by more than 20% (below that, scales and packaging argue; above it, someone is lying).
1. How many shipments are under-declared, and what share of all WEIGHED shipments is that? (Unweighed parcels have no scale reading - keep them out of your denominator and say so.) 2. The leakage in NAIRA: for each under-declared shipment, the fee it should have paid is fee x (actual / declared). Sum the shortfall. 3. Split both by customer type: are business accounts worse than individuals?
Label the naira columns as naira. If I see raw kobo at the board I will send it back.
Independent grading
92/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