Skip to content

vanshdhiman090/Excel_bank_churn_analysis

Repository files navigation

Bank_churn_analysis (Interactive Dashbord Using Ms Excel)

Bank Customer Churn Analysis 📌 Project Overview

This project analyzes a dataset of 10,000 bank customers to understand the drivers of customer churn. Customer churn (when clients leave the bank) is a critical business challenge because it directly impacts revenue and profitability. The goal of this project is to uncover patterns, identify high-risk segments, and recommend strategies to improve retention.

Dataset

Total Customers: 10,000
Total Churned Customers: 2,037 (≈20.37%)

Features:

Demographics: age, gender, country
Financials: credit_score, balance, estimated_salary
Customer Relationship: tenure, products_number, active_member, credit_card
Target Variable: churn (1 = churned, 0 = retained)

Dashboard Preview

The project includes a dashboard visualization highlighting:
Churn by country, age group, gender, tenure, and active membership
Overall churn rate and balance at risk

Dataset Used

Dashboard

Insights and Final Conclusion

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors