RevOps & Sales Analytics Path · Mission 17 of 34Hard

Point-in-time forecast snapshot (SCD2)

SCD2 point-in-time reconstruction from a history table — reproducing a forecast as it existed on a given date

Unlock with Pro→Back to RevOps & Sales Analytics

The Brief

You'll practice

History tableDate filterCTE
← Previous
Mission 16
Next →
Mission 18
All 34 missions in RevOps & Sales Analytics Path ↓
  1. 1. Meet the opportunities table
  2. 2. What stages exist in the pipeline?
  3. 3. Open opportunities by owner
  4. 4. Drop the Closed-Lost deals
  5. 5. Deals over $50K by account
  6. 6. Pipeline value by stage
  7. 7. Deals by close quarter
  8. 8. Win rate by sales rep
  9. 9. Average deal size by region
  10. 10. Leads with no account match
  11. 11. Deals that reopened after Closed-Won
  12. 12. Stage regressions — deals that moved backward
  13. 13. Mid-cycle owner reassignments
  14. 14. Top 3 reps per region by closed-won revenue
  15. 15. Pipeline velocity — avg days per stage
  16. 16. Most recent opportunity per account
  17. 17. Point-in-time forecast snapshot (SCD2)
  18. 18. Closed-Won cohort retention by month
  19. 19. Quarterly bookings waterfall — new vs expand
  20. 20. Amount discount — committed vs closed
  21. 21. Pipeline hygiene — issue count per opportunity
  22. 22. ARR bridge — starting + new + expand per quarter
  23. 23. Sales cycle segmentation by deal-size bucket
  24. 24. Rep performance dashboard
  25. 25. Board-ready sales operations summary
  26. 26. Discount slippage by close-quarter
  27. 27. Stage conversion funnel with drop-off
  28. 28. Regional pipeline scorecard
  29. 29. Account expansion analysis — multi-opp customers
  30. 30. RevOps board capstone — quarter close panel
  31. 31. Quota attainment by rep (2025-Q1)
  32. 32. Forecast category pivot — per rep
  33. 33. Comp accelerator math (2025-Q1)
  34. 34. Clawback exposure on reopened deals