Data flow - Process
ELT
(Extract, Load, Transform)
Moving data to its destination first, then reshaping it there for analysis
What's it for?
Loads data quickly into its destination and reshapes it there when that is more efficient.
For example…
Nightly job copies CRM records into the warehouse, then cleans and joins them there for morning dashboards.
A team loads raw CRM data into its cloud warehouse first, then uses SQL there to clean and reshape it — an ELT approach
Think of it like…
Moving boxes into the garage first, then sorting them once they are on site