Welcome to the Grocery Stores Analysis Power BI project! 🚀 This project is designed to unravel insights from a rich dataset, boasting multiple columns and over 10,000 rows of grocery store information.
Explore the live Power BI dashboard for real-time interaction and a deeper understanding of the grocery store data. Click here to access the live dashboard.
- Profit Margin: Achieving an impressive 59.67% profit margin!
- Highest Total Sales: Los Angeles shines as the leader in total sales.
- Highest Total Profit and Quantity: The North West region dominates, securing both the highest total profit and quantity sold.
- Most Profitable Month: November takes the crown as the most profitable month. 🍂💸
- Most Sold, Most Profitable, and Most Quantity Sold Product Brand: The 'Hermanos' brand emerges as the superhero, leading in sales, profitability, and quantity sold.
- Top Selling Country: The USA proudly stands as the top-selling country.
- Majority of Sales from Supermarkets: Supermarkets play a pivotal role, contributing significantly to the overall sales.
- Increasing Return Rate Over Months: Observing a concerning trend of increasing return rates over the months.
- Total Return Amount: Noteworthy return amount totaling $17.43K.
Explore the interactive Power BI dashboard to gain a deeper understanding of these findings and visualize the data in engaging ways. The dashboard provides a user-friendly interface to interact with the information visually.
This Power BI project takes you on a journey through the grocery store data, revealing key insights and trends. Feel free to navigate the dashboard and discover more about the performance of grocery stores. Happy exploring! 🌐🛒