Airline Operations Dashboard: Delay Root Causes & Carrier Performance

This project is an interactive data dashboard analyzing airline and airport operational performance, tracking key metrics such as: 1. Flight Disruption Analysis Cancellation rates by carrier (e.g., Pinnacle Airlines: 9.12%) Delay root causes (weather, carrier, NAS, security) Average delay times by destination (e.g., EWR: 80 minutes) 2. Flight Volume & Traffic Flight counts per airline (e.g., Southwest: highest volume) Airport traffic breakdown (e.g., Hartsfield-Jackson Atlanta: busiest) Top 10 airports by flight frequency 3. Geographic & Operational Insights Route performance (e.g., Chicago O’Hare vs. Midway delays) Time-based trends (delays by day/month) Technical Implementation Built with Power BI/Tableau Key metrics: Avg Delay, CancellationRate, Total Flights Interactive filters (airline, date, airport) Business Value Helps airlines/airports: Identify operational inefficiencies Optimize scheduling & resource allocation Benchmark against competitors