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.
The dashboard focuses on the following primary KPIs:
- 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.