Skip to content

This report presents a segmentation analysis conducted on a UK bank's customer dataset using hierarchical and two-step clustering techniques. The objective was to identify homogeneous customer groups to support the development of targeted financial products and services.

Notifications You must be signed in to change notification settings

SuryaPrakashJ123/Cluster_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

4 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

๐Ÿง  Customer Segmentation Using Cluster Analysis (SPSS)

This project demonstrates unsupervised clustering techniques applied to a UK bank's customer dataset. The primary aim is to segment customers into distinct groups based on demographic and financial behavior, enabling data-driven marketing and service personalization.


๐Ÿ“Š Project Summary

We applied Hierarchical Clustering and Two-Step Clustering using SPSS to identify natural customer segments. Key objectives:

  • Discover distinct customer profiles.
  • Understand variable contributions to cluster formation.
  • Use clustering results to recommend marketing strategies.

๐Ÿ“ Dataset Description

Source: Simulated UK bank customer dataset (425 records)

Variables Used for Clustering (standardized via Z-scores):

  • Age
  • Current Account Balance
  • Savings Account Balance
  • Months as Customer
  • Months Employed

๐Ÿงฎ Clustering Techniques

1. Hierarchical Clustering

  • Method: Wardโ€™s Method
  • Distance Metric: Squared Euclidean
  • Output: Dendrogram

๐Ÿ“Œ Result:

  • 4 clusters identified
  • Visual splits observed in dendrogram at sharp linkage jumps

Dendrogram

๐Ÿ”ข Proximity Matrix (Top View)
(Excerpt from squared Euclidean distance between select cases)

Proximity Matrix


2. Two-Step Clustering

๐Ÿ“ˆ Cluster Quality:

  • Silhouette Score: ~0.4 (Fair)

Cluster Quality

๐Ÿ“Š Model Summary:

Model Summary


๐Ÿง  Cluster Insights

๐Ÿ” Cluster Profiles:

Cluster Description
1 Younger customers, low balances, short job tenure
2 Mature, high-income customers with long tenure
3 Mid-aged customers with moderate finances
4 High current balance, but low savings and tenure

๐Ÿ“‹ Case Processing Summary
All 425 records included and processed:

Case Summary


๐Ÿงฉ Strategic Recommendations

  • Cluster 2: Target with premium and wealth management services
  • Cluster 1: Offer beginner-friendly digital banking tools
  • Cluster 3: Promote long-term savings and credit plans
  • Cluster 4: Improve retention through loyalty and engagement offers

๐Ÿ“‚ Files

  • data.xlsx โ€“ Raw customer data
  • cluster.docx โ€“ Detailed report
  • images/ โ€“ SPSS chart exports

๐Ÿ’ก Conclusion

This analysis highlights the value of unsupervised machine learning in marketing strategy. By combining Hierarchical Clustering for visual insights and Two-Step Clustering for profiling strength, we provide actionable segmentation that supports tailored customer engagement.


๐Ÿš€ Built with SPSS, Excel, and GitHub to showcase real-world data segmentation in financial services.

About

This report presents a segmentation analysis conducted on a UK bank's customer dataset using hierarchical and two-step clustering techniques. The objective was to identify homogeneous customer groups to support the development of targeted financial products and services.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published