The Industry Portal
Data and automation

ETL (extract, transform, load)

The process of pulling data from sources, reshaping it, and loading it into a destination for analysis.

ETL stands for extract, transform, load. Data is extracted from source systems, transformed by cleaning and reshaping it, and loaded into a warehouse, model or report.

It is the backbone of almost every data workflow. Tools like Alteryx and languages like Python are common ways to build ETL that runs reliably and on a schedule.

Related terms

Learn this properly

A weekly note across Finance & Treasury, Innovation & Automation and Career Development. No spam, unsubscribe any time.