Explain why staging models should clean raw tables before marts join them.
A staging model is the adapter between messy source reality and stable analytics language. The mechanism Staging models should be thin, boring, and close to the source. They rename columns, cast data types, standardize booleans and timestamps, and preserve grain. They should not answer business questions yet. This separation works because marts can depend on a stable vocabulary instead of every downstream model rediscovering raw quirks. Common trap The tempting shortcut is to join raw orders, raw customers, and raw payments directly in the final revenue model. It feels faster until a raw field changes, a dashboard breaks, and no…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in