Case Study: Grocery Supply Franchise Sales Overview
This Power BI dashboard was developed using a dummy database created in PostgreSQL, provided by W3Schools.
It provides key insights into sales performance, customer segmentation, and profitability across various categories and countries.
Sales Analysis
Customer Segmentation
Profitability Insights
Power BI & SQL
Dashboard Analysis
Watch the Grocery Supply Sales Overview Dashboard in action.
Key Insights:
Profit by Country: The USA is the leading country in terms of profit, followed by Germany and Brazil.
Customer Distribution:
The USA, France, and Germany have the highest number of customers.
Countries with the highest number of orders are the USA, Germany, and Brazil.
Sales by Category - Yearly Overview:
2021: Beverages were the top-selling product category, followed by Dairy Products.
2022: Dairy Products became the leading category, followed by Beverages.
2023: The sales trend reverted to resemble 2021, with Beverages again leading, followed by Dairy Products.
Profit by Product Category: Categories like Beverages, Dairy Products, and Grains/Cereals consistently contribute significantly to profitability.
Customer Segmentation: A detailed segmentation of customers by region and product preference reveals that Beverages and Dairy Products are popular across multiple regions.
Observations:
The USA not only generates the highest profit but also leads in customer count and order volume, emphasizing its pivotal role in driving business performance.
Germany and Brazil are key contributors to order volume, though Brazil lags behind in customer count compared to France.
Product preferences vary slightly over the years, but Beverages and Dairy Products dominate overall sales consistently.