This project presents a comprehensive Power BI dashboard for analyzing Blinkit's sales performance, customer satisfaction, and inventory distribution. The dashboard provides key insights and opportunities for optimization using various KPIs and visualizations.
Total Sales: Overall revenue generated from all items sold ($1.20M)
Average Sales: Average revenue per sale ($141)
Number of Items: Total count of different items sold (8523)
Average Rating: Average customer rating for items sold (3.9 out of 5)
Filter Panel: Allows users to filter data by outlet location type, outlet size, and item type
Outlet Establishment Trend: Visualizes the growth of outlet establishments from 2012 to 2022
Fat Content Analysis: Breaks down sales by low fat and regular fat products
Item Type Distribution: Shows sales distribution across various product categories
Outlet Size and Location Analysis: Provides insights on sales performance by outlet size and location tier
Outlet Type Comparison: Compares different outlet types based on sales, number of items, average sales, ratings, and item visibility
Strong overall sales performance with over $1M in total sales
Consumer preference for low-fat products, indicating health-conscious buying habits
Fruits, vegetables, and snack foods are the top-selling categories
Medium-sized outlets in Tier 3 locations show the highest profitability
Supermarkets generate higher sales volumes, while grocery stores have better item visibility
NOTE: This analysis was conducted as part of a project and is for educational purposes only.