Ajibadeenoch's avatar
Ajibadeenoch
New Member
7 months ago

Bank Customer Churn Analysis

This comprehensive Bank Customer Churn Analytics dashboard was built to help a bank identify high-risk customer segments and improve long-term retention strategies. By combining a high-level executive overview with a granular churn deep-dive, the report transforms raw data into a strategic roadmap for reducing attrition.

Key Insights & Strategic Findings:

  • Overall Attrition: The bank currently maintains a 20.37% churn rate across its total base of 10,000 customers.

  • Demographic Vulnerability: Churn is heavily influenced by age, with the 41–60 age group showing the highest vulnerability. Specifically, the 51–60 bracket experiences a peak churn rate of 33.21%, suggesting a need for specialized retention offers for middle-aged segments.

  • Geographic & Market Trends: The analysis reveals distinct regional patterns; for instance, customers in the Germany segment show significantly higher churn sensitivity (33.98%) compared to other regions like Spain or France.

  • Product & Tenure Correlation: While Product Class 1 and 2 drive the highest volume, tenure analysis shows that churn risk is highest during the middle years of the customer lifecycle (years 4–6), before stabilizing in the long term.

  • Financial Profile: 70.55% of the customer base are credit card holders, providing a significant touchpoint for loyalty programs and targeted engagement.

Technical Features:

  • Interactive Drill-Downs: Built-in navigation toggles between the Executive Overview and Churn Analysis pages for seamless storytelling.

  • Trend Analysis: Integrated line-and-cluster charts to visualize the relationship between customer volume and churn probability.

  • UX-Focused Design: A clean, minimal UI ensures that stakeholders can identify critical KPIs within seconds of opening the report.

3 Replies

  • Well done! 👏

     

    If you are able to edit your post, you might want to fix the Customer Churn Rate by Credit Score chart. There is a value in the x-axis that does not belong: "70+. "