Verified by DataSimHQ

Analyst

Sumaya Mateen

Lead Analyst

Project

Size the under-declaration

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