My attempts made for the Quantium Data Analytics Virtual Experience Program on Forage.
Quantium has had a data partnership with a large supermarket brand for the last few years who provide transactional and customer data. Supermarket will regularly change their store layouts, product selections, prices and promotions. This is to satisfy their customer’s changing needs and preferences, keep up with the increasing competition in the market or to capitalise on new opportunities. The Quantium analytics team are engaged in these processes to evaluate and analyse the performance of change and recommend whether it has been successful.
- Look for inconsistencies, missing data across the data set, outliers, correctly identified category items, numeric data across all tables.
- Explore the data, create charts and graphs as well as noting any interesting trends and/or insights found.
- Define the recommendation from the insights, determine which segments we should be targeting.
- Match trial stores (str num# 77, 86 & 88) to control stores that are similar to the trial store prior to the trial period of Feb 2019 in terms of monthly overall sales revenue, monthly number of customers, and monthly number of transactions per customer.
- Most of the brands from the datasets are from The Smith's Snackfood Company Pty Ltd.
- We could notice that the chips with sour cream or sea salt, as well as the corn chip are quite popular among the customers.
- Mainstream midage and young singles and couples are more willing to pay more per packet of chips compared to their budget and premium counterparts.
- Sales are coming mainly from Budget - older families, Mainstream - young singles/couples, and Mainstream – retirees.
- There are more Mainstream - young singles/couples and Mainstream - retirees who buy chips. This contributes to there being more sales to these customer segments but this is not a major driver for the Budget - Older families segment. Higher sales may also be driven by more units of chips being bought per customer.
- The trial stores 77 and 88 during the trial period (February 2019 - April 2019) show a significant difference in at least two of the three trial months but this is not the case for trial store 86. We can check with the client if the implementation of the trial was different in trial store 86 but overall, the trial shows a significant increase in sales.