Objectives
To perform an initial data and exploratory analysis of sales data from an online grocery store, Instacart, in order to uncover insights into sales patterns. The analysis aims to derive actionable insights and suggest strategies for improved customer segmentation based on the identified criteria.
Instacart Online Grocery Store
Relevant Skills
Python Data Wrangling Data Merging Deriving Variables Grouping Data Aggregating Data Reporting in Excel Population Flows
Insights & Recommendations
Instacart sees peak orders on weekends during working hours, with mid-range products dominating sales. Married middle-aged customers with dependents spend the most, while higher-priced items are rarely purchased. Strategies should focus on boosting loyalty, promoting mid-range products, and increasing high-end sales during off-peak times.