TRAP@NCI

Analysis of US Domestic Flights

Normoyle, Michelle (2014) Analysis of US Domestic Flights. Diploma thesis, Dublin, National College of Ireland.

[img]
Preview
PDF (Diploma)
Download (2MB) | Preview

Abstract

The purpose of the project was to develop a business intelligence system that would provide insights into the US domestic flights industry with an emphasis on flight delays. The aim of this analysis was to allow one to make a more informed decision when booking a flight in order to minimise delays. Due to the high volume of data a database was set up, analysis was carried out using SQL and statistical techniques such as linear regression and ANOVA. It was found that certain carriers, namely Frontier Airlines, JetBlue Airways & ExpressJet Airways have the highest amount of flight delays out of 16 different carriers. The carriers with the best-on-time performance are Hawaiian Airlines, Alaska Airlines, US Airways & Delta Airlines. The best day of the week to fly to minimise delays is Tuesday or Saturday. The days of the week that have the most delays is Thursday and Monday. Flight delays increase as time of the day increases, it is best to fly early in the morning. Flight delays are more than 20% from 4pm in the day onwards. ExpressJet Airlines and SkyWest Airlines had the most cancellations.

Item Type: Thesis (Diploma)
Subjects: Q Science > QA Mathematics > Electronic computers. Computer science
T Technology > T Technology (General) > Information Technology > Electronic computers. Computer science
Divisions: School of Computing > Higher Diploma in Science in Data Analytics
Depositing User: CAOIMHE NI MHAICIN
Date Deposited: 15 Dec 2014 15:53
Last Modified: 15 Dec 2014 15:54
URI: http://trap.ncirl.ie/id/eprint/1885

Actions (login required)

View Item View Item