Data Analyst
Instacart Basket Analysis
A Python based exploratory analysis of grocery order trends for Instacart to suggest targeted marketing strategies
Project Overview
Objective
Objective
Objective
Perform an exploratory analysis to answer business questions and derive insights about buying trends and customer demographics in order to target customers with applicable marketing strategies.
Data
Objective
Objective
Data was provided as part of the CareerFoundry Data Course. Grocery dataset was sourced from Instacart. Fictitious Customer Data was sourced from CareerFoundry.
Skills
Skills
Skills
Data wrangling, Data merging, Deriving variables, Grouping data, Aggregating data, Reporting in Excel, Population flows
Tools
Skills
Skills
Jupyter Notebooks, Python, Pandas, Excel
Project Flow
Data Wrangling & Cleaning
Data Wrangling & Subsetting
Data Consistency Checks
Merging Data
Combining and Exporting Dataframes
Answering Business Questions
Deriving new variables
Grouping & Aggregating Data Crosstabs
Data Visualizations
Utilize matplotlib to create visualizations
Presenting Results
Generate report with population flow to show analysis method and results
Analysis
Final Report
Recommendations
•Ads should be scheduled on Wednesdays then Tuesdays outside of the 10am-3pm timeframe to boost app activity during the slowest times.
•Higher priced items should be advertised between the hours of 12am and 7am.
•Implement an incentive plan to get more new customers who have 10 or less orders to return and increase brand loyalty.
•Target middle income users aged 25-64 with multiple dependents with ads, promotions, and recommendations from the produce, dairy/egg, and snack departments.
TAKEAWAYS
•Python makes it easier to work with large datasets. But with such large amounts of data, my system can run slow, or I might run into memory errors, I can convert data types to help with that.
•Next time to improve my analysis I can derive more variables and different groupings to further understand the ordering habits of the customer base.
Deliverables
Copyright © 2022 Shey LeGras - All Rights Reserved.
Powered by GoDaddy
This website uses cookies.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.