Intermediate · 30 min · 4 steps
Finding the busiest hours so the right number of pickers are on shift
Aditya Nair, Warehouse Operations Analyst at BlinkCart Express
It is Monday, 8:30 AM. Aditya Nair is an operations analyst at BlinkCart Express, an app that delivers groceries in under 10 minutes from 35 small warehouses (dark stores) in Bengaluru. He is at an emergency meeting at the Koramangala dark store. To meet the 10-minute promise, a picker has only 120 seconds to pick and bag an order and hand it to the waiting rider.
The question
Which hours of the day get the most orders, and how do we label each hour as a busy, normal or quiet shift?
- EXTRACT
- DENSE_RANK
- Window functions
- Shift scheduling
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.