Building a dimensional data warehouse in Snowflake for SaaS product analytics. Implements star schema with subscription, usage, and revenue fact tables. Features SCD Type 2 for tracking customer and plan changes over time, incremental loading patterns, and full dbt project with tests and documentation. Covers key SaaS metrics: MRR, churn, LTV, feature adoption.
This project is currently being built. The TL;DR above provides the key summary. Full details, technical documentation, and code samples will be available once completed.