Logo Lanfrica

The-DataGirl/MTN-Churn-Analysis

Domaine:

socioeconomic

Type de record:

project
Créateur:
The
Hôte:
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