How khushichaudhary06/blinkit-analysis-excel-dashboard works
This repository is an Excel-based Blinkit sales analysis dashboard. The documented workflow turns workbook data into prepared data, Pivot Table analysis, charts and KPIs, then an interactive dashboard for business insights. The analysis covers product, outlet, and customer-rating dimensions. The README documents workbook contents and workflow, but no source excerpts were available, so internal workbook wiring is represented only where documented.
Main entry points: Blinkit Analysis Project.xlsx Pivot Tables
Components 16
Data preparation
- Raw dataset
Blinkit Analysis Project.xlsx - Prepared data
Blinkit Analysis Project.xlsx
Sales analysis
- Pivot Tables
Blinkit Analysis Project.xlsx - Fat content
Blinkit Analysis Project.xlsx - Item type
Blinkit Analysis Project.xlsx - Outlet establishment
Blinkit Analysis Project.xlsx - Outlet size
Blinkit Analysis Project.xlsx - Outlet location
Blinkit Analysis Project.xlsx - Outlet type
Blinkit Analysis Project.xlsx - Customer ratings
Blinkit Analysis Project.xlsx
Dashboard and insights
- KPI metrics
Blinkit Analysis Project.xlsx - Pivot Charts
Blinkit Analysis Project.xlsx - Filters and slicers
Blinkit Analysis Project.xlsx - Interactive dashboard
Blinkit Analysis Project.xlsx - Business insights
Blinkit Analysis Project.xlsx
Other components
- Analyst
Connections 16
- Analyst → Interactive dashboard: views and filters
- Raw dataset → Prepared data: clean and structure
- Prepared data → Pivot Tables: aggregate
- Pivot Tables → Fat content: analyze
- Pivot Tables → Item type: analyze
- Pivot Tables → Outlet establishment: analyze
- Pivot Tables → Outlet size: analyze
- Pivot Tables → Outlet location: analyze
- Pivot Tables → Outlet type: analyze
- Pivot Tables → Customer ratings: analyze
- Pivot Tables → KPI metrics: calculate
- Pivot Tables → Pivot Charts: visualize
- Pivot Charts → Interactive dashboard: display
- KPI metrics → Interactive dashboard: display
- Filters and slicers → Interactive dashboard: filter views
- Interactive dashboard → Business insights: inform