Blinkit Sales Performance Dashboard
Analyzed Blinkit's sales, outlets, and fat content, item types data using Power BI to uncover insights on product performance, outlet efficiency, and customer preferences across locations.
Project Overview:
This Power BI project focuses on analyzing Blinkit’s sales performance, fat contents, item types and inventory distribution across multiple outlets. The goal was to identify trends, optimize sales strategies, and enhance operational efficiency using interactive visualizations and KPIs.
Key objectives included:
- Evaluating total and average sales performance.
- Understanding the relationship between fat content, outlet size, and location with total sales.
- Measuring customer satisfaction through average ratings.
- Comparing sales across different item types and outlet establishments to identify the top-performing segments.
KPIs Tracked:
- Total Sales: Overall revenue generated across outlets.
- Average Sales: Mean sales per item or outlet, showing sales consistency.
- Number of Items: Total products sold or available for analysis.
- Average Rating: Customer satisfaction indicator based on feedback.
Visualizations Used:
- Total Sales by Fat Content: Identifies whether low-fat or regular products generate higher revenue.
- Total Sales by Item Type: Reveals which product categories contribute most to total sales.
- Fat Content by Outlet for Total Sales: Analyzes how different outlets perform based on the type of products sold.
- Total Sales by Outlet Establishment: Compares sales performance based on how long outlets have been operating.
- Sales by Outlet Size: Evaluates whether store size impacts overall sales volume.
- Sales by Outlet Location: Highlights sales distribution across Tier 1, Tier 2, and Tier 3 cities.
- All Metrics by Outlet Type: Provides an integrated view of KPIs segmented by outlet type (e.g., grocery, supermarket).
Key Insights:
Low fat products generated higher total sales compared to regular-fat ones, indicating customer preference for low fat items.
Supermarkets recorded the highest sales volume, showing their dominance in Blinkit’s retail strategy.
Tier 3 cities showed surprisingly strong sales performance, suggesting potential for regional expansion.
Medium-sized outlets achieved better sales-to-size ratios, reflecting efficient space utilization.
Fruits, Vegetables and snack items contributed significantly to total sales, indicating high customer demand in these categories.
Outlets with longer establishment histories showed steadier sales growth, highlighting the role of customer loyalty.
Customer satisfaction remained consistent, with average ratings indicating reliable service and product quality.
Conclusion:
The Blinkit Power BI dashboard offers actionable insights into sales trends, outlet performance, and customer preferences. By leveraging data visualization and KPIs, the analysis helps Blinkit make informed decisions on product assortment, marketing strategy, and outlet expansion, ultimately driving profitability and customer satisfaction.
Access Datasets and other files from here
Realtime Dashboard
Connect me on Threads Linkedin
Check out my resume