Flight Tracking DB

Challenge

With 300K flight records, which airlines, cabin classes, and booking windows actually drive ticket price — and where does price stop being about distance?

Approach

A three-page Power BI report on a star-schema model with airline, city, class, departure-time, and arrival-time dimensions. Pages cover an executive summary, a pricing and booking deep dive with correlation analysis, and a route-level view.

Outcome

1. Business class is 11.12% of tickets sold but a far higher share of value, with average business fares several times economy.
2. Duration barely predicts price: the correlation plot flattens after the first few hours, so scheduling — not distance — sets the fare.
3. Fares stay flat until roughly 10 days before departure, then spike sharply — a clear last-minute pricing window.
4. Vistara and Air India dominate both flight volume and premium pricing; the six busiest city pairs cluster around Chennai, Bangalore, and Kolkata.