Purchasing Behavior Analysis

For this project, I acted as an analyst for Quantium Australia, a trusted data analytics partner with clients across a range of sectors, helping them maximize the potential of their data assets and address some of their most pressing challenges.

Supermarkets 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 capitalize on new opportunities. The Quantium analytics team is engaged in these processes to evaluate and analyze the performance of change and recommend whether it has been successful.

Our client Julia, the Category Manager for Chips of a regional grocery chain, has provided two data sets: customer transaction data and purchase behavior, spanning from July 2018 to June 2019. I need to present a strategic recommendation to Julia for her upcoming category review.

The client wants to:
1. Understand the current purchasing customer trends and behaviors.
2. Evaluate the performance of a store trial which was performed in stores 77, 86 and 88.
3. Provide data-driven recommendations on whether they should be implemented across all their stores.

With the provided datasets, I managed to:
1. Identify the top three purchasing segments, distinguishing which group contributed more to sales based on a higher customer count, and which did so due to a high purchase count per customer. Additionally, determined the most favorable items.
2. Find statistical evidence supporting the efficacy of the new trial store layout in terms of customer count and total sales. Presented a recommendation to the manager to implement the new layout across all stores.
3. Present the results using the Pyramid Principle in a PowerPoint format. This Principle is tailored for busy executives, ensuring they could efficiently absorb the findings.

The two analyses and the final presentation slides are below:
Retail Strategy Analysis
New Store Layout Assessment