1

Bank Customer Churn Analysis r Page RMF) - ODL Problem Statement and Objective Overview of the Bank Retained Customers Custorner Churn Analysis Analysis - Overview Customer Churn Analysis - Germany Customer Churn Analysis - France Customer Churn Analysis - Spain Findings and Recommendations ASIA PACIFIC UNIVERSITY OF TECHNOLOGY INNOVATION Advanced Business Analytics and Visualization (102023- Assignment Component 1 Bank Customer Churn Analysis NAME: STUDENT NUMBER: INTAKE: LECTURER: HAND IN DATE: Mohammed Shahruk Hussain TP035285 Mr. Mafas Raheem 15-Dec-2023.

Cover Page Bank Customer Churn Analysis Overview of the Bank Retained Customers Customer Churn Customer Churn Customer Churn blern Statement d Objective Analysis Analysis - Overview Analysis - Germany Analysis - France Customer Churn Analysis - Spain Findings and Recommendations Problem Statement - Customer churn poses a significant challenge for financial institutions such as banks, requiring urgent attention and strategic solutions. -As customers disengage from financial services, institutions face the potential loss of revenue, trust, and market share as well as increased cost. - Identifying and understanding the root causes of customer churn and developing effective retention strategies are critical to maintaining a stable and prosperous customer base and profitability. Objectives - To conduct an in-depth examination of the current state of the bank, with a specific focus on critical factors, including demographic and financial data, influencing customer churn by utilizing appropriate visualizations for Exploratory Data Analysis (EDA)..

Bank Customer Churn Analysis Cover Page Total Customers 7,963 Problem Statement and Objective Average Age 37 Years Old Overview of the Bank Belarus etained Customers Analysis Customer Churn Analysis - Overview Customer Churn Analysis - Germany Customer Churn Analysis - France Customer Churn Analysis - Spain Findings and Recommendations Average Balance $72,745.30 Average Salary $99,738.39 Average Tenure 5 Years Avg Credit Score 652 points Total Customers per Country Of Man Age of Customers Gdansk Amste rd united Kingdom Plymouth Guern.y ermany 1.695 21.2 Poland Brest Germany has the least number of customers France 4,204 52.79% Palma Algiers _ Italy Slwakla - Austria Slovenia Serbia M ontenegrcy Oviedo Spain 2.064 25.92 Vatican City Naples Cagliari Palermo Lisbon Rabat € 2023 OpenStreetMap . Oran Tunis Tunisia Malta R«nania Bulgari* Stanbu Izmir Athens Heraklion 15 20 Customer Status 40 E 50 2K 1K 55 60 05 70 75 80 85 90 Gender The existing customer base is predominantly male Balance 39% of existing customers have zero balance Not Active 3,547 44.54% Active 4,416 55.46% Products Per Customer Three Products 0.58% One Product 46.15% Two Products 53.27% Majority of the existing customers have two products with the bank Churned and Retained Customers Churned 2,037 20.37% Retained 7,963 79.63% Female 3.404 42.75% Male 4.559 57.25%.

Bank Customer Churn Analysis Cover Page Total Customers 10.000 Problem Statement and Objective Average Age 39 years Old Overview of the Bank Retained Customers Analysis ustomer Chum nalysis - Overview Customer Churn Analysis - Germany Customer Churn Analysis - France Custorner Churn Analysis - Spain Findings and Recom m en dations Average Balance $76,485.89 Average Salary $100,090.24 Average Tenure 5 Years Avg Credit Score 651 points Total Customers per Country Products Per Customer Isle of Man -Ireland Kingdom plymouth Belarus Amsterd ermany 2,509 p!giu 25.0 France Austria 3ermany and France have I the same number of J 5.014 Gdansk ' Poland Hungary Serbia L iVi Rom an ia churned customers 50.14% •tzerlando• Skye nia Italy Vatican City Naples Cagliari Palermo Tunis Malta Tunisia Age of Customers 45 Year olds have a high churn rate when compared to other age groups Three Products 2.66% Two Products 45.90% Oviedo Spain 2479 24. Four Products 0.60% One Product 50.84% Most of the churned Lisbon Rabat 2023 Mapbox S' OpenStreetMap Oran Palma Algiers Male 5.457 54.57% Mootenegrg r Bulgaria stanbu Izmir Athens Heraklion Customer Status 40 so 3K 2K 0K ss 60 65 70 75 Balance Gender More females have left the bank than males Female 4.543 45.43% customers had only one product with the bank Churned and Retained Customers Churned 2.037 20.37% Not Active 4.849 48.49% Active 5.151 51.51% Inactive customers have a higher chum rate than active customers.

Bank Customer Churn Analysis Cover Page Total Customers 2.509 Problem Statement and Objective Average Age 40 Years Old Overview of the Bank Retained Customers Analysis Customer Churn Analysis - Overview ustomer Churn Analysis - Germany Customer Churn Analysis - France Customer Churn Analysis - Spain Findings and Recommendations Average Balance $119.730.12 Average Salary $101.113.44 Average Tenure 5 Years Avg Credit Score 651 Points Total Customers per Country Age of Customers 21.32% 452 18.02% 11.48% 6.54% 4.50% 2.11% 400 Products Per Customer Sle of Mm -Ireland United Kingdom Plymouth Guem "V Oviedo Lisbon Oran Gi. "tar Rabat ¯ 2023 Mapbox Z' OpenStreetMap Gender Female 1.193 47.55% Amsterd a erman 2.509 25.09 Gdansk Poland Brest Krako•Å Slovakia _ Hu ngary Belarus -u Ramania Bulgaria Stanbu Izmir Ath%ns Heraklion 18.41% Three Products 3.83% Two Products 41.45% Four Products 0.96% One Product 53.77% Palma Algiers Male 1.316 52.45% S I oven' a Italy Monte negre Vatican City Naples Cagliari Palermo Tunis Malta Tunisia 276 11.00% 82 3.27% 14 0.56% 31 1.24% 26 10 3 1.04% 0.40% 0.12% Customer Status Balance Churned and Retained Customers Churned 814 32.44% Not Active 1.261 50.26% Active 1.248 49.74% All customers who exited the bank have balance o.

Bank Customer Churn Analysis Cover Page Total Customers 10.000 0 000 Problem Statement and Objective Over-view of the Bank Retained Custorners Custorner Churn Analysis Analysis - Overview Customer Churn Analysis - Germany Customer Churn Analysis - France ustomer Chum nalysis - Spain Findings and Recommendations Average Age 39 years Old Total Customers per Country Average Balance $76,485.89 Average Salary $100.090.24 Average Tenure 5 Years Avg Credit Score 651 points Age of Customers Products Per Customer Ireland Kingdun o-elgiuh Algeria Poland S I cwakia Hur,qary .tzerlånd _ltaly Male 5.457 54.57% Belarus Ukraine Roma Turkey Three Products 2.66% Two Products 45.90% Four Products 0.60% One Product 50.84% pa 2.477 4. @ 2023 MaøbOÄ OpenStreetMap Syria IS 20 Customer Status 30 40 50 1200 1000 goo 400 200 0 ss 60 65 70 75 80 Balance 85 90 Gender Female 4.543 45.43% Churned and Retained Customers Churned 2.037 20.37%.