1 of 13

What Drives Sales

(Supermarket Edition)

By Trevin Vaughn

2 of 13

Objectives: Identify KPI’s in order to drive sales forward

Existing KPI’s:

Store size
Items available
Daily customer count

3 of 13

Top Sales Trends!

Green represents above average
Red represents below average
Notice any trends?

4 of 13

The Trendline shows us bigger stores means bigger profits (Roughly $10,000 more a month)

5 of 13

This Trendline shows us more items available means bigger profits (Roughly $12,000 more a month)

6 of 13

This Trendline shows us that more daily customers means lower profits (Roughly $2,000 less a month)

7 of 13

This Trendline shows us that the more items more items available means less daily customers

8 of 13

This Trendline shows us that the more items more items available means less daily customers

9 of 13

Okay, so what next?

I’m glad you asked.

The data tells us to focus on 2 of the 3 KPI’s

Item’s available ($12,000 value)
Store size ($10,000 value)

10 of 13

Thank you for your time!

Thank you for trusting us to grow your company. I would love to continue testing different metrics to uncover valuable insights for your business’s success.

11 of 13

Questions, Comments, Concerns?

12 of 13

*Project Notes

This is the original sample dataset from Kaggle.com

https://www.kaggle.com/datasets/surajjha101/stores-area-and-sales-data

13 of 13

*Project Notes Continued

I imagined a scenario where our stakeholders, Matt and Ryan, are concerned with the best way to invest in their grocery store business. They’re well established owning over 400 supermarket stores country wide and are interested in what would be their next best financial move.