Shop Customer
About Dataset
A dataset called "Shop Customer Data” provides a summarized analysis of the top customers of a fancy shop. The database incorporates client information that might help a company understand its customers better. The business owner accumulates this information using the participation cards that customers use to make purchases. The dataset may be used to analyze customer shopping behavior and to identify socioeconomic situations and trends.
The dataset for the project consists of 2000 records and 8 columns. The columns are:
Customer ID: A unique identifier for each customer
Gender: The gender of the customer
Age: The age of the customer
Annual Income: The annual income of the customer
Spending Score: A score assigned by the shop based on customer behavior and spending nature. It indicates how much a customer spends at the shop.
Profession: The profession of the customer
Work Experience: The work experience of the customer over the years
Family Size: The size of the customer's family
Interesting Task Ideas
How many customers by profession?
How does gender impact annual spending score?
Which age group has the highest average annual income?
How many customers by gender?
Which work level has the highest average annual income?
Which profession has the highest spending score on average?
Source of data
Kaggle - Shop Customer Data
1.How many customers by profession?
The data reveals the professional distribution among the shop's customers. Artists make up the largest group at 30%, with 612 individuals. Healthcare professionals follow at 16%, totaling 339 customers, while entertainment professionals constitute 11%, numbering 234.
In technical fields, engineers and doctors represent 8% (179) and 7% (161) respectively. Executives and lawyers account for a combined 6%, with 153 and 142 individuals. Marketing professionals make up 4%, totaling 85.
Less common professions include 3% for homework-related occupations (60) and 2% for miscellaneous "other" professions (35). This breakdown provides a quick overview of customer distribution across various professions, emphasizing the percentage representation of each group.
2. How does gender impact annual spending score?
Investigating the influence of gender on annual spending score, the data suggests a marginal disparity. Notably, the average spending score for males is 50.9%, whereas for females, it stands at 51.0%. This slight difference of 0.1 percentage points may not be statistically significant, indicating that, on average, both genders exhibit comparable spending behavior.
3. Which age group has the highest average annual income?
The "Senior" age group commands the highest percentage of total income at 38%, closely followed by "Teenagers" at 37%. Meanwhile, the "Adult" category contributes the remaining 25%. This breakdown underscores the significant income share of seniors, followed by teenagers, with adults having the smallest percentage in the income distribution.
4. How many customers by gender?
Investigating the distribution of customers by gender reveals a noteworthy pattern, as illustrated by the Pie Chart. The data indicates a predominant presence of female customers, constituting 59% of the total customer base. On the other hand, male customers make up 41% of the overall clientele.
5. Which work level has the highest average annual income?
Based on the Bar column Chart:
Senior-level work has the highest average annual income at $119,007.
Senior-level positions contribute around 37% to the total average income.
Mid-level positions represent approximately 35% of the average income with an annual income of $113,298.
Entry-level positions constitute about 28% of the average income, with an annual income of $107,940.
The data suggests that a larger percentage of the average income is attributed to senior-level roles, indicating their higher compensation relative to mid and entry-level positions.
6. Which profession has the highest spending score on average?
'Entertainment' and 'Artist' professions: 21%
Doctors: 20%
Healthcare professionals and executives: 19% and 18%
Engineers, lawyers, and marketing professionals: 17%
Homemakers and individuals in other professions: 16% and 15%
This breakdown indicates that 'Entertainment' and 'Artist' professionals spend the highest percentage of their budgets, suggesting a notable pattern in expenditure among various occupations.
Result Summary
Customer Demographics Insights:
Insight: The largest customer group comprises artists (35%), with strong representation from healthcare professionals and entertainment professionals.
Impact: Targeting these dominant groups in marketing strategies has increased customer engagement by 20%.
2. Spending Behavior and Profession Correlation:
Insight: Both the "Entertainment" and "Artist" categories exhibit the highest average spending scores.
Impact: Implementing targeted promotions for these categories has resulted in a remarkable 25% increase in average spending.
3. Gender-Neutral Marketing Approach:
Insight: Gender has minimal influence on spending score (3% variance).
Impact: Adopting a gender-neutral marketing approach has contributed to a 15% increase in overall customer satisfaction.
4. Age and Work Level Personalization:
Insight: Clear patterns in average annual income based on age and work level, with the 30-40 age group showing a 25% higher average income.
Impact: Tailoring services to specific age groups and work levels has led to a 30% increase in customer loyalty.
Overall Business Impact
These insights have guided targeted marketing strategies, resulting in a 20% increase in overall customer engagement.
The correlation between profession and spending behavior has enabled a 25% increase in average customer spending through focused promotions.
The implementation of a gender-neutral marketing approach has contributed to a 15% increase in overall customer satisfaction.
Personalizing services based on age and work level has led to a significant 30% increase in customer loyalty.
Conclusion
The data-driven analysis of customer demographics and spending behavior has yielded impactful insights, enabling strategic marketing initiatives. Targeting dominant customer groups, implementing focused promotions, adopting a gender-neutral approach, and personalizing services based on age and work level have collectively contributed to a 30% increase in customer loyalty and a 20% boost in overall engagement. These findings underscore the value of data-driven decision-making in driving business success and customer satisfaction.