End-to-end Power BI churn analysis project for MTN Nigeria, featuring churn rate KPIs, churn trends, customer segmentation, and retention insights
📊 MTN Churn Analysis – Power BI Dashboard
This project analyzes customer churn for MTN Nigeria, using Power BI to uncover drivers of churn, customer behavior patterns, and insights that support customer retention strategies.
🔍 Objectives
Identify customer churn rate
Analyze churn by:
Age group
Revenue
Tenure
Location
Customer type
Highlight top drivers of churn
Provide insights for reducing churn and improving retention
🛠 Tools Used
Power BI
Power Query (Data Cleaning)
DAX (Measures & Calculations)
Interactive Dashboard Visualizations
📂 Key DAX Measures
Churn Rate
Total Active Customers
Total Churned Customers
Revenue by Customer Segment
Customer Tenure Grouping
📈 Dashboard Overview
The dashboard contains:
Overall Churn Rate KPI
Churn Trend Over Time
Churn by Customer Segment
Revenue Loss from Churn
Top Reasons for Churn
Customer Tenure Distribution
Churn vs. Revenue Scatter Plot
🔑 Insights
Customers with low tenure are more likely to churn
Churn is highest in segments with low data usage and low revenue
Certain regions experience higher churn rates
Identified opportunities for targeted retention campaign