"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, Cancellation Rate, Total Flights

Interactive filters (airline, date, airport)

Business Value

Helps airlines/airports:

Identify operational inefficiencies

Optimize scheduling & resource allocation

Benchmark against competitors