How therishabhpro/vendor-performance-analysis works
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: vendor_performance_analysis.py Performance analysis · notebooks Analysis notebooks · ingestion_db.py CSV ingestion · eda.py Vendor summary
Components 14
Data pipeline
- CSV ingestion
src/vendor_performance/ingestion_db.py - SQLite database
- Vendor summary
src/vendor_performance/eda.py - Cleaning and features
src/vendor_performance/eda.py
Vendor analytics
- Performance analysis
src/vendor_performance/vendor_performance_analysis.py - Business diagnostics
src/vendor_performance/vendor_performance_analysis.py - Statistical tests
src/vendor_performance/vendor_performance_analysis.py - Analysis notebooks
notebooks
Stakeholder outputs
- Vendor summary CSV
- Analysis report
reports/vendor_performance_analysis_report.md - Power BI dashboard
reports/dashboards/vendor_performance_dashboard.pbix - Analysis figures
reports/figures
Other components
- Analyst
- Transaction CSVs
Connections 17
- Analyst → Analysis notebooks: runs analysis
README.md - Analyst → CSV ingestion: runs module
README.md - Transaction CSVs → CSV ingestion: loads CSVs
src/vendor_performance/ingestion_db.py - CSV ingestion → SQLite database: writes tables
src/vendor_performance/ingestion_db.py - SQLite database → Vendor summary: reads source tables
src/vendor_performance/eda.py - Vendor summary → Cleaning and features: returns summary
src/vendor_performance/eda.py - Cleaning and features → SQLite database: writes summary table
src/vendor_performance/eda.py - Analysis notebooks → CSV ingestion: starts ingestion
README.md - Analysis notebooks → Vendor summary: runs EDA
README.md - Analysis notebooks → Performance analysis: runs diagnostics
README.md - Performance analysis → SQLite database: reads summary
src/vendor_performance/vendor_performance_analysis.py - Performance analysis → Business diagnostics: calculates KPIs
src/vendor_performance/vendor_performance_analysis.py - Performance analysis → Statistical tests: tests margins
src/vendor_performance/vendor_performance_analysis.py - Performance analysis → Vendor summary CSV: exports summary
src/vendor_performance/vendor_performance_analysis.py - Performance analysis → Analysis report: informs findings
- Vendor summary CSV → Power BI dashboard: feeds dashboard
README.md - Performance analysis → Analysis figures: produces visualizations