✈️ Airline Delays Dashboard (Excel)

An interactive Excel dashboard analyzing U.S. airline delays in 2024.
The dashboard is powered by PivotTables, slicers, and KPIs — allowing you to filter by airline, airport, delay type, and time period to explore flight performance.

Sheets with raw data and calculations are protected/hidden to keep the file read-only. Users can still interact with slicers and explore insights without modifying the data.

---

Features

• Interactive slicers for airline, airport, and year/month filtering
• KPIs showing:
  • Total flights
  • Percentage of flights delayed
  • Average delay minutes
• Visualizations:
  • Delay trends over time
  • Breakdown of delays by cause (weather, carrier, NAS, security, late aircraft)
  • Comparisons by airline and by airport
• Read-only protected workbook (data/model sheets hidden, structure locked)

---

Data Source

This analysis uses 2024 data from the U.S. Bureau of Transportation Statistics (BTS):
👉 On-Time Performance — Causes of Flight Delays

---

How to Use

1. Download Airline Delays Project.xlsx from this repo.
2. Open in Microsoft Excel (desktop recommended).
3. Use the slicers to filter by airline, airport, or time period — charts and KPIs update instantly.
4. The workbook is securely protected: data/model sheets are hidden, and structure is locked.

---

Interactive Demo:

---

Tools & Techniques

• Microsoft Excel
• PivotTables & PivotCharts
• Slicers for interactivity
• Workbook & sheet protection (read-only sharing)
• Data source: U.S. Bureau of Transportation Statistics (2024)

---

🧠 What I Learned

• How to design interactive dashboards using PivotTables and PivotCharts
• Effective use of slicers and timeline filters to allow end-users to explore data dynamically
• Structuring raw datasets and building a star-schema style data model inside Excel for clean analysis
• Leveraging calculated fields and measures within PivotTables to derive KPIs (e.g., % delayed flights, average delay minutes)
• Creating layered visualizations (trend charts, cause breakdowns, KPI cards) to provide both summary and drill-down insights

---

Author

• Ashik Rahman
  • Aspiring Data Analyst
  • Exploring healthcare, biotech, and aviation data projects
  • Connect with me on LinkedIn

---

License

This project is licensed under the MIT License.