VENDOR PERFORMANCE ANALYSIS

An end-to-end procurement analytics project using SQL, Python, statistics and Power BI to evaluate vendor, product, profitability and inventory performance.

Vendor Performance Analytics Dashboard

PROJECT OVERVIEW

This project analyzes vendor performance using procurement, sales, profitability, inventory and freight cost data to identify key business insights and opportunities for improvement.

KEY ANALYSIS

The analysis includes vendor contribution, sales concentration, profitability, inventory performance, promotional opportunities, freight cost burden and statistical comparison of vendor groups.

TOOLS & TECHNOLOGIES

SQL   |   Python   |   Pandas   | Statistics   |   Power BI

DASHBOARD OVERVIEW

The Power BI dashboard provides an interactive overview of sales, purchases, gross profit, profit margin, unsold inventory and vendor contribution.

KEY ANALYSIS VISUALIZATIONS

Top 10 Vendor Purchase Contribution
Low Sales High Margin Brands Analysis
Freight Cost Anomaly Analysis
Statistical Validation Analysis
Portfolio Breadth Analysis

PROJECT REPOSITORY

The complete project, including analysis and supporting files, is available on GitHub.