Business Intelligence SolutionLowcost Travel Group

Altitude were contracted to deliver a new centralised Group Data Warehouse (GDW) consolidating data from a number of sources and a Business Intelligence solution.  Using the experience of developing the original data warehouse, this new version was developed to support the creation of a centralised OLAP cube in Microsoft Analysis Services.

The data for the GDW is collated and transformed using Pentaho and includes data from both lowcostholidays and lowcostbeds.

The cube is used widely within the Business (using Excel) to support operational decision making.

  • Technologies
  • SQL Server
  • Analysis Services
  • SSAS
  • Pentaho
  • OLAP
  • Excel
  • MDX
  • Microsoft System Orchestrator