I am an analyst for Instacart, an online grocery store that operates through an app. Instacart already has very good sales, but they want to uncover more information about their sales patterns. My task is to perform an initial data and exploratory analysis of some of their data in order to derive insights and suggest strategies for better segmentation based on the provided criteria.
The Instacart stakeholders are most interested in the variety of customers in their database along with their purchasing behaviors. They assume they can’t target everyone using the same methods, and they’re considering a targeted marketing strategy. They want to target different customers with applicable marketing campaigns to see whether they influence the sales of their products. My analysis will inform what this strategy might look like to ensure Instacart targets the right customer profiles with the appropriate products.
Working with such a large dataset put a strain on my computer’s memory. Although my computer had the necessary specifications to handle the dataset, there were times that I had to wait several minutes for the data to load/export.
There were times during the project in which I wanted to start over due to learning new knowledge and skills. Due to time constraints, I continued the project but plan on revising in the future.
I am an analyst for Instacart, an online grocery store that operates through an app. Instacart already has very good sales, but they want to uncover more information about their sales patterns. My task is to perform an initial data and exploratory analysis of some of their data in order to derive insights and suggest strategies for better segmentation based on the provided criteria.
The Instacart stakeholders are most interested in the variety of customers in their database along with their purchasing behaviors. They assume they can’t target everyone using the same methods, and they’re considering a targeted marketing strategy. They want to target different customers with applicable marketing campaigns to see whether they influence the sales of their products. My analysis will inform what this strategy might look like to ensure Instacart targets the right customer profiles with the appropriate products.
Working with such a large dataset put a strain on my computer’s memory. Although my computer had the necessary specifications to handle the dataset, there were times that I had to wait several minutes for the data to load/export.
There were times during the project in which I wanted to start over due to learning new knowledge and skills. Due to time constraints, I continued the project but plan on revising in the future.
The data utilized for this project:
As shown in the population flow image below, I started out with four separate datasets. With each dataset, I conducted data wrangling, subsetting, and consistency checks. The datasets were then merged into one dataset, from which I derived new variables in the form of flags in order to separate the dataset into three distinct groups. I utilized IF statements to group the data further.
