Overview

Data Warehouse Overview

The purpose of the Data Warehouse project is to provide a solution which will deliver quality, timely and accurate information to the business enabling both strategic and operational decisions to be made, realising one version of the truth.

This will be achieved through the delivery of a scalable enterprise wide Data Warehouse solution using Cognos as the reporting tool. The solution will integrate with multiple ‘source’ systems such as SAP ERP solution, Aztec EPoS and RezLynx. In addition to this it will use external sources such as CLMS for machine sales. The Data Warehouse will be the data repository that feed numerous reports for the business. The solution will be scalable and stable so that, over time, it can be extended and enhanced to a point where the data within the Data Warehouse will become the single source for business intelligence, analysis, planning and reporting.