Warehouse Analytics
Introduction
An analysis for an e-shop that measures how long it takes on average to pack one item and how each worker compares. The project is under NDA, so it is described only in general terms.
Goal of the project
Give warehouse management objective numbers instead of estimates, as a basis for shift planning and training.
My approach
A Python pipeline joins data from two systems: the ERP (document created) and the goods-check system (MongoDB). It cleans the data, filters out shared accounts and computes metrics over a single unified view. The method and its known limits are documented, and all thresholds live in one place.
Result
A single command generates a monthly PDF report comparing workers, and it can be rerun for any month.
Photos