
📊 Telecom Customer & Business Insights Dashboard
Type: Excel Project | Focus: Churn, Tenure & Revenue Analysis
Link: View Project on GitHub
🧩 Project Overview
This Excel-based dashboard delivers a clean, executive-level overview of telecom business metrics using simulated data. It helps visualize customer churn patterns, tenure distribution, and revenue breakdown in a concise, one-page format — ideal for management reporting and quick decision-making.
📌 Key Visuals & Insights
- Tenure Split: Customer distribution by maturity (e.g., 0-6 months, 7-12 months, etc.)
- Churn Breakdown: By Contract Type, Gender, and Internet Service
- Revenue Segmentation: Total revenue by service type and product categories
- Customer Profile Visuals: Gender split and internet service penetration
- Retention Analysis: Quick view of retained customers by key categories
🛠️ Tools & Techniques Used
- Microsoft Excel
- Pivot Tables for dynamic grouping
- Power Query to upload and clean the data