A complete business performance dashboard built in Power BI to analyze Blinkit’s outlet-wise performance across locations, sizes, and item types. The dashboard helps business managers track revenue, outlet establishment trends, product performance, and customer ratings to make better strategic decisions.
- Power BI Desktop
- Power Query (M) for data transformation
- DAX (Data Analysis Expressions) for KPI measures
- Excel (.xlsx) as data source
Format: Excel (.xlsx) Records: ~8,500 product entries Fields include: Outlet ID, Outlet Type, Outlet Location, Item Type, Outlet Size, Year of Establishment, Total Sales, Average Rating, Number of Items, and Item Visibility. Source: Simulated Blinkit dataset created for learning and visualization purposes
Blinkit’s management wanted a clear view of outlet-level business performance, including total sales, customer feedback, and product category distribution. They also needed insights into which outlet locations, item types, and fat contents generate higher sales.
- Track total revenue, average sales, and customer ratings
- Analyze outlet performance by type, size, and location
- Identify top-performing item categories and fat content types
- Study year-wise outlet establishment trends
- Enable managers to compare outlets using interactive slicers
-
KPI Cards: Total Sales, Average Rating, Average Sales, Number of Items
-
Line Chart: Outlet Establishment Trend (2012–2022)
-
Donut Chart: Outlet Size Distribution
-
Bar Charts:
- Outlet Location Contribution
- Fat Content by Outlet
- Item Type-wise Revenue
-
Table: Outlet Type Performance with key KPIs
-
Filter Panel: Dynamic filters for Outlet Location, Size, and Item Type
- Supermarket Type1 outlets generate the highest business revenue of $787.55K — showing strong customer trust.
- Tier 3 locations lead with $472.13K, highlighting high order volume from smaller cities.
- Regular fat items drive higher business compared to low-fat ones.
- Fruits, snacks, and household goods rank as the top item categories by revenue.
- Average customer rating of 3.9 across all outlets indicates consistent satisfaction levels.
- Outlet establishment peaked around 2018, reflecting Blinkit’s rapid growth phase.
- Custom filter panel for user-friendly analysis
- Consistent yellow-green theme inspired by Blinkit branding
- Dynamic DAX measures for real-time KPI calculation
- Interactive design for location and outlet-based exploration
