KPI & MI Reporting SolutionLowcost Travel Group

With their package holiday business growing fast, it became necessary to implement effective management reporting. Using the main booking engine as the primary data source, we created a new data warehouse for lowcosttravelgroup with data from both lowcostbeds and lowcostholidays.

The challenge was to create a data warehouse that would have enough granularity for the reporting yet not making it so complicated that business analysts found it difficult to work with.

Using SQL Server stored procedures we created data routines to transform the raw data into the simplified data warehouse. For reporting Altitude developed a series of Crystal reports and automation routines to distribute the reports to interested parties on a daily, weekly or monthly basis.

In addition, Altitude have created a series of reports utilising the power of Excel pivot tables which link directly to the data warehouse. The reporting requirement continue to expand with the introduction of new markets and other data sources, such as the Google Adword reporting. To support the reporting infrastructure,

Altitude have also created a backoffice application in Access to allow staff to configure reporting parameters.

  • Project delivered: March 2015
  • |
  • Industry: Travel
  • Technologies
  • SQL Server
  • Crystal Reports
  • VBScript
  • MS Excel
  • MS Access
  • Microsoft System Orchestrator