Data Warehouse

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)
Accounting
Controlling
Ingo LaRoche