17/06/2025
🚀 I’m super excited to share this data analysis project after completing the Google Data Analytics program! 🎓📊 Working with a dataset from a startup company, I got my hands dirty analyzing sales and product data using Power BI, and let me tell you—data is way more fun than I imagined! 🤓 It’s fascinating how much data can speak when you know how to listen to it, and how it can drive real business decisions.
Here’s what I uncovered during the project:
✅ Total Transactions & Units Sold:
Over 3.19 million units sold across Canada, France, Germany, India, Mexico, the United States, and Kenya. Canada leads with 1.47 million units sold! 🌎
✅ Revenue & Profit by Product:
Chocolate Chip cookies take the lead with $2M in profit, followed by White Chocolate with a strong $1M. 🍪💵
✅ Revenue by Country:
Mexico stands out with $358K in Chocolate Chip sales, while Germany and France are strong contenders, showing solid revenue. 🇲🇽🇩🇪🇫🇷
✅ Monthly Revenue Trends:
May and October saw huge spikes in sales, while July and August were a little quieter—perfect for targeted promotions during those summer months! 🌞📅
✅ Key Insights:
Chocolate Chip products dominate, but White Chocolate and Oatmeal Raisins are steady performers. 🍪
Canada, Mexico, and Germany are top markets, with seasonal trends like May and October bringing in higher sales. 🌍
💡 It’s amazing how data can reveal hidden patterns that can shape business strategies.
