Blinkit-Grocery-Sales-Dashboard

Project Overview

This interactive retail sales analysis dashboard is built using Excel Pivot Tables to analyze grocery sales data from Blinkit. It provides insights into total sales, outlet performance, item categories, and sales trends to support business decision-making.

Key Insights

• Total Sales and Average Sales: Analyze overall revenue performance
• Outlet Performance: Sales analysis based on outlet size and location
• Item Type Analysis: Sales distribution across different grocery categories
• Sales Trends: Growth of outlets over time

Features

• Dynamic filters for in-depth analysis
• Visualizations for outlet and item performance
• Trend analysis with interactive charts

Files in this Repository

• Dashboard File: Blinkit_Grocery_Sales_Dashboard.xlsx – Interactive Excel dashboard
• Dataset File: BlinkIT Grocery Data Excel.xlsx – Raw grocery sales data used for analysis
• GitHub Repository: Blinkit Grocery Sales Dashboard

How to Use

1. Download both the Excel dashboard and dataset from the repository
2. Open BlinkIT Grocery Data Excel.xlsx in Microsoft Excel
3. Use Blinkit_Grocery_Sales_Dashboard.xlsx to explore the visualized insights

Tags

RetailSales ExcelDashboard SalesAnalysis BusinessIntelligence PivotTable GrocerySales

Contact

LinkedIn Profile
GitHub Profile