Tavrenna Airways
Flights, load factor, fares, and loyalty for a regional airline
About Tavrenna Airways
Industry
Regional airline network, revenue, and operations analytics
Company size
28 airports, 60 routes, 38 aircraft across 6 fleet types
Network scale
42K flights scheduled over two years, 98% operated
Traffic scale
2.55M passengers at 84.4% average load factor
Revenue scale
$495M network revenue, $133M route margin at 26.9%
Dataset scope
15 Professional-tier tables, 2.64M rows
Tavrenna Airways is a fictional regional airline created for synthetic BI demos and training; every airport, city, route, tail number, fare, and crew member is invented. The kit presents a believable mid-market regional carrier where BI builders move from monthly network revenue and load factor into route economics, per-flight operations, punctuality, fare-class mix, ancillary revenue, loyalty, and crew utilization. It is built for network planning, revenue management, operations, and loyalty teams rather than as a dispatch, reservation, or safety system of record.
Operating Profile
- Flies short and medium regional routes on a hub-and-spoke network anchored at Elmwood with secondary hubs at Pinecrest and Thornton, reaching 25 spoke cities.
- Elmwood earns its primary label by filling aircraft fullest at 86.3% load factor, and pays for that density with the weakest hub punctuality.
- The fleet mixes regional jets and turboprops, so capacity, range, and trip cost differ by type, with turboprops about four points behind on punctuality.
- Route costs follow capacity and activity rather than revenue, so load factor moves profitability directly and about 9% of route-months run at a loss.
- Per-flight operations and crew are modeled at full grain, while bookings ship as a representative itinerary sample covering about 76% of passengers.
- Excludes real passenger identities, payment-card data, live reservation records, safety reporting, maintenance logs, and corporate ledger.
Recent Business Events
- 1Twelve new spoke routes opened on a staggered cadence, lifting flight volume gently into the second year without a capacity spike.
- 2Summer travel and the winter-holiday peak drive the busiest months, with a lighter late-winter shoulder and load factor in a healthy band.
- 3Revenue managers now review load factor, fare-class mix, and ancillary attach rate together rather than as separate reports.
- 4Co-brand card and hotel partners have grown loyalty earn alongside the flight base, so redemption is rising as members burn miles.
These are the operating questions this kit is optimized to answer first.
Network and route revenue, available seat miles, load factor, and route margin by month
On-time performance, cancellations by reason, and average delay by route and aircraft
Fare-class and channel revenue mix, average fare, and yield per passenger
Ancillary attach rate and revenue per passenger by product
Loyalty earn, redemption, and outstanding miles by tier
Crew utilization and block hours
Embedded Analytical Stories
Monthly network health
Connect total revenue, passengers, load factor, and route margin month by month.
Route portfolio quality
Compare hubs, regions, aircraft types, and routes on revenue, load factor, punctuality, and margin.
Operational reliability
Follow on-time performance, delay minutes, and cancellations by reason through the weather calendar.
Commercial mix and drillthrough
Connect monthly route P&L down to itinerary bookings and ancillary purchases, and flights down to their full crew complement.
Revenue roll-up
Route P&L revenue rolls up from complete per-flight revenue, with sampled bookings providing the fare-class and channel mix beneath it.