Dani-EL1/MTN-Customer-Churn-Report

Recreated churn analysis for MTN Nigeria (Q1 2025) # MTN-Customer-Churn-Report Recreated churn analysis for MTN Nigeria (Q1 2025) ## 🧭 Overview This project is a full **recreation** of an MTN Nigeria Customer Churn Analysis originally by Oluwademilade Adeniyi. Inspired by that work, I used Excel to build an interactive dashboard and conducted exploratory churn analysis using synthetic customer data based on real-world MTN Nigeria plans and devices. The final result includes a clean dashboard, key insights, a comprehensive report, and actionable recommendations. > 🔗 Original Project > 📁 My Portfolio Post for this Project --- ## 📂 Project Resources - 📦 **Raw Dataset (Unmodified)** Google Drive Link - 🧾 **Final Report (PDF)** Google Drive Link - 📸 **Screenshot of Dashboard** Google Drive Link --- ## 🔍 Project Highlights - Churn trends by device, gender, and age - Revenue analysis by plan - Churn reason segmentation - Geo-distribution using Excel’s map chart - Insights and recommendations for retention --- ## 🛠 Tools Used - Microsoft Excel - PivotTables & Slicers - Data Cleaning & Transformation - Dashboard Visualization --- ## 🙌 Credits & Acknowledgments - **Original Creator**: Oluwademilade Adeniyi - **Recreated By**: Ayomide Olalere - **Tools Used**: Microsoft Excel - **Data**: Synthetic dataset based on MTN eShop --- ## 📫 Contact Me Feel free to connect or message me on LinkedIn