# therishabhpro/vendor-performance-analysis architecture

> Architecture diagram of the GitHub repository therishabhpro/vendor-performance-analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/therishabhpro/vendor-performance-analysis
- Repository: https://github.com/therishabhpro/vendor-performance-analysis

## Overview

This repository is a vendor-performance analytics project. Its documented workflow loads raw transaction CSVs into SQLite, builds and cleans a vendor sales summary, analyzes procurement, sales, margins and inventory, then presents findings in reports and a dashboard. The source excerpts show ingestion, summary construction and reusable analytics; the README documents the notebook workflow and reporting capabilities. The database and raw-data directories are not present in the supplied tree, and notebook internals were not sampled, so those relationships rely on README evidence.

Main entry points: [`src/vendor_performance/vendor_performance_analysis.py`](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py) (Performance analysis), [`notebooks`](https://github.com/therishabhpro/vendor-performance-analysis/tree/main/notebooks) (Analysis notebooks), [`src/vendor_performance/ingestion_db.py`](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/ingestion_db.py) (CSV ingestion), [`src/vendor_performance/eda.py`](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/eda.py) (Vendor summary)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_pipeline["Data pipeline"]
  node_ingest["CSV ingestion<br/>[ingestion_db.py]"]
  node_database[("SQLite database")]
  node_summary["Vendor summary<br/>[eda.py]"]
  node_cleaning["Cleaning and features<br/>[eda.py]"]
end

subgraph group_analytics["Vendor analytics"]
  node_analysis["Performance analysis"]
  node_diagnostics["Business diagnostics"]
  node_statistics["Statistical tests"]
  node_notebooks["Analysis notebooks"]
end

subgraph group_outputs["Stakeholder outputs"]
  node_summary_csv["Vendor summary CSV"]
  node_report["Analysis report"]
  node_dashboard["Power BI dashboard"]
  node_figures["Analysis figures"]
end

node_analyst(("Analyst"))
node_rawcsv["Transaction CSVs"]

node_analyst -->|"runs analysis"| node_notebooks
node_analyst -->|"runs module"| node_ingest
node_rawcsv -->|"loads CSVs"| node_ingest
node_ingest -->|"writes tables"| node_database
node_database -->|"reads source tables"| node_summary
node_summary -->|"returns summary"| node_cleaning
node_cleaning -->|"writes summary table"| node_database
node_notebooks -->|"starts ingestion"| node_ingest
node_notebooks -->|"runs EDA"| node_summary
node_notebooks -->|"runs diagnostics"| node_analysis
node_analysis -->|"reads summary"| node_database
node_analysis -->|"calculates KPIs"| node_diagnostics
node_analysis -->|"tests margins"| node_statistics
node_analysis -->|"exports summary"| node_summary_csv
node_analysis -.->|"informs findings"| node_report
node_summary_csv -->|"feeds dashboard"| node_dashboard
node_analysis -.->|"produces visualizations"| node_figures

click node_ingest "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/ingestion_db.py"
click node_summary "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/eda.py"
click node_cleaning "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/eda.py"
click node_analysis "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py"
click node_diagnostics "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py"
click node_statistics "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py"
click node_notebooks "https://github.com/therishabhpro/vendor-performance-analysis/tree/main/notebooks"
click node_report "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/reports/vendor_performance_analysis_report.md"
click node_dashboard "https://github.com/therishabhpro/vendor-performance-analysis/blob/main/reports/dashboards/vendor_performance_dashboard.pbix"
click node_figures "https://github.com/therishabhpro/vendor-performance-analysis/tree/main/reports/figures"

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_ingest,node_database,node_summary,node_cleaning toneBlue
class node_analysis,node_diagnostics,node_statistics,node_notebooks toneAmber
class node_summary_csv,node_report,node_dashboard,node_figures toneMint
class node_analyst,node_rawcsv toneIndigo
```

## Components

### Data pipeline

- [CSV ingestion](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/ingestion_db.py): `src/vendor_performance/ingestion_db.py`
- **SQLite database**
- [Vendor summary](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/eda.py): `src/vendor_performance/eda.py`
- [Cleaning and features](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/eda.py): `src/vendor_performance/eda.py`

### Vendor analytics

- [Performance analysis](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py): `src/vendor_performance/vendor_performance_analysis.py`
- [Business diagnostics](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py): `src/vendor_performance/vendor_performance_analysis.py`
- [Statistical tests](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/src/vendor_performance/vendor_performance_analysis.py): `src/vendor_performance/vendor_performance_analysis.py`
- [Analysis notebooks](https://github.com/therishabhpro/vendor-performance-analysis/tree/main/notebooks): `notebooks`

### Stakeholder outputs

- **Vendor summary CSV**
- [Analysis report](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/reports/vendor_performance_analysis_report.md): `reports/vendor_performance_analysis_report.md`
- [Power BI dashboard](https://github.com/therishabhpro/vendor-performance-analysis/blob/main/reports/dashboards/vendor_performance_dashboard.pbix): `reports/dashboards/vendor_performance_dashboard.pbix`
- [Analysis figures](https://github.com/therishabhpro/vendor-performance-analysis/tree/main/reports/figures): `reports/figures`

### Other components

- **Analyst**
- **Transaction CSVs**

## Connections

- Analyst → Analysis notebooks: runs analysis (evidence: `README.md`)
- Analyst → CSV ingestion: runs module (evidence: `README.md`)
- Transaction CSVs → CSV ingestion: loads CSVs (evidence: `src/vendor_performance/ingestion_db.py`)
- CSV ingestion → SQLite database: writes tables (evidence: `src/vendor_performance/ingestion_db.py`)
- SQLite database → Vendor summary: reads source tables (evidence: `src/vendor_performance/eda.py`)
- Vendor summary → Cleaning and features: returns summary (evidence: `src/vendor_performance/eda.py`)
- Cleaning and features → SQLite database: writes summary table (evidence: `src/vendor_performance/eda.py`)
- Analysis notebooks → CSV ingestion: starts ingestion (evidence: `README.md`)
- Analysis notebooks → Vendor summary: runs EDA (evidence: `README.md`)
- Analysis notebooks → Performance analysis: runs diagnostics (evidence: `README.md`)
- Performance analysis → SQLite database: reads summary (evidence: `src/vendor_performance/vendor_performance_analysis.py`)
- Performance analysis → Business diagnostics: calculates KPIs (evidence: `src/vendor_performance/vendor_performance_analysis.py`)
- Performance analysis → Statistical tests: tests margins (evidence: `src/vendor_performance/vendor_performance_analysis.py`)
- Performance analysis → Vendor summary CSV: exports summary (evidence: `src/vendor_performance/vendor_performance_analysis.py`)
- Performance analysis → Analysis report: informs findings
- Vendor summary CSV → Power BI dashboard: feeds dashboard (evidence: `README.md`)
- Performance analysis → Analysis figures: produces visualizations
