Mohamedkhnoor/Telecommunications-Customer-Analytics

The dashboard analyzes subscriber behavior for a major Telecommunications provider in Egypt, with a focus on enhancing digital engagement and reducing churn. # 📊 Telecommunications Customer Analytics & Churn Risk Dashboard – Power BI This project presents an end-to-end analytics solution for a **major telecommunications provider in Egypt**, focusing on subscriber behavior, digital engagement, and churn risk assessment. The dashboard leverages customer-level data to support business decisions in marketing, customer care, and network optimization. --- ### 🧩 Objectives - Calculate key commercial and engagement KPIs: - Average Revenue Per Subscriber (ARPU) - Quota utilization & monthly consumption analysis - App engagement & login frequency - Identify subscribers on high-speed plans with ** A simulated but realistic telecom dataset *(No real customer information is shared)* | Table | Description | Records | |-------|-------------|---------| | Customer | Subscriber profile & plan data | 9,995 | | Payments | Monthly billing & revenue contributions | 362,713 | | Consumption | Internet usage by day | 4,906,376 | | Mobile App | Digital interaction logs | 3,101,828 | | Calls | Customer support logs | 17,248 | | Network Elements | Technical coverage mapping | 9,918 | | + Lookup & configuration tables | Plans, ratings, loyalty rules | — | --- ### 📈 Dashboard Modules 1️⃣ **Utilization & Revenue** 2️⃣ **Churn Risk & Declining Engagement** 3️⃣ **Engagement, Geo-Insights & Profitability Drivers** > Screenshots are included below 👇 --- ### 🧠 Key Insights Delivered ✅ Low-utilization subscribers on premium plans → cost & network optimization opportunity ✅ Behavior-based segmentation supports targeted retention strategies ✅ High app usage + low payments segment → upsell potential ✅ Engagement decline detected **months before churn** → early action possible --- ### 🚀 Future Enhancements - Apply machine learning for churn prediction - Customer lifetime value scoring - Auto-alerts for customers hitting churn-risk thresholds --- ### 📫 Contact For collaboration or analytics opportunities: **Mohamed Khaled** 📍 UAE – Data Analyst / …