Intermediate 4 days · 50 tasks

Warehouse Same-Day Dispatch Misses

A fulfilment centre that used to ship almost every order on time missed one in five during the festive peak, and clients are charging penalties. Find whether volume, staff, layout or stock problems are to blame.

Godam Fulfilment Services · SQL · Python (pandas, seaborn) · solved in your browser

Locked for now

This project opens soon. Start with the free project in Logistics & Supply Chain meanwhile.

See Logistics & Supply Chain projects

The problem

SLA performance collapsed in October and penalties jumped. The Head of Operations must explain to clients and to Godam's management what caused the misses (order volume, staffing and attendance, the new pickers, the mezzanine move, or short picks), how much each matters and what to fix before the next sale, using order, pick and staffing data from 1 August to 31 October 2026.

How it works

Start the project — the 4-day timer begins and the workspace opens with every table loaded.
Solve 50 tasks in SQL or Python (30 basic, 15 intermediate, 5 hard). Each is checked instantly.
Write the final report in the workspace and add charts from your notebook.
Score = 70% tasks + 30% report review. 60 or more earns a certificate.

What you will deliver

Answers to the 50 analysis tasks (30 basic, 15 intermediate, 5 hard), solved with SQL or Python in the JobPrax workspace.
A final report written in the workspace: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report.