Intermediate · 30 min · 5 steps
Telling a real revenue drop from a normal bad day
Rajesh Kannan, Logistics BI Engineer at ParcelWise Logistics
It is Tuesday, 8:15 AM. Rajesh Kannan is a business intelligence engineer at ParcelWise Logistics. He opens his monitoring screen at the main sorting hub in Bhiwandi, Mumbai. ParcelWise delivers over 1.2 million parcels a day for online shops, medicine suppliers and direct-to-customer brands, across 24,000 pincodes.
The question
How do we use a 3-day moving average and a running total to find real changes in daily revenue, and ignore normal daily ups and downs?
- Moving average
- Window framing
- ROWS BETWEEN
- Anomaly detection
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.