Alaska Airline Analysis with Tableau Visualization
As part of Airline Analysis, we did below steps:
Data Curation and Data Cleaning:
The data processing and wrangling steps are listed below:
Collection and concatenation of the monthly BTS datasets for the year 2018
Conditioned the BTS datasets for use in the project.
Explored Alaska airlines data for meaningful patterns and trends
Analysis:
Generated performance statistics (arrival/departure delay, on-time, cancellation) and created intuitive dashboards to provide better visualization of airline traffic performance.
Analyzed the data across multiple dimensions (time, region, airlines) facilitating comparability across those dimensions.
Please visit my Tableau Public profile to get insight into the analysis.
Executive Summary:
The Bureau of Transportation Statistics (BTS) publishes monthly information about airline on-time flight performance. Included in the monthly datasets is information about every commercial flight under the jurisdiction of the Department of Transportation.
The detailed flight data provides information about scheduled flight times, actual flight times, length of departure delays, length of arrival delays, delay types, delay causes, and cancellations. Details about every flight in the monthly BTS are available to every airline, i.e., any airline can evaluate their on-time performance against every other commercial airline operating in the US.
Data Set: BTS Alaska Airline Dataset from 2018