Question

Analyses to help reduce delays for an

airline client

Your client is currently #3 by volume of flights flown. They are keen to understand

on how best to improve their business performance across metrics such as

customer satisfaction etc.

1. Data - there are 12 files corresponding to 1 year of data that captures flights

by origin: destination ids and airline code

2. You are more than welcome to add any 3rd party data sources

Please submit a word document along with data visualizations as well code in

Python language (can be in notebook or script format). Explain in detail on how to

improve their business performance and below questions. (provide 3 strong

recommendations backed up by data points)

Additional Questions

1. Which airline has the 5th highest delay?

2. Which day of the week is the 2nd most popular?

3. Which is the 4th most flown sector?

4. Add any other analyses you believe would shed additional light on our client

and their competition

5. What do you believe are the root causes of their issues?

6. What do you recommend the airline addresses?

7. How would you enhance the study given additional time

Question image 1