How imbasito/rfm-customer-segmentation works
This repository documents a SQL-based customer analytics workflow for UK e-commerce transactions, ending in an interactive Power BI dashboard. The documented path runs from transaction data through cleaning and RFM feature engineering, scoring, and segmentation; separate SQL work covers exploration, KPIs, and business scenarios. The README describes the dashboard's customer overview, segmentation, and drillthrough views. No source excerpts were provided, so relationships below rely on the README's process description; script-to-stage assignments use the filenames.
Main entry points: Ecommerce_Transactions_UK_Dashboard.pbix Interactive Dashboard · edata_cleaned.csv Cleaned Data · Lab2_Data_Cleaning_Preparation.sql Data Cleaning · Lab5_Behavioral_Segmentation(RFM Analysis).sql RFM Metrics
Components 14
SQL Analysis
- Data Exploration
sql/Lab1_Exploration.sql - Data Cleaning
sql/Lab2_Data_Cleaning_Preparation.sql - Cleaned Data
edata_cleaned.csv - Business KPIs
sql/Lab3_SQL Business KPIs.sql - Business Scenarios
sql/Lab4_Business_case_scenarios.sql
RFM Segmentation
- RFM Metrics
sql/Lab5_Behavioral_Segmentation(RFM Analysis).sql - RFM Scoring
sql/Lab5_Behavioral_Segmentation(RFM Analysis).sql - Customer Segments
sql/Lab5_Behavioral_Segmentation(RFM Analysis).sql
Power BI Reporting
- Interactive Dashboard
Dashboards/Ecommerce_Transactions_UK_Dashboard.pbix - Customer Overview
Dashboards/Ecommerce_Transactions_UK_Dashboard.pbix - RFM Dashboard
Dashboards/Ecommerce_Transactions_UK_Dashboard.pbix - Customer Drillthrough
Dashboards/Ecommerce_Transactions_UK_Dashboard.pbix
Other components
- Analyst
- Transaction Data
sample data/sample-data.csv
Connections 13
- Analyst → Transaction Data: imports
README.md - Transaction Data → Data Cleaning: cleans
README.md - Data Cleaning → Cleaned Data: produces
README.md - Cleaned Data → RFM Metrics: engineers features
README.md - RFM Metrics → RFM Scoring: scores metrics
README.md - RFM Scoring → Customer Segments: assigns segments
README.md - Cleaned Data → Interactive Dashboard: imports output
README.md - Interactive Dashboard → Customer Overview: shows
README.md - Interactive Dashboard → RFM Dashboard: shows
README.md - Interactive Dashboard → Customer Drillthrough: supports
README.md - Analyst → Data Exploration: explores data
- Analyst → Business KPIs: calculates KPIs
- Analyst → Business Scenarios: evaluates cases