ProjectData
RFM Analysis & dbt Analytics
Warehouse-native analytics
Customer segmentation and a modern analytics-engineering stack: RFM in SQL + Tableau, and dbt models on Snowflake.
Filed underAnalyst
§01Context
Two sides of analytics engineering: segmenting customers so someone can act, and building the warehouse models that make analysis repeatable instead of one-off.
§02What I did
- Ran an RFM (recency, frequency, monetary) segmentation on car-sales data in SQL and visualized the segments in Tableau.
- Built a dbt Core project on Snowflake with staging and mart models (the Jaffle Shop reference), structured for clean, testable transformations.
§03Outcome
- Actionable customer segments leadership can target directly.
- A warehouse-native modeling setup that scales past a single analysis.
From ad-hoc query to maintainable analytics.