Dataset
Online Retail II
Yiwei Bao
Analytics Case Study
A complete online retail case study spanning retention analysis, RFM segmentation, and churn prediction from data cleaning through business recommendations.
Dataset
Online Retail II
Output
Retention + Churn
Narrative
Hiring-ready
Problem Statement
E-commerce teams need a clearer way to identify high-value customers, churn-risk groups, and the retention actions worth prioritizing.
Key Finding
Purchase frequency and recency sharply separate high-value customers from high-risk churn segments, which makes retention prioritization more actionable.
This project grows out of an existing online retail analysis script. The core questions are which customers are most valuable, which are most likely to churn, and which actions deserve business focus first.
Instead of showing only a notebook, the portfolio version turns the problem definition, analysis chain, and business actions into a coherent story.
The workflow covers cleaning, cohort retention analysis, RFM segmentation, churn labeling, and a logistic-regression baseline.
This structure demonstrates both core analytical thinking and the ability to move from descriptive analysis into simple modeling.
Hiring teams are rarely only looking for code. They want to see whether you can break down a business problem, make judgments, and recommend actions.
That is the purpose of this case-study page: to make the project read more like decision support than a classroom exercise.