# khushichaudhary06/blinkit-analysis-excel-dashboard architecture

> Architecture diagram of the GitHub repository khushichaudhary06/blinkit-analysis-excel-dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-29). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/khushichaudhary06/blinkit-analysis-excel-dashboard
- Repository: https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard

## Overview

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`](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx) (Pivot Tables)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_raw["Raw dataset"]
  node_prepared["Prepared data"]
end

subgraph group_analysis["Sales analysis"]
  node_pivots["Pivot Tables"]
  node_fat["Fat content"]
  node_item["Item type"]
  node_establishment["Outlet establishment"]
  node_size["Outlet size"]
  node_location["Outlet location"]
  node_outlet["Outlet type"]
  node_rating["Customer ratings"]
end

subgraph group_presentation["Dashboard and insights"]
  node_kpis["KPI metrics"]
  node_charts["Pivot Charts"]
  node_filters["Filters and slicers"]
  node_dashboard["Interactive dashboard"]
  node_insights["Business insights"]
end

node_analyst(("Analyst"))

node_analyst -->|"views and filters"| node_dashboard
node_raw -->|"clean and structure"| node_prepared
node_prepared -->|"aggregate"| node_pivots
node_pivots -->|"analyze"| node_fat
node_pivots -->|"analyze"| node_item
node_pivots -->|"analyze"| node_establishment
node_pivots -->|"analyze"| node_size
node_pivots -->|"analyze"| node_location
node_pivots -->|"analyze"| node_outlet
node_pivots -->|"analyze"| node_rating
node_pivots -->|"calculate"| node_kpis
node_pivots -->|"visualize"| node_charts
node_charts -->|"display"| node_dashboard
node_kpis -->|"display"| node_dashboard
node_filters -->|"filter views"| node_dashboard
node_dashboard -->|"inform"| node_insights

click node_raw "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_prepared "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_pivots "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_fat "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_item "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_establishment "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_size "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_location "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_outlet "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_rating "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_kpis "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_charts "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_filters "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_dashboard "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"
click node_insights "https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_raw,node_prepared toneBlue
class node_pivots,node_fat,node_item,node_establishment,node_size,node_location,node_outlet,node_rating toneAmber
class node_kpis,node_charts,node_filters,node_dashboard,node_insights toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Raw dataset](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Prepared data](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`

### Sales analysis

- [Pivot Tables](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Fat content](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Item type](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Outlet establishment](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Outlet size](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Outlet location](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Outlet type](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Customer ratings](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`

### Dashboard and insights

- [KPI metrics](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Pivot Charts](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Filters and slicers](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Interactive dashboard](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`
- [Business insights](https://github.com/khushichaudhary06/blinkit-analysis-excel-dashboard/blob/main/Blinkit%20Analysis%20Project.xlsx): `Blinkit Analysis Project.xlsx`

### Other components

- **Analyst**

## Connections

- 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