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.