Intermediate · 30 min · 5 steps
Catching a day when half the orders went missing
Naveen Sundaram, Senior Data Platform Engineer at BharatLogistics Direct
It is 6:30 AM on a Monday. Naveen Sundaram, a data platform engineer at BharatLogistics Direct, gets an urgent call from the Chief Technology Officer. BharatLogistics moves parcels by truck across 28 states.
The question
How do we compare each day's row count with the day before in SQL, and flag a sudden big drop in how much data was loaded?
- Row count assertions
- LAG
- Anomaly detection
- Data quality
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.