INSTACART BASKET ANALYSIS
Overview
OBJECTIVE
​Explore Instacart's sales trends to formulate strategies for boosting sales.
TOOLS ​
SKILLS
-
Data wrangling
-
Data merging
-
Deriving variables
-
Grouping data
-
Aggregating data
-
Reporting in Excel
-
Population Flows
DATA
Sourced from Kaggle.
Data sets contain
information on customers,
orders, products, and
departments.
Analysis
Peak Hours of the Day for Orders Placed
A histogram chart was created from the data to identify the busiest hours for order placement.
KEY INSIGHT: The slowest hours of the day are from 12 AM - 6 AM.
Peak Days of the Week for Orders Placed
A bar chart was also created from the data to identify the busiest days for order placement.
KEY INSIGHT: The chart indicates that Tuesday and Wednesday are the slowest days of the week, represented by the numbers 3 and 4.
Peak Spending Times of the Day
A line chart was created to pinpoint the times of day with the highest spending levels.
KEY INSIGHT: The highest expenditure takes place from 10 AM - PM.
Recommendations
-
Advertisements should be scheduled on Tuesdays and Wednesdays since they are the slowest days of the week.
-
Advertisements should be scheduled from 12 am – 6 am since those are the slowest hours of the day.
-
Advertise products that aren't selling as much from 10 pm - 7 am since that is when the highest expenditure takes place.
-
Advertise or provide deals on products that do not sell as much.