Ga naar de hoofdinhoud

Sort: Transaction, Periodic Snapshot, or Accumulating Snapshot?

Match common analytics questions to transaction, periodic snapshot, or accumulating snapshot fact designs.

data-modeling5 min read

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

Read the full lesson

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

← Back to library

Neem contact op