The ETL Process in
Brief
Presented by
, The ETL Process
◦ ETL (Extract, Transform, Load) is the process of integrating raw data from multip
sources into a data warehouse (Knight, 2017).
◦ ETL process includes combining, cleaning, and organizing raw data from differen
sources into a single, consistent dataset (What Is ETL (Extract, Transform, Load)?
IBM, n.d.).
◦ Requires 3 operations:
◦ Extract: Importing a copy of data from a source
◦ Transform: Translates the raw data to match the format of the target system
◦ Load: Loading the processed data into the target system
Brief
Presented by
, The ETL Process
◦ ETL (Extract, Transform, Load) is the process of integrating raw data from multip
sources into a data warehouse (Knight, 2017).
◦ ETL process includes combining, cleaning, and organizing raw data from differen
sources into a single, consistent dataset (What Is ETL (Extract, Transform, Load)?
IBM, n.d.).
◦ Requires 3 operations:
◦ Extract: Importing a copy of data from a source
◦ Transform: Translates the raw data to match the format of the target system
◦ Load: Loading the processed data into the target system
