Airline Analytics Framework

… is a framework used for reporting and data analysis:

  • Collect data from multiple airline data sources into a single location so a single query engine can be used to present data,

  • Enabling a central view across the enterprise,

  • Gives global decision–support,

  • Analytics - finding and quantifying hidden patterns in the data,

  • Maintain data history, even if the source transaction systems do not.

Empower everyone to uncover insights with relevant data, easy-to-use tools, and stunning visuals embedded in Microsoft apps they use every day.

The platform is technology agnostic (runs with different databases and Analysis tools (PowerBI, DeltaMaster, Tableau, etc.), but preferably on the latest cutting-edge intelligent data foundation, Microsoft Fabric (Power BI, OneLake data platform, Copilot AI).

The data framework is Open Source. We developed it in our projects and share it free with our projects.

Passenger / CRM / Traveller ID

  • Source: PSS, Amadeus SBR Feed

  • Traveler ID

  • Trip info

  • Contacts

  • Profiles

  • Loyalty

Booking stream

  • Source: PSS, BIF, Amadeus SBR Feed

  • Forward Bookings

  • Early warning parameters (under- and outperformer)

  • Revenue Forecast

  • Route Patterns

Sales

  • Source: Revenue Accouting (PSS, ARA, MAUREVA, MonaLisa)

  • Salesdata

  • Sales Analysis

  • Marketing Analysis

  • Booking Channels

  • Forecasts / Budget Tracker

 

Checkin / OnBoard

  • Source: DCS, On-board sales

  • Baggage, Seats

  • Anxilliary Revenue (EMDs, NDC)

  • Onboard services

  • Traveller ID

 

Flown / Uplift data

  • Source: Revenue Accouting (PSS, ARA, MAUREVA, MonaLisa)

  • Uplift data

  • Budget comparison

  • Historical data

 

Accounting / Financial controlling

  • Source: ERP, Operational data, Cost model

  • P&L, Contribution reports

  • Route P&L

  • Instant Flash results (historical and future flights)

 

Operations

  • Source: OPS

  • Aircraft movements

  • Flight indicators (Delay, OTP, Reliability)

  • Crew data

 

Crew Analysis

  • Source: OPS

  • Aircraft movements

  • Flight indicators

  • Crew data

We support existing integrations with:

Amadeus Altea, Amadeus ARA, Amadeus DCS, Maureva EDGAR, CoForge Monalise, Videcom, Bravo PSS, Radixx, SABRE, WorldTicket and others on request.