DBEA55AED16C0C92252A6554BC1553B2 Clicky DBEA55AED16C0C92252A6554BC1553B2 Clicky
April 18, 2024
desperate measures
Care to share?

If you’re still bored with sitting around waiting for the holidays to end, we got you.

Of course, our solution is another data model. This is great for killing time and learning something at the same time.

Have you ever wondered how much you spent going between two places in the US by air?  How about schedule padding?  That part where the booking system says one thing, but the actual time is quite different.

You may be surprised to see how long airlines need to complete a flight.  Schedule and actual vary more than you might think.  Our model consists of three pages: page 1 looks at airlines, page 2 looks at days of the week, and page 3 looks at months.

Our model focuses on the top 20 origins and destinations for brevity.  The way the model works, select an origin point and then notice how the destination column adjusts only to show airports with flights from the selected origin point.

  • The top table shows the expected CRS (booking) average time for the selected city pair.
  • The middle table shows the average actual time the flight took.
  • The bottom table lists the padded minutes (CRS minus Actual). In the third table, green is a relatively low padded time while red is the relatively highest time.  Red is, therefore, not a good report.

Remember that airlines sell schedules and every minute over schedule costs serious money.  For the sake of this exercise, assume at least $100/minute.  Then, consider the table below. As you see, the number of flight delays is huge – multiplying by ~$100/minute generates eye-watering costs.

DoT On Time AirInsight

Here you go – enjoy! Optimize your viewing by clicking the double-headed arrow at the bottom right of the model.

+ posts

Co-Founder AirInsight. My previous life includes stints at Shell South Africa, CIC Research, and PA Consulting. Got bitten by the aviation bug and ended up an Avgeek. Then the data bug got me, making me a curious Avgeek seeking data-driven logic. Also, I appreciate conversations with smart people from whom I learn so much. Summary: I am very fortunate to work with and converse with great people.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.