Ga naar de hoofdinhoud

Sort Transformations Into Staging, Intermediate, Mart, and Metric Layers

Classify analytics work into staging, intermediate, mart, or metric layers.

analytics-engineering5 min read

Sort each transformation into its best home in the dbt stack. Staging Intermediate Mart Metric definition Rename CustomerID to customer_id and cast it to string Join normalized orders with refunds to calculate reusable net-order components Publish one row per customer-month with finance-approved revenue columns Define weekly active workspaces with the official exclusion rules Translate vendor status text into a standardized enum without choosing business meaning Compute a reusable subscription lifecycle state used by several marts Expose a canonical sales-ops reporting table at opportunity grain Define gross-margin ratio so multiple tools query the same numerator and denominator rule

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Neem contact op