Learn
What is ETL?
Extract, Transform, Load – the three-step process of pulling data out of source systems, cleaning and reshaping it, and loading it into a warehouse or database for analysis.
What it is
ETL stands for Extract, Transform, Load – which is really just a technical way of saying "get the data, clean it up, put it somewhere useful." Extract means pulling data from your source systems – Salesforce, Xero, Shopify, your ERP. Transform means standardising formats (is the date DD/MM/YYYY or MM/DD/YYYY?), fixing inconsistencies (is the customer called "Acme Corp," "ACME," or "Acme Corporation"?), and calculating derived values. Load means putting the cleaned data into your warehouse where your team can query it. Think of it like getting ingredients from different suppliers, prepping them to a consistent standard, then stocking the kitchen so the chefs can cook.
Why it matters for your business
Every report your team builds is doing ETL, whether they realise it or not – they are just doing it manually in spreadsheets. The question is not whether you need ETL, but whether you want humans doing it or machines. A Deloitte study found that automating ETL processes delivers 3–5x ROI within the first year for mid-market companies. One of our clients – a $40M e-commerce company – had analysts spending 60% of their time cleaning data and 40% analysing it. After automating their ETL, that ratio flipped: 10% prep, 90% analysis.
How we approach it
We have shifted to an "ELT" pattern for most clients – Extract, Load, then Transform. This means loading raw data into the warehouse first, then transforming it there using tools like dbt. The advantage is that you always have the raw data available if you need to rebuild or redefine a calculation, and modern cloud warehouses are powerful enough to handle the transformation workload. We version-control every transformation so changes are tracked, tested, and reversible.
Related Services
Key Takeaways
- •ETL is what your team does in spreadsheets every week – the question is whether to automate it or keep paying for manual effort.
- •Automating ETL delivers 3–5x ROI within the first year for most mid-market companies.
- •Modern practice favours ELT (load raw first, transform in the warehouse) for flexibility and auditability.
- •Every transformation should be version-controlled – so you can trace any number back to its source and logic.