Analysis of UK Online Retail data using RFM Segmentation and Market Basket Analysis to improve retention.
Analyzed a dataset of 500,000+ transactions from a UK-based online retailer. The goal was to transform raw sales data into actionable business intelligence using RFM Analysis and Association Rule Mining.
- Data Cleaning: Handled missing values, removed duplicate entries, and filtered cancelled transactions.
- Feature Engineering: Created TotalSales and RFM metrics (Recency, Frequency, Monetary).
- Customer Segmentation: Segmented users into "Champions", "Loyal", and "At Risk" groups using Quantile Scoring.
- Market Basket Analysis: Used the Apriori Algorithm to find products frequently bought together.
The analysis revealed that the customer base follows the Pareto Principle (80/20 rule).
- Champions (11%): High spenders who buy recently.
- At Risk (44%): Large portion of customers who haven't purchased in >150 days.
- Action: Recommended a "Win-Back" email campaign targeting the "At Risk" group.
We identified strong product associations (Lift > 10) to drive cross-selling strategies.
- Key Discovery: Customers purchasing specific color variants (e.g., Green Alarm Clock) are highly likely to purchase the alternative color (Red Alarm Clock).
- Action: Implement "Bundle & Save" offers on product pages.
- Clone the repo:
git clone [https://github.com/Razorface1919/Retail-Analytics.git](https://github.com/Razorface1919/Retail-Analytics.git)