This is an end-to-end Excel Data Analytics project focused on analyzing customer churn in an e-commerce business.
The goal of this project is to understand customer behavior, identify key drivers of churn, and provide actionable insights to improve customer retention.
The project includes the following steps:
Data Cleaning and preprocessing
Data Quality Assessment (Data Audit)
Exploratory Data Analysis using Pivot Tables
Interactive Dashboard creation in Excel
Business insights and actionable recommendations
Key Outcomes:
- Identified main factors affecting customer churn
- Analyzed customer behavior patterns
- Segmented high-risk churn customers
- Provided data-driven recommendations to improve retention
This project demonstrates real-world business analysis using Excel and is suitable for e-commerce companies looking to reduce customer churn and increase customer lifetime value.