Project Details

Stush Foods is a growing food company seeking to enhance its sales strategy and drive market expansion. This project aims to empower Stush Foods with a comprehensive, data-driven tool by combining two critical business functions: sales performance analysis and retail opportunity identification.

A team of two learners, with a total of 120 hours, will be tasked with the following:

1. Sales Performance Consolidation & Analysis: The team will begin by consolidating monthly sales reports from our three different distributors, each with a unique format, into a single, standardized dataset. From this unified data, they will build a dynamic dashboard that allows for the analysis of key metrics, including sales trends by region, city, store, and the impact of specific promotions. This will help Stush Patties understand what’s working and where to optimize.
2. Retail Opportunity Identification: The team will also create a separate but integrated dashboard focused on future growth. This tool will combine existing retail locations with publicly available demographic data (e.g., from sources like Statistics Canada) to visualize our current distribution and identify underserved or high-potential neighborhoods. By developing a scoring system, the dashboard will flag promising locations for future retail placement, enabling strategic decision-making for expansion.

This project will provide learners with an opportunity to apply their skills in data cleaning, integration, analysis, and visualization in a real-world business scenario. The final product will be a user-friendly, impactful tool that allows Stush Patties to make data-driven decisions efficiently and confidently.

The primary deliverables for this project are as follows:

• Unified Sales Dataset: A clean, standardized dataset merging sales information from all distributors.
• Sales Performance Dashboard: A fully functional dashboard that visualizes key sales metrics and includes interactive elements to filter data by retailer, SKU, time period, and promotional activity.
• Retail Opportunity & Expansion Dashboard: A dynamic, interactive map that visually represents current store locations and overlays demographic data to identify and rank high-potential neighborhoods for future retail expansion.
• Summary Report: A comprehensive report of the findings and actionable insights from both the sales analysis and the retail opportunity identification.
• User Guide: Brief, clear documentation on how to update and effectively utilize both dashboards for ongoing sales analysis and expansion planning.