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.
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.
Business Objects XI 3.1
Microsoft SQL Enterprise Version with Integration Services and Analysis Services
Microsoft .Net 3.5
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.
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
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.