Warehouse Operations Monitoring

Four fulfillment nodes, two years of operations. Relational and document sources consolidated into one star schema, with a workload forecast and NLP signals from supervisor shift notes.

Node

Daily throughput

Units picked per day, 28-day trailing average. Peak season lifts every node.

On-time shipping vs daily load

Each node-day bucketed against that node's own average volume. Scale is fitted, not zero-based.

Forecast vs actual

Held-out final 90 days. Gradient boosting on lag and calendar features.

Model comparison

Lower MAE is better. Both baselines are what a planner would use without a model.

Pick time by storage zone

Average seconds per pick task — the slotting opportunity.

Shift-note themes

Share of notes by cluster label, from TF-IDF + LSA + k-means.

Staffing chatter vs on-time rate

Weekly, one point per node-week.

Cost to serve by carrier

Freight cost per shipped unit, with delivery performance.

Data quality gate

Rules evaluated on every load. Failures are quarantined, never silently dropped.

Next 14 days — forecast workload and labour plan

Recursive forecast fed back into itself, converted to picker-hours at each node's recent units-per-hour rate.