CF-Achievement 4 Project Brief: Instacart Grocery Basket Analysis

This is a sample project mirroring real company data. Gaining insights & enhancing segmentation for improved sales.

Context

Instacart aims to understand customer behaviors and preferences for targeted marketing strategies. Key questions include busiest days, peak spending times, product popularity, and customer segmentation.

Objective

Conduct an initial data and exploratory analysis for Instacart to uncover sales patterns, derive insights, and suggest segmentation strategies.

Key Questions

1. Identify the busiest days and hours for scheduling ads.
2. Determine peak spending times for targeted product advertisements.
3. Simplify price range groupings for effective marketing.
4. Analyze popular product departments for strategic focus.
5. Investigate customer loyalty, regional differences, and demographics.

Stakeholders

• Vice President of Marketing: Improve ad campaign targeting.
• Senior Vice President of Sales: Enhance low-market-share sectors.
• Instacart Customer: Receive relevant ads, promotions, and recommendations.

Data

Utilize open-source data sets from Instacart, including customer data. Refer to provided data dictionary and citation for dataset details.

CareerFoundry Data Sets:

• Customers Data Set

Instacart Data Sets:

• Data Dictionary
• Kaggle-Instacart datasets

Tools

• Utilizing the latest versions of MS Excel, Anaconda, Jupyter Notebook, and Python.

Note: Instacart is a real company that’s made their data available online. However, the contents of this project brief have been fabricated for the purpose of this Achievement.