Airline Operations Analytics

Which routes, carriers and operating patterns correspond with passenger-volume and load-factor differences?

Airline passenger and flight data compared by carrier, region, flight type, route distance and weekday/weekend period.

1. 01Filter and validate operational data
2. 02Aggregate and compare carriers and regions with SQL and Excel
3. 03Build Power BI reports for demand and operations measures
4. 04Review route and carrier patterns

Compared passenger volume, flight activity and load factor across carriers, routes, flight types, operating regions and weekday/weekend periods.

What I builtPower BI reporting for passenger demand, flight activity, load factor, carrier performance and route trends.

• 01

  The dataset covered 187M passengers and 3M flights across 1,152 cities and 6 regions.

• 02

  The under-500-mile distance group contained 44,437 flights.

• 03

  The reports tracked passenger volume, flight activity, load factor, carrier performance and route trends.