Model a multi-step fulfillment process as an accumulating snapshot fact.
Fulfillment leaders need to see where orders are stalled across pick, pack, ship, and deliver, and how long each stage takes. For a stable process pipeline, use one row per workflow instance and update milestone dates as the instance advances. A common trap is treating an accumulating snapshot like a transaction stream and adding one row per stage event. That loses the single-row lifecycle view the pattern is meant to provide. Choose the workflow grain One row per order fulfillment instance. The row represents the lifecycle of one order moving through known stages, not one individual stage event. Pick milestone…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in