Walk from a raw order source to a stable sales star schema by making the key design decisions in sequence.
The pressure An ecommerce analytics rebuild is due Friday. The raw order extract already contains order headers, line items, coupons, shipment status, and refund flags. Everyone wants one master table. If you flatten first, you will mix order-level and line-level meaning before anyone notices. The framework Process → grain → facts → dimensions Kimball dimensional modeling works because each decision narrows what the row is allowed to mean. Flat source dump Feels fast, but hides mixed grains and mixed processes. A star schema that answers one family of questions consistently. Start with the business event, not the available columns. Pick…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in