BOBJ – Aviation – Airline Revenue Analysis – Success Story

Client Overview

Client is a group of high-end consultants for Global Aviation industry providing consulting services to airline companies right from formation, recovery, Business Plan, Route and Network Optimization to Fleet Optimization. These individuals carry 20+ years of experience in Aviation industry with a history of providing these services to 20+ Airlines globally.

Business Challenge

  • Client wanted to improvise upon its business operations process and to fulfill the need for abstract and dashboard reporting on a UI-rich platform.

  • Additionally, extraction of data for reporting was challenging owing to huge data size.

Technical Requirements

  • Business Objects XI 3.1

  • XCelsius 2008

  • Microsoft SQL Enterprise Version with Integration Services and Analysis Services

  • Microsoft .Net 3.5

Solution Strategy

  • Eternus Solutions reviewed the business objectives and worked with the client to implement a new analytical system based on SQL Server 2008 Analysis Services with .Net 3.5, Microsoft SQL Server – Enterprise, SSIS, BOBJ XI 3.1, and XCelsius 2008.

  • Daily transaction information is loaded at each Airport, which is consolidated at the Airport Hub. Reports are then available to managers for more insightful business decisions.

  • The users can now easily identify trends and target areas of improvement. Furthermore, users can slice and dice and view multidimensional information relevant to them using Online Analytical Processing (OLAP) cubes.

Implementation Details

  • Import Data from multiple formats into MS SQL Server using SQL Jobs and Integration Services Packages

  • Build de-normalized data marts from raw data after applying extremely complex business logic

  • Push the data to Reporting tables

  • Prepare Cubes for data

  • Access them into Reporting tools like BOBJ and XCelsius

Solution Components

  • Implementation of SSIS Packages for importing data

  • Definition and design of cubes

  • Design of Business Universe for BOBJ Reports

  • Export Excel based reports

  • Connect excel data sheets to XCelsius and build reports

This Report Shows the Gross Passenger Revenue forecasted for next five years with what is Analysis for specific Year.

This Report Shows the Net Passenger Revenue forecasted for next five years along with Direct Operating Costs and Contribution to the total revenue.

 Airline Revenue Analysis1  Airline Revenue Analysis2

Share This Case Study