Blinkit Sales Analysis Dashboard

🔍 Project Overview
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 to better understand sales trends.

📊 Key Performance Indicators (KPIs)

The dashboard highlights 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 Sold: Total count of different items sold (8,523)
• Average Rating: Average customer rating for items sold (3.9 out of 5)

📁 Dataset Information

The dataset used for this analysis includes detailed information on Blinkit’s sales performance, customer ratings, and inventory distribution across various outlets. The dataset covers a period from 2012 to 2022 and contains the following columns:

• Item Identifier: Unique ID for each item
• Item Type: Category of the item (e.g., fruits, vegetables, snacks)
• Outlet Identifier: Unique ID for each Blinkit outlet
• Outlet Type: Type of outlet (e.g., supermarket, grocery store)
• Outlet Location Type: Tier 1, Tier 2, or Tier 3 cities
• Item MRP: Maximum Retail Price of the item
• Item Visibility: Visibility percentage of the item in the store
• Sales Amount: Total sales revenue generated per item
• Customer Ratings: Average rating of the item given by customers

⚙️ Features

• Filter Panel: Allows users to filter data by outlet location type, outlet size, and item type.
• Outlet Establishment Trend: Visualizes the growth of Blinkit outlets from 2012 to 2022.
• Fat Content Analysis: Breaks down sales by low-fat and regular-fat products.
• Item Type Distribution: Displays sales distribution across various product categories.
• Outlet Size and Location Analysis: Insights into sales performance by outlet size and location tier.
• Outlet Type Comparison: Compares outlet types based on sales, number of items sold, average sales, ratings, and item visibility.

📈 Insights and Conclusions

• Strong overall sales performance with over $1M in total sales.
• Consumer preference for low-fat products indicates health-conscious trends.
• Fruits, vegetables, and snack foods are the top-selling categories.
• Medium-sized outlets in Tier 3 locations demonstrate the highest profitability.
• Supermarkets generate higher sales volumes, while grocery stores show better item visibility.

🛠️ Tools and Technologies Used

• Power BI: For creating the dashboard and visualizations.
• Excel: For initial data cleaning and preparation.
• SQL: For querying the dataset and extracting insights.

🚀 How to Use the Dashboard

1. Download the Power BI File: Link
2. Open Power BI: Launch Power BI Desktop and load the file.
3. Interact with Filters: Use the filter panel to explore sales by location, outlet size, item type, etc.
4. Analyze the Visualizations: Explore the dashboard to find insights on sales trends, customer preferences, and outlet performance.

📝 Future Enhancements

• Integration of real-time sales data for live monitoring.
• Adding predictive analytics to forecast future sales trends.
• Expansion of the dataset to include regional and seasonal sales insights.

Note: This analysis was conducted as part of a project and is intended for educational purposes only.

📧 Contact

For any questions or feedback, feel free to reach out via LinkedIn : Mayank Yadav.