Customer Retention & Churn Analysis Dashboard

As a data analyst, I developed an insightful and interactive "Customer Retention & Churn Analysis" dashboard for the "telecommunications industry." WHAT WE GET TO KNOW FROM DASHBOARD: ➤ High Churn Risk Segment: 42% of customers are at "high risk" of churn, highlighting the need for targeted retention efforts like special offers or loyalty perks. ➤ Revenue at Risk by Service Type: "Fiber optic customers" represent the highest revenue at risk; improving service quality and support for these high-value customers could mitigate losses. ➤ Customer Lifetime Value (CLTV): Fiber optic customers also have the highest CLTV, suggesting a strong opportunity for loyalty programs to further increase their retention and value. ➤ Impact of Monthly Charges: Fiber optic customers face higher monthly charges; offering flexible pricing or bundling options may improve satisfaction and retention. ➤ Churn Drivers: Major churn reasons include" poor support quality" and "attractive competitor offers", indicating a need for better customer service training and competitive pricing strategies. ➤ Payment Method and Churn: "Electronic check" users have the highest churn rates, suggesting the need for customer education on alternative payment methods or incentives to switch.