The task: a supermarket chain wants to know who its customers are, so it can target offers and loyalty programmes.
What I did: cleaned and analysed 10,281 customer records from three countries in Excel, then built an interactive dashboard with slicers.
What the data shows
- 72% of customers are in the USA (7,359), with 1,717 in Canada and the rest in Mexico, across 108 cities.
- Bronze is the dominant member card at 55%, followed by normal (24%), golden (12%) and silver (9%).
- Account openings are seasonal: February is the busiest month (962) and December the quietest (462).
- Gender and marital status are close to evenly split.
How
- Cleaning: blank checks, type fixes, and coded values replaced with readable labels (M to Married, S to Single)
- A hidden analysis sheet of pivot tables feeding the charts
- A dashboard with slicers for country, card type, income and education
- A written report covering method, challenges and recommendations, in the repo
Recommendations
- Move bronze members up a tier with targeted offers: they are over half the base.
- Time acquisition campaigns for the slower months, December in particular.