Activity areas

Business Intelligence

To ELFO BI means designing a set of processes necessary to collect and organize data, with the scope to create systems used to analyze strategic business and process information. Using a specific technology, the final result is to give more value to information.

Business Intelligence

BI, Big Data, ML

Data, BIG DATA, Business Intelligence and Machine Learning merge into unique solutions. It is possible to design BI systems integrated with Big Data solutions but also implement Machine Learning systems starting from the same dataset. The value of data can increase, giving both strategic representations and using it as a train set for classification systems (clustering), prediction, anomaly detection, etc.

Business Intelligence

ETL Approach

Extract, Transform, Load (ETL) describes the process of extracting data from source systems, their conversion into a format or structure appropriately designed for queries and analysis and finally load them to the data warehouse. ETL leverages a dedicated staging database and applies a set of rules or functions to the extracted data before loading.

Business Intelligence

ELT Approach

Extract, Load, Transform (ELT) is a different approach to data loading. It takes data from different sources and loads it directly into a target system, such as a data warehouse. The system then transforms on-demand the loaded data, in order to allow the appropriate analysis.

ELT offers faster loading if compared to ETL but it requires a powerful system to perform on-demand data transformations.