MohamadJavith's avatar
MohamadJavith
Kudo Collector
3 months ago

Telecom Churn Analysis

πŸš€ Telecom Customer Churn Analysis Dashboard | Power BI Project

I recently built a multi-page Power BI dashboard focused on analyzing customer churn in the telecom industry. The goal was to identify churn patterns, understand customer behavior, and provide actionable insights to improve retention.

πŸ” Project Overview
The dashboard is designed with a structured approach, allowing users to explore churn across different dimensions such as customer profile, service usage, and behavioral patterns.

πŸ“Š Dashboard Highlights

πŸ‘‰ Overview Page

  • 7,043 total customers with ~2,000 churned

  • Key metrics like average monthly charges and tenure

  • Insights into dominant contract types, internet services, and payment methods

πŸ‘‰ Churn Analysis

  • Higher churn observed in monthly contracts

  • Fiber optic users show higher churn compared to DSL

  • Electronic check users tend to churn more

πŸ‘‰ Churn by Services

  • Customers without online security and tech support show higher churn

  • Value-added services play a key role in retention

πŸ‘‰ Usage Analysis

  • Detailed customer-level data with filters for deeper exploration

  • Helps identify high-risk customer segments

βš™οΈ Technical Approach

  • Built using Power BI with a structured data model

  • Created DAX measures for KPIs like churn count, tenure, and average charges

  • Designed interactive visuals with multi-page navigation

πŸ’‘ Key Takeaway
Customer churn is strongly influenced by service quality, contract type, and additional service adoption. Providing better support services and flexible plans can significantly improve retention.

 

No RepliesBe the first to reply