Sweet Crust Bakery - Power BI/SQL/Excel Project

🧁 Sweet Crust Bakery - Data Analyst Project Overview

Welcome to your first assignment as a Data Analyst at Sweet Crust Bakery, a fast-growing artisan bakery chain with multiple stores across the USA. The company has experienced a rollercoaster of performance over the years — some products have been best-sellers, some stores thrived, while others struggled. Now, it’s your job to uncover the story hidden in the data.

You’ve been provided with:

• and 20,000 messy, unstructured records from the years 2018 to 2023, filled with inconsistencies, case errors, bad performance periods, and unstandardized formats.
  
  

This is your chance to showcase your data cleaning, analysis, and visualization skills — just like a real data analyst working for a dynamic retail business.

🔍 Project Goals

1. Identify high- and low-performing years, stores, categories, and products.
   
   

2. Clean and standardize messy historical data.
   
   

3. Provide actionable insights to improve product offerings and store performance.
   
   

4. Visualize trends to support business decisions.
   
   

Would you like me to now write separate task briefs for:

• 🟢 Excel Project
  
  

• 🟣 Power BI Projects (2 types)
  
  

• 🔵 SQL Project?