Integrated Sales & Retail Opportunity Dashboard for Stush Foods
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: 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. 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.
Stush Patties Sales Dashboard Development
Stush Patties, a company specializing in gourmet patties, seeks to enhance its sales analysis capabilities by developing a comprehensive sales dashboard. The goal of this project is to enable the company to visualize and interpret monthly sales data effectively. Learners will be tasked with analyzing raw sales data, identifying key performance indicators, and designing a user-friendly dashboard that provides actionable insights. The project will involve data cleaning, manipulation, and visualization using tools such as Excel, Tableau, or Power BI. By the end of the project, learners will have applied their classroom knowledge of data analysis and visualization to create a practical tool that aids in strategic decision-making for Stush Patties.
Website Development for Stush Patties
Our company, Stush Patties, specializes in gourmet Jamaican patties for retail and food service businesses. We aim to revamp our current website and create a new one that reflects our brand's essence and appeals to both our direct clients (businesses) and indirect clients (consumers). The new website will not include online purchase features but must showcase store locations. Project Objectives We seek to collaborate with students to develop a new website that is easy to maintain and provides an appealing user interface. This can be achieved using common site-building tools such as Wix, Webflow, and WordPress.
New Employee Training Development
We are a food manufacturing company and must follow strict guidelines, adhere to policies and procedures. We need an online course that will introduce employees to their new roles, policies and procedures, take employees through all start-up resources, and test their understanding of the training material. This must be done in an effecient manner so we can quickly onboard new employees without compromising training.
Digital Content Creation
We would like students to help us with creating content that is aligned with the company's brand positon. We will ensure the student has a clear understanding of our brand guidelines. Ultimately, you will be working on content creation for our organization, including video, social media, and other collateral that we can use as use to build brand awareness for our company. We are a small upcoming company producing a popular fun food item. If you like the sound of our culture, and are ready to tackle this challenge with us, then we'd love to hear from you.