More complex information requests often mean that the necessary data comes from different departments, and exists in different formats.
The solution for this problem is the use of a reporting database, a data warehouse. Here the data is stored in an unambiguous format, and is optimised for the quick analysis of large amounts of data.Read more
To fill a data warehouse with updated data in a fully automated manner, software is needed that we refer to as data integration or ETL products (extract, transform, load).
This software can be created manually with scripts, but often specific tools are being used that increase productivity.Read more