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.