The full Excel analysis is available here
Pig E. Bank is a worldwide financial services company seeking a Junior Data Analyst to assist them with the following task:
The goal of this project is to determine the main risk factors that contribute to customer loss and increase retention.
Pig E. Bank’s client dataset (available here). This data set contains data about Pig E. Bank’s clients, such as country, gender, age, balance, and estimated salary, among other things.
I started by running quality and accuracy checks to look for issues like missing values, duplicates, or inconsistent formatting. I found a few missing values and 11 two-year-old clients in the data set. I replaced both the wrong data and the blanks with "Unknown" to fix the error and improve readability.
The first factor I looked at was the clients' gender. As the graphic shows, the majority of consumers who left the bank are females (59%).
Another relevant factor was the clients' country of origin. The visualizations below reveal that although the majority of Pig E. Bank's clients are from France, German clients (29%) are the most likely to abandon the bank.
The age of the Pig E Bank customers was another factor I analyzed. I divided them into six age categories and found out that customers between the ages of 49 and 68 had the highest leaving rate.
Furthermore, over 70% of customers who left the bank were inactive users.
The last aspect I looked at was the number of products purchased. Clients of Pig. E. Bank typically use 1-2 items. Consumers who had 3–4 items, on the other hand, left the bank at the highest rate.
The findings suggest that a customer's probability of leaving the bank is mostly determined by their activity and the number of products purchased. The age group and gender are additional risk factors.
First and foremost, Pig E. Bank should experiment with marketing methods such as special offers and discounts to re-engage inactive bank clients, as 70% of those who left the bank were inactive users.
Second, the bank should investigate the reasons behind the high rate of leaving among those between the ages of 49 and 68.
I would also advise the bank to target female clients with advertisements in order to engage them more, since they represent 59% of clients leaving the bank.
