Implementation of a data warehouse to integrate information from ERP and CRM systems, as well as flat files, which contain data from every company’s department. Implementation of ETL process improved flow of data from the source to the data warehouse. The process can be run automatically or can be started manually. As a part of implemented solution, the reports about monitoring of instalments, current size and structure of sales in respect of weekly or monthly plans were prepared. The users gained access to reports directly through the Internet, thanks to that, they can easily manage a structure of folders.
Case study
Technology used in project: MS SQL Server 2008 R2.
Optima SA – financial service company.