US-Domestic-Flight-Performance-Dashboard

As a data analyst, you have been given a task to monitor and report US domestic airline flights performance. Goal is to analyze the performance of the reporting airline to improve fight reliability thereby improving customer relaibility.

Below are the key report items,

• Yearly airline performance report 
• Yearly average flight delay statistics

Components of the report items

1. Yearly airline performance report

   For the chosen year provide,

   • Number of flights under different cancellation categories using bar chart.
   • Average flight time by reporting airline using line chart.
   • Percentage of diverted airport landings per reporting airline using pie chart.
   • Number of flights flying from each state using choropleth map.
   • Number of flights flying to each state from each reporting airline using treemap chart.

2. Yearly average flight delay statistics

   For the chosen year provide,

   • Monthly average carrier delay by reporting airline for the given year.
   • Monthly average weather delay by reporting airline for the given year.
   • Monthly average natioanl air system delay by reporting airline for the given year.
   • Monthly average security delay by reporting airline for the given year.
   • Monthly average late aircraft delay by reporting airline for the given year.