Skip to content
~/hth
Back to projects
Done

Customer Segmentation (Customer360)

Built a Customer360 dataset from 700K+ transactions, segmented customers with RFM, IQR and the BCG matrix, and made Power BI dashboards on top.

Problem

Transaction data tells you what was bought, not who your customers are. I wanted one view per customer and a useful way to group them.

What I did

  • Processed 700K+ transaction records from OLTP tables with SQL (joins, subqueries, window functions) and aggregated them into OLAP datasets for Customer360 analysis and Power BI.
  • Segmented customers with RFM (recency, frequency, monetary), the IQR method and the BCG matrix.
  • Built interactive Power BI dashboards with DAX.

Result

A Customer360 dataset and dashboards showing how customers in each segment behave.