Embedded Files
MAIN TASK
You are part of Quantium’s retail analytics team and have been approached by your client, the Category Manager for Chips, who wants to better understand the types of customers who purchase Chips and their purchasing behaviour within the region. The insights from your analysis will feed into the supermarket’s strategic plan for the chip category in the next half year
The data structure
Data cleaning process
Creating a new Table
Cleaned Temp_transaction table
Cleaned purchase_behaviour table
PROCESS OF ANALYSIS
Total Lifestage
LIFESTAGE: Customer attribute that identifies whether a customer has a family or not and what point in life they are at e.g. are their children in pre-school/primary/secondary school
Total customer Type
CUSTOMER TYPE: Customer segmentation used to differentiate shoppers by the price point of products they buy and the types of products they buy. It is used to identify whether customers may spend more for quality or brand or whether they will purchase the cheapest options
Total customers
Total customers by customer type
Total stores
Total products
Total pack size
Total sales
Customer type by total sales
Budget customer type's life stage by total sales
Mainstream customer type's life stage by total sales
Premium customer type's life stage by total sales
Mainstream customer type's total quantity sold by product
Premium customer type's total quantity sold by product
Budget customer type's total quantity sold by product
Budget customer type's monthly purchase
Mainstream customer type's monthly purchase
Premium customer type's monthly purchase
Budget customer type's weekly purchase
Mainstream customer type's weekly purchase
Premium customer type's weekly purchase
Budget customer type's yearly purchase
Mainstream customer type's yearly purchase
Premium customer type's yearly purchase
Page updated
Google Sites
Report abuse