Airlines Delay Analysis

This project is dedicated to visualizing and analyzing airport delay data, aiming to create an intuitive and user-friendly Power BI dashboard. The primary objective is to offer insights into delay reasons and empower users to filter data by airport, airline, and time period for effective decision-making and enhanced airport operations.

Dataset Overview:

Utilized insights from a 2008 Airline Delays dataset sourced from Kaggle: https://lnkd.in/dJEC8YKt

? Data Preparation:

Executed meticulous cleaning and transformation of data for optimal analysis.

Dimensional Modeling:

Implemented a robust star schema, focusing on dimensions like DimDates , DimDest, DimOrigin, DimCancellation and DimCarriers to enhance data organization and accessibility.

DAX Measures Table:

Created a dedicated table housing essential measures for streamlined reporting.

Hierarchy Enhancement:

Improved analysis depth with a Date hierarchy.

Data Integration: Integrated worldwide airports' data, translated cryptic cancellation codes, and mapped IATA codes for enhanced clarity.

Visualizations:

Designed a visually appealing dashboard featuring:

Cards for quick insights.

Drill Down functionality for detailed exploration.

Drill Through options for a deeper dive into specific data points.

Tooltip page for an enhanced user experience.

Synced slicers, and an interactive dashboard with bookmarks and buttons.

A variety of charts for comprehensive data representation.

This project not only delves into the intricacies of airline delays but also sets the stage for informed decision-making in the aviation sector.