Data Warehousing

"A central repository of data which is created by integrating data from multiple disparate sources to store current and historical data"

With numerous industry definitions available in reference materials, in general terms, data warehouse is a database, different to transactional processing, that can combine data from multiple disparate sources designed to enable business intelligence activities through the use of data analysis and reporting by organisations.

Data Warehouse features Subject Orientated data that is Integrated, Non-volatile and Time-variant.

The leading data warehouse architectural types are: (a) Centralised Enterprise Data Warehouse; (b) Decentralised Independent Data Marts; (c) Federated; (d) Hub-and-Spoke architecture; and (e) Data-Mart Bus architecture.

We can assist with designing and building a data warehouse that would integrate the data from multiple operational system(s) and disparate sources to establish a common format that would enable for data analysis and report creation using current and historical data. This offers benefits to significantly enhance decision-making capabilities and improving information efficiency and effectiveness.

We can also offer support to build data marts which are a subset of the data from the data warehouse. We can implement data marts relatively quickly as the data has already been collected and integrated within data warehouse.

We can help with Data Warehouse Administration to manage existing Data warehouse architecture including Data Integration and Data Quality.

Our Data Warehouse Administrators are experienced professionals with BI and query tools, specialised database design for data warehousing, and knowledge of data warehousing technologies.

Typical Data Warehouse Architecture -