This interactive Power BI dashboard provides a comprehensive overview of Blinkit's sales data, including total sales, average sales, product distribution, outlet performance, and customer engagement metrics. The dashboard allows stakeholders to quickly derive insights into the sales dynamics across different outlet types, sizes, locations, and item categories.
- Total Sales:
$1.20M - Average Sales per Item:
$141 - Total Number of Items Sold:
8523 - Average Rating:
3.9
Users can filter the data using the following dropdowns:
- Outlet Location Type
- Outlet Size
- Item Type
Additionally, a Clear all slicers button is available for resetting all filters.
- Summarized KPIs for Total Sales, Avg Sales, No of Items, and Avg Rating.
- Line and area chart showing yearly sales from 2010 to 2022.
- Doughnut chart displaying sales from Low Fat vs Regular items.
- Bar chart ranking sales contributions by item categories like Fruits, Dairy, Health Drinks, etc.
- Sales comparison for Tier 1, 2, and 3 outlet locations.
- Doughnut chart showing proportion of sales across Small, Medium, and High outlet sizes.
- Tabular breakdown showing:
- Total Sales
- Number of Items
- Average Sales
- Average Rating
- Item Visibility
- Supermarket Type1 leads in Total Sales and Item Count.
- Tier 3 locations contribute the highest sales volume.
- High outlet size locations generate the most revenue.
- Grocery Stores have the highest item visibility.
- Power BI: Dashboard creation and data visualization
- Data Source: Internal Blinkit sales database
- Visualizations Used: Bar charts, line charts, doughnut charts, KPI cards, slicers, tables
- Open the dashboard in Power BI.
- Use filters on the left to slice data by location type, outlet size, or item type.
- Analyze trends and metrics using visual components.
- Use insights for strategic planning, inventory management, and outlet optimization.