Blinkit Sales Dashboard using PowerBI
Project Objective-This project showcases a detailed Power BI dashboard designed to analyze Blinkit's sales performance, customer satisfaction, and inventory distribution.
Used Tool-๏ปฟExcel, Power BI.
Business Problem-The goal is to identify trends and patterns in sales data to optimize inventory management, marketing strategies, and overall business performance.
Steps involved while creating the Project- 1.Data Cleaning-Removing unnecessary columns and duplicates. Handling missing values.
2.๐๐๐ญ๐ ๐๐จ๐๐๐ฅ๐ข๐ง๐ : Created and optimized data relationships for effective analysis. 3.๐๐๐ญ๐ ๐๐ซ๐จ๐๐๐ฌ๐ฌ๐ข๐ง๐ : Developed calculated columns and measures. Aggregated and prepared data for visualization. 4.๐๐๐ ๐๐๐ฅ๐๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง๐ฌ: Implemented DAX formulas for metrics like Total Sales and Average Rating. Validated calculations for accuracy. 5.๐๐๐ฌ๐ก๐๐จ๐๐ซ๐ ๐๐๐ฒ๐จ๐ฎ๐ญ & ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ข๐ณ๐๐ญ๐ข๐จ๐ง: Designed a user-friendly layout with various visualizations, including Donut and Bar Charts,Funnel chart. Developed and formatted visual elements for clarity. 6.๐๐๐ฌ๐ก๐๐จ๐๐ซ๐ ๐๐ง๐ญ๐๐ ๐ซ๐๐ญ๐ข๐จ๐ง & ๐๐๐ฌ๐ญ๐ข๐ง๐ : Integrated components into a cohesive dashboard. Tested for functionality and interactivity. 7.๐๐ง๐ฌ๐ข๐ ๐ก๐ญ๐ฌ ๐๐๐ง๐๐ซ๐๐ญ๐ข๐จ๐ง: Analysed visualizations to extract actionable insights. Compiled findings and recommendations into a report.
Used charts & tools : 1)line chart " illustrate to the outlet establishment. 2) cluster bar chart " illustrate to the item type. 3)donut chart " illustrate to the fat by content, outlet size. 4)funnel chart " illustrate to the outlet location.
Insights and Conclusions:
The total number of sales transactions made is 1.20M Sales. The average customer rating out of 5 is around 4. The total number of items available for sale is about 9K.
Key Insights
Key Performance Indicators (KPIs)
Total Sales: $1.20M Average Sales per Item: $141 Number of Items Sold: 8,523 Average Ratings: 3.9 Detailed Insights
- Sales by Fat Content:
Low Fat: $776.32K Regular: $425.36K 2. Sales by Outlet Types:
Supermarket Type1: $787.55K (5,577 items, Avg. Rating 3.92) Grocery Store: $151.94K (1,083 items, Avg. Rating 3.93) Supermarket Type2: $131.48K (928 items, Avg. Rating 3.93) Supermarket Type3: $130.71K (935 items, Avg. Rating 3.91) 3. Sales by Item Type:
Top-selling categories include Fruits and Vegetables, Snack Foods, Household items, and Frozen Foods. 4. Sales by Outlet Establishment Year:
Consistent increase in sales for outlets established from 2018 to 2022. 5. Sales by Outlet Size:
Medium-sized Outlets: $507.90K Small Outlets: $444.79K Large Outlets: $248.99K 6. Sales by Outlet Location:
Tier 3 Locations: $472.13K Tier 1 Locations: $336.40K Tier 2 Locations: $393.15K Conclusion
The analysis reveals significant trends in Blinkit's sales data. Medium-sized outlets and Tier 3 locations are leading in sales, with low-fat items generating more revenue compared to regular items. The data also shows a consistent increase in sales for newer outlets, indicating potential growth opportunities.
Recommendation
-
Optimize Inventory: Focus on increasing the availability of low-fat items, especially in medium-sized outlets and Tier 3 locations.
-
Targeted Marketing: Develop targeted marketing strategies for top-selling categories and high-performing outlet types to maximize sales.
-
Expand Outlet Sizes: Consider expanding the size of successful outlets to enhance overall sales performance.