Airline tools
Visualizations and strategic tools that make the airline business easier to see: where the planes are, where people want to fly, and how the commercial side works. Built on open data, with short courses from my years in Revenue Management and Loyalty.
Tools
Live data, maps and simulatorsRevenue management
Booking limits
How many seats to keep for late, high-fare passengers with EMSR-a and EMSR-b, and how many extra bookings to accept for no-shows.
Booking curve forecaster
Watch a flight's bookings build up and compare five ways airlines forecast where they'll finish: pickup, smoothing and regression, scored across a year of simulated departures.
Buy-down simulator
Why seat control that forecasts from its own bookings spirals down once fares lose their restrictions, and how Q-forecasting with fare adjustment stops it.
Network bid prices
Why airlines moved from fare-class limits on each flight to origin-destination control: leg bid prices from a linear program, then one stream of bookings run through leg-based and O&D control, request by request.
Loyalty
Breakage & liability
How points become deferred revenue and then revenue, what breakage is, and what a revised breakage estimate or a new expiry rule does to the numbers.
Award value comparator
How many points Aeroplan, MileagePlus, Flying Blue and Etihad Guest ask for the same trips, what that's worth in cents per point, and how your own redemption compares.
Knowledge
Beginner's guides to the commercial side of an airlineRevenue Management
How airlines price seats and fill planes as profitably as possible: a mix of economics, statistics and a bit of psychology.
Read the courseLoyalty programs
Why airlines give away miles and still come out ahead, and how the points currency behind a loyalty program is managed.
Read the courseNetwork Planning
How airlines decide where to fly, how often, when, and with what aircraft.
Read the course