Report Description
Using the Instacart Grocery Basket Analysis Dataset from Kaggle, which includes over 3 million orders from 200,000+ users, we explored shopping patterns based on product selection and cart behavior. These visuals demonstrate how teams can track what matters most, from when people shop to what they buy and how products interact in the cart.
Audience:
Independent or family-owned grocery stores looking to boost sales
Regional grocery chains wanting to use data to improve operations
Online grocery startups building product recommendation features
Use Case
This report helps grocery stores use their existing purchase data to drive smarter merchandising and promotions. By analyzing which items are frequently bought together, identifying shopper behavior by time and category, and segmenting customers, store owners can create more effective bundles, personalized offers, and targeted marketing strategies.
Read the Data Story here.
How to Use This Report
- Total Orders: Shows the total number of orders included in this report.
- Overall Reorder Rate: Displays the percentage of orders that were reorders.
- Top 20 Products by Total Sales: Lists the top products ranked by reorder rate. Selecting a product will highlight its details across the report.
- Top Co-Products with Selected Item: Displays products most often purchased with the selected item. Choose any column in the section to discover details.
- Order Volume by Time of Day: Shows when items are most frequently ordered. Selecting a time frame updates other sections to display related items, top departments, and sales by day of the week.
- Total Sales Orders by Day of Week: Selecting a day reveals detailed insights for that day in other sections.
- Top 5 Departments by Sales Orders: Breaks down sales by department. Selecting a department reveals related details, such as top products and shopping patterns by time and day.
