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.
Already have an account? Sign in