Flight Operations Dashboard in Power BI
By Mr. Rashid · Corporate training participant · Power BI, based on a synthetic dataset
Overview
A corporate training participant built a seven-page Power BI report on a synthetic airline flight dataset. It lets an operations team see schedules, revenue, flight times, delays, cancellations, diversions and airport congestion in one place.
Objective
Turn a large flight-level dataset into a dashboard that answers operational questions quickly, with one page for each question.
What they built
- Schedule: departure and arrival times by day of week, with carriers and flight numbers, and a “Select Your Day” filter by year, month, week and day.
- Revenue: revenue cards, average revenue by carrier, a carrier, flight and destination table, a revenue KPI against its goal, and an AI-generated narrative summary.
- Elapsed time: actual flight time by carrier, with a KPI trend.
- Delay: departure delay by carrier and aircraft, with a KPI trend.
- Cancelled and diverted: cancellations by carrier, diverted flights, and a revenue-loss measure.
- Diverted: diverted flights by carrier and aircraft.
- Crowd: taxi-in and taxi-out times by flight, as a measure of airport congestion.
Main findings
- Delays: across 227,496 Houston flights, 18% left more than 15 minutes late. Southwest (WN) had the highest average departure delay at 13.5 minutes among the larger carriers, and Thursdays were the worst day at 12.4 minutes.
- Cancellations: February 2011 stood out, with 6.5% of flights cancelled against about 1% in a normal month. That one month explains much of the 2,973 cancelled flights.
- Revenue loss: ExpressJet (XE) carried the largest revenue loss from cancellations, mainly because it flew the most flights.

Dashboard rebuilt from the data in the participant’s seven-page Power BI report. Revenue and revenue-loss values are calculated measures on synthetic data and are illustrative.
Contact us about this course


