Sort: Transaction, Periodic Snapshot, or Accumulating Snapshot?

Place each scenario into the fact table type that best fits the business question. Transaction Fact Periodic Snapshot Accumulating Snapshot Every completed checkout line item Each refund event when it is processed End-of-month active subscription balances Daily inventory on hand by warehouse An order moving through pick, pack, ship, deliver A sales lead moving from created to qualified to won

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

Already have an account? Sign in