Measuring the Subscription Economy
summary
Explains a Kimball-style dimensional model that turns Chargeify/Recurly-style source rows into a factless fact table for monthly churn and a separate recurring‑revenue fact that spreads payments into intervals, with stored procedures and SSIS packages to load an Adventureify demo warehouse and Tableau views. Shows handling of free trials, grace periods, backdated effective dates with periodic snapshot grain, rounding‑error distribution per Brad Schultz, and a performance change from hour‑long cursors to minutes using cross apply vs cross join.
AI-written summary · about
chapters (11)
- 0:00Subscription economy intro
- 1:06Data warehouse for subscriptions
- 3:57Subscription model evolution
- 8:29Key subscription metrics
- 12:03Team and terminology
- 20:00Churn modeling in subscriptions
- 36:19Recurring revenue calculation
- 46:20ETL for subscription data
- 57:04Churn reduction strategies
- 58:28Tableau for subscription metrics
- 1:00:57Key takeaways
related talks
40mSaaS Metrics 101
01h 00mHow to win at monetizing games as a service
13mData for product
17mBuilding a culture of curiosity at your company
28mBeyond the Balance Sheet: Transactional Data as a Window to Company Health
24mEvent Analytics - from unstructured to insightful
40mBilling the cloud: Real world stream processing
27mActivity schema data modeling using a single table