Airline Flight Delays Analysis

Optimizing Air Travel: Insights from Flight Delay Data

This Power BI dashboard offers a comprehensive analysis of over 5 million commercial airline flights in 2015, sourced from data compiled for the U.S. DOT Air Travel Consumer Report. The project aims to identify key trends and patterns related to flight volume, delays, and cancellations, providing actionable insights for airlines, airports, and regulatory bodies to improve operational efficiency and passenger experience.

Project Overview & Analytical Goals

The primary objective of this analysis was to transform raw flight data into meaningful insights that address critical questions about airline performance and reliability. Key analytical goals included:

• Understanding overall flight volume trends by month and day of the week.
• Determining the percentage of flights experiencing departure delays and their average delay times.
• Analyzing the seasonal and geographical variations in flight delays, specifically examining flights from Boston (BOS).
• Quantifying flight cancellations and identifying the primary causes (e.g., weather, airline/carrier issues).
• Assessing the on-time departure reliability of different airlines.

Data Source

The dataset comprises records for more than 5,000,000 commercial airline flights operated in the United States during 2015. Each record provides extensive details about a single flight, including:

• Airline name and flight number.
• Origin and destination airports.
• Flight distance.
• Scheduled and actual departure and arrival times.
• Delay and cancellation information, including reasons.

Methodology

1. Data Cleaning and Preparation: The raw dataset required significant cleaning and transformation to ensure accuracy and consistency. This involved handling missing values, correcting data types for time and numerical fields, and standardizing categorical data where necessary. Specific calculations were performed to derive delay durations and categorize cancellation reasons accurately.
2. DAX Calculations: A series of robust DAX measures were developed to calculate key performance indicators (KPIs) and metrics, such as:
   • Total Flight Volume
   • Departure Delay Percentage
   • Average Departure Delay Time (in minutes)
   • Cancellation Rate
   • Percentage of Cancellations attributed to specific reasons (e.g., weather, carrier)
   • On-time performance rates per airline.
3. Interactive Dashboard Design: The Power BI dashboard was designed with a focus on user-friendliness and clear communication of insights. It features:
   • Dynamic KPI cards providing immediate snapshots of total flights, total delays, and cancellation rates.
   • Line charts visualizing flight volume and delay percentage trends over time (monthly and daily).
   • Bar charts comparing airline performance in terms of on-time departures and breakdown of cancellation reasons.
   • Geographical analysis capabilities (if map visuals were used) or filter options for specific airports like Boston (BOS).
   • Slicers and filters allowing users to drill down by airline, origin/destination airport, and time period for detailed exploration.

Key Findings & Insights

The analysis of over 5.8 million commercial airline flights in 2015 provides a detailed understanding of flight performance, delays, and cancellations.

• Overall Performance Metrics:
  • Total Flights Analyzed: 5,819,079
  • On-time Departures: 3,277,948
  • Delayed Flights: 2,125,618 (36.5% of total flights)
  • Cancelled Flights: 89,884
  • Average Delay Time: 32.67 minutes
  • Airports Covered: 322
  • Airlines Covered: 14
• Monthly Delay Trends (Boston Specific): Flights from Boston (BOS) experienced their highest delay percentages in **June (48.6%), July (39.9%), and December (39.1%)**. Conversely, **October (28.8%) and September (29.9%)** showed the lowest delay rates. This highlights the impact of peak travel seasons and specific weather patterns.
• Total Flights by Month:
  • January: 470K
  • February: 429K
  • March: 504K
  • April: 497K
  • May: 521K
  • June: 511K
  • July: 456K
  • August: 479K
  • September: 468K
  • October: 468K
• Most Reliable Airlines (by On-time Flights): The analysis identified the top performers for on-time departures:
  • Southwest Airlines: 532K on-time flights
  • Delta Air Lines: 472K on-time flights
  • American Airlines: 385K on-time flights
  • Skywest Airlines: 345K on-time flights
  • Atlantic Southeast Airlines: 333K on-time flights
• Airports with Most Cancelled Flights: Major hubs showed significant cancellation volumes:
  • Chicago O'Hare: 8.5K cancellations
  • Dallas/Fort Worth: 6.3K cancellations
  • Newark Liberty: 5K cancellations
  • General Edward Logan (Boston): 5K cancellations
  • LaGuardia: 4.5K cancellations
• Weekly Delay Patterns: While delays are generally consistent, slight variations were observed:
  • Monday: 37.4% delayed
  • Tuesday: 35.0% delayed
  • Wednesday: 35.0% delayed
  • Thursday: 34.0% delayed
  • Friday: 36.8% delayed
  • Saturday: 36.9% delayed
  • Sunday: 36.9% delayed
• Reasons for Flight Cancellations:
  • Weather: 48,851 cancellations (54.3%)
  • National Aviation System: 25,262 cancellations (28.1%)
  • Airline/Carrier: 15,749 cancellations (17.5%)
  • Security: 22 cancellations (0.0%)
  Weather remains the dominant factor in cancellations.

Recommendations

• Seasonal Preparedness: Airlines and airports should bolster resources and contingency plans during summer months (June, July) and December, as these periods consistently show the highest delay rates due to increased demand and potential weather disruptions.
• Weather Risk Mitigation: Given that weather is the dominant cause of cancellations (54.3%), investments in advanced meteorological forecasting and improved operational protocols for adverse weather conditions are crucial to minimize disruptions.
• Targeted Airport Interventions: Major hubs like Chicago O'Hare and Dallas/Fort Worth, identified as hotspots for cancellations, require a deeper analysis into their infrastructure, scheduling, and operational processes to address underlying challenges.
• Reliability-Based Decisions: For travelers with time-sensitive schedules, airlines like Southwest and Delta Air Lines, which demonstrate higher on-time performance, are preferable choices. Airlines with lower reliability should analyze best practices from top performers to improve their punctuality.

Project Impact & Value Proposition

This project showcases strong skills in large-scale data handling, complex analytical problem-solving, and impactful dashboard design. The Airline Flight Delays Analysis Dashboard provides significant value by:

• Enhancing Operational Efficiency: Providing airlines and airports with clear, data-driven insights to proactively manage resources, minimize delays, and reduce cancellations, leading to smoother operations.
• Improving Passenger Experience: Contributing to more reliable air travel by identifying and addressing systemic issues leading to disruptions, ultimately leading to greater customer satisfaction.
• Supporting Strategic Decision-Making: Offering a robust analytical tool for stakeholders to benchmark performance, identify areas for investment, and develop strategies for continuous improvement in air travel, fostering long-term growth and stability.
• Demonstrating Data Proficiency: Highlighting the ability to extract, transform, and visualize actionable insights from complex, high-volume datasets to solve real-world business challenges within the aviation industry.