← Projects
Analysis · Example
Customer churn analysis
Exploratory study of the factors that lead customers to cancel, with segmentation and recommendations.
- Python
- Pandas
- SQL
The problem
A subscription company wanted to understand why its cancellation rate went up in the last six months.
What I did
- Extracted customer history and product usage with SQL.
- Ran the exploratory analysis in Python (Pandas and Matplotlib) in a documented notebook.
- Segmented customers by tenure and usage frequency and compared churn rates.
Result
Customers with no usage in their first 15 days canceled 3 times more often. The recommendation was to create an onboarding journey.
Illustrative example. Replace it with the data and conclusions from your own project.