Airline Authority Analysis

Situation:

Flight delays and cancellations significantly impact airline operations, customer satisfaction, and revenue. Understanding delay trends, airline-specific performance, and seasonal variations is crucial for optimizing airline scheduling and improving efficiency.

Task:

The goal was to develop a Power BI dashboard that provides insights into flight performance, delay patterns, airline-specific metrics, and monthly trends. The objective was to help airline authorities and operations teams make data-driven decisions.

Action:

Data Integration & Cleaning: Used Power BI to load and preprocess flight data, ensuring accuracy.
Visualizations & Filters: Created interactive visuals, including bar charts, trend lines, and heat maps, to analyze flight delays, cancellations, and airline performance.
Key Metrics & Insights:
- Flight Performance: Identified that 65.29% of flights were on time, while delays and cancellations accounted for the rest.
- Day-Wise Analysis: Found that Tuesdays and Thursdays had the highest delays, while Wednesdays had the most cancellations.
- Airline-Specific Performance: Noted that Southwest Airlines had a higher delay trend in 2010 than in 2009.
- Monthly Trends: Observed significant delays in November, prompting a need for further analysis.
- Year-over-Year Delay Trends: Compared 2009 and 2010 delay trends to uncover operational inefficiencies or seasonal factors.

Result:

Developed an interactive Power BI dashboard that enables users to filter by airline, year, and month for a detailed comparative analysis.
Provided actionable insights to improve airline scheduling and reduce delays.
Demonstrated the ability to work with real-world data, implement advanced Power BI visualizations, and drive business decisions with data analytics.