Aviation
Lots of flights, lots of timestamps, and a delay code for everything.
KPIs we usually build
- On-time performance (departure and arrival)
- Load factor and seat revenue
- Turnaround time by airport and aircraft type
- Delay minutes by cause code
- Cancellations and rebooking
Typical challenges
- Time zones and local versus UTC times
- Large fact tables of flight legs
- Delay code hierarchies that differ between systems
Practise on the free aviation dataset.