ContactBook a call

Data

ETL and ELT

ETL (extract, transform, load) and ELT (extract, load, transform) are the two common patterns for copying data from business systems into a database or data warehouse for reporting.

How it works in practice

Both start by extracting data from sources such as the CRM, accounting system and ecommerce platform. In ETL the data is cleaned and reshaped before it is loaded. In ELT the raw data is loaded first and transformed inside the warehouse, often with a tool such as dbt. Cheap warehouse storage and compute have made ELT the default for most new builds, because the raw data stays available if a report needs changing.

Tools such as Fivetran and Airbyte handle the extract and load steps for common systems. The transform step is where business definitions live, such as what counts as revenue or an active customer, and it needs owning like any other piece of code.

A worked example

A 70-person retailer loads Shopify, Xero and Google Ads data into BigQuery each night. SQL models join them into one table of margin by product and channel, which feeds the Monday trading dashboard.

Examples in this glossary describe typical builds for companies of 1 to 1,000 people. They are not named client results.

See which of these apply to your team

On a discovery call we map the manual work in your team and show you which of these would change it first.

Book a discovery call

Cookie preferences

Choose what this site may use on your device. You can change this at any time from “Cookie settings” in the footer.

Strictly necessary

Keep the site working and remember the choices you make here. These cannot be switched off, and none of them track you.

Always on
What this includes (4)
NameProvider PurposeDuration
sbd-consentThis site Remembers your cookie choices12 months
Vercel Web AnalyticsVercel Inc. Counts page views in aggregate. Sets no cookie and stores nothing on your deviceNone
ticker-dismissed, sbd-note-offThis site Remembers that you closed a notice or language tipUntil the tab closes
sbd-voice-resume, sbd-voice-prefillThis site Carries a voice conversation across pages, only if you start oneUntil the tab closes

Analytics

Tell us which pages are read and where visitors leave, so we can improve them. IP addresses are anonymised and nothing is used for advertising.

What this includes (2)
NameProvider PurposeDuration
_gaGoogle Analytics (Google LLC) Distinguishes visitors with a random ID13 months
_ga_FPXDMQPRV1Google Analytics (Google LLC) Keeps the session state for this site13 months

Functional

Embedded services that set their own cookies. Without them the site still works; you get a link to open the service instead.

What this includes (1)
NameProvider PurposeDuration
Booking calendarCal.com Inc. Shows live availability and books the call on the booking pageSet by Cal.com

Advertising

Not used. This site has no advertising, retargeting or social media tracking, and we never sell data.

Not used

Questions about your data: hello@smallbaydigital.com