SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

ETL (Extract, Transform, Load)

What it is

ETL stands for extract, transform and load. It is the process of extracting data from source systems, transforming it by cleaning, converting, joining and calculating, and loading it into a target such as a data warehouse or a new system. A variant called ELT loads the raw data first and transforms it inside the target.

Why it matters

Most reports and dashboards depend on ETL jobs running correctly every day. When numbers are wrong or late, the cause is often in this pipeline. Analysts specify the business rules for the transformations, define the checks that prove a load worked and help investigate when a report does not match the source.

Example

Every night, Parcel Bazaar's ETL job extracts orders, returns and payments, removes test orders, converts all amounts to rupees, joins orders to customers and loads the results into the warehouse. The analyst specified the rule for removing test orders after finding that they inflated sales by two percent.

CHECK BEFORE CONTINUING

Keep your work safe