ETL process


 

In the context of Business Intelligence, the ETL process signifies the data transfer from one or multiple previous systems into a central data warehouse; it consists of the following steps:


1. Extraction of data from the previous systems, typically from ERP systems
2. Transformation (= preparation or cleaning) of extracted data
3. Loading of the transformed data into a data warehouse

 

The ETL process is significantly different in the respective cases of Classic BI and Financial Intelligence.

ETL with Classic BI

The central advantage of a classic Business Intelligence solution (Classic BI) is the individualised data warehouse, which is adjusted to the custom requirements of each company. This advantage comes with the associated higher set-up costs: the configuration of the specific data model and the suitable ETL processes usually add a large cost and time factor to the implementation; it is solely IT experts who may execute these changes.

ETL with Financial Intelligence

The requirements on the data model in a Financial Intelligence solution span industries and geographical regions and therefore they may be standardised. For this reason, the associated ETL process may also be standardised, and realised using ready-to-implement standard software. The result is a significant saving of time and cost during implementation.

 

Back to glossary