XLHNT/MTN-Nigeria-Customer-Churn-Analysis

End-to-end SQL analytics project analyzing customer records to identify churn drivers and retention opportunities. Comprehensive 8-dimensional analysis with actionable insights and executive dashboard. # MTN Nigeria Customer Churn Analysis ### Reducing Customer Attrition Through Data-Driven Intelligence --- ## Quick Links | Resource | Description | |----------|-------------| | **Download Power BI Dashboard** | Interactive dashboard with full analysis | | **View Live Dashboard Online** | Online dashboard with full analysis - no download required | | View Dashboard Screenshots | Preview dashboard without download | | SQL Queries | All analysis queries | | Full Analysis Report | Comprehensive findings | | Data Dictionary | Dataset documentation | --- ## Project Overview **Business Challenge:** MTN Nigeria, one of Africa's leading telecommunications providers, experienced increasing customer churn threatening revenue stability in Nigeria's highly competitive telecom market with 4 major operators. **My Role:** Data Analyst | **Duration:** 2 weeks **Tools:** Microsoft SQL Server, Power BI ### Project Impact - **Identified high-risk segments** representing 45% of total churn - **Quantified revenue at risk** through comprehensive churn analysis - **Developed 8-dimensional analytical framework** for ongoing monitoring - **Delivered 12 actionable recommendations** for retention improvement - **Created executive dashboard** for real-time churn intelligence ### **→ VIEW INTERACTIVE POWER BI DASHBOARD** Download Dashboard (.pbix) View Screenshots --- ## Table of Contents - Business Problem - Dataset Overview - Analysis Framework - Key Findings - Strategic Recommendations - Technical Highlights - Repository Structure - How to Use - Skills Demonstrated - Connect With Me --- ## Business Problem ### The Challenge MTN Nigeria needed to understand: 1. **Which customer segments are most likely to churn?** - Geographic patterns across 36 states - Demographic profiles (age, gender) - Subscription and device preferences 2. **What are the primary drivers of customer attrition?** - Service quality issues - Competitive pressures - Price sensitiv …