All case studies
Case Study
Customer Purchase Behaviour
A case study that turned raw FMCG transaction data into a clear picture of who drives revenue, which products sustain growth, and where to act next.
The problem
Sales were coming in. The reasons weren't visible.
A mid-sized FMCG retailer could not see which customer segments were driving sales, or how product performance varied across categories.
Without visibility into spending patterns and segment contribution, pricing, inventory and marketing decisions were being made on instinct.
The objectives
Four clear business goals.
Every chart on the dashboard exists to answer one of these.
Analyze product-level sales and quantity trends
Track sales performance over time to forecast demand
Support data-driven marketing and inventory decisions
The approach
Questions first. Visuals second.
We began with what leadership needed answered: which customers drive revenue, and which products sustain growth. Each visual was then chosen to make its pattern obvious at a glance.
Cards for KPIs
The headline numbers, readable in seconds.
Line chart for growth
Monthly sales over time, to expose seasonality and forecast demand.
Bar charts for products
Direct comparison of top sellers by sales and quantity.
Segment correlation
Segment spend read against sales trends to surface actions that turn into revenue.
The dashboard
Built in Power BI. Read in seconds.
It opens with the numbers leadership checks first, then lets them go deeper.
- $1.93MTotal sales
- 265KCustomers
- +12%Growth rate
- 39%Conversion rate
Revenue by customer segment
Share of the $1.93M total.
- Mainstream 39%
- Budget 35%
- Premium 26%
Monthly sales trend
Sales rise steadily from January to December, pointing to consistent seasonal growth.
Product performance
Doritos Corn Chips, Smiths Crinkle Chips and Kettle Mozzarella Chips lead on sales.
Quantity trend
Product quantities climb quarter on quarter, peaking around early 2019.
Key findings
What the data actually said.
- Mainstream customers generate the highest revenue at $751K, showing strong mid-tier loyalty.
- Budget customers contribute $676K, a stable segment that responds to volume-led offers.
- Premium customers contribute $507K, the smallest share, which makes repeat frequency the clearest growth lever.
- Steady monthly growth suggests effective customer retention and seasonal campaigns.
- Doritos and Kettle dominate both sales and quantity, making them strategic inventory priorities.
- Gradual growth across months and years signals consistent market penetration and brand loyalty.
The proof
Decisions got measurably better.
Leadership gained a clear view of profitability across customer tiers, which fed directly into smarter pricing and promotion.
- -18%Overstock, by stocking against high-selling SKUs
- +10%Premium engagement from segment-focused promotions
- +15%Sales forecasting accuracy from data-informed planning
- +12%Growth rate across the period
What we recommended next
Five moves to keep it compounding.
- 01Deepen segmentation by integrating demographic or loyalty data.
- 02Bundle offers for Mainstream and Budget buyers to raise purchase frequency.
- 03Introduce loyalty rewards for Premium customers to increase repeat sales.
- 04Extend the dashboard to track campaign ROI and channel-level metrics.
- 05Automate alerts for declining product performance, so marketing and inventory can react faster.
The outcome
Raw transactional data became a clear, actionable business narrative. The team now makes pricing, inventory and marketing decisions with confidence, backed by 12% growth and 18% less overstock.
Tell us what your data isn't telling you.
Write a few lines: what you sell, who you sell to, and where you feel you are losing ground. We will reply with what we would look at first.
Tell Us About Your Business bloomotive@tbmbrand.com