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

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

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

Already have an account? Sign in