english|german
 
 
 
 

Data Warehouse

Bild: Ein Stapel aus Steinen

A fundamental requirement for Business Intelligence, as a central data storage system consolidating a multiplicity of heterogeneous source systems, is the data warehouse, with its components:


  • Evaluation


  • Data preparation


  • System integration


  • Data model

Find knowledge, shed uncertainty

Decision makers on all levels are interested above all in fast and uncomplicated access to business-relevant information, whether as a report, a dashboard or a BSC.

In order to fulfill these requirements particular attention has to be paid to data quality, efficiency and the perfect interaction of individual components in the design and implementation of a data warehouse:


Evaluation

  • Meaningful and user-friendly reporting supported by the modern and attractive presentation of decisions and planning

Data preparation

  • Extraction is determined by the frequency and volume of data to be integrated and serves as an interface to operative data sources
  • Transformation harmonizes data according to reporting needs and ensures quality of information
  • The loading process sees to the connection-oriented distribution of data for evaluation purposes

System integration

  • Future-proofing and protection of investment through the trouble-free integration of heterogeneous systems employing the most up-to-date technologies

Data model

  • Based on the appropriate and timely processing of data through scalable and robust architecture (hardware and software)