Technical analysis and design of DW models
The project began with an analysis of existing data structures, business processes and the company’s reporting needs. The job was to transform complex business requirements into a clear and coherent technical solution.
The documentation which came out of the analysis contained a business model, the design of the required reports, the design of the data warehouse in the form of a multidimensional data model and basic guidelines for the implementation of the complete analytical solution. The aim of the design of the data warehouse was to ensure that fundamentally the Business Intelligence system is able to standardize data from various sources and to collect it almost in real time. Users should get fast, flexible and easy access to consolidated information.