Project Overview A data-driven Procurement Analytics

Project Overview

A data-driven Procurement Analytics Dashboard built in Power BI to monitor purchasing performance, vendor concentration, and order lifecycle management. It helps business managers optimize procurement costs and improve supply chain efficiency.

Key Highlights & Features

Financial Metrics (KPIs): Tracks total cost ($25.81M), discounts achieved ($2.07M), net procurement cost ($23.74M), and overall order quantities.

Spend by Category: Visualizes expense breakdown across key categories such as Electronics ($7.2M), Furniture ($5.4M), and Office Supplies.

Supplier Analysis: Identifies top suppliers by net spend (e.g., Supplier Alpha at 22% of total spend) to evaluate vendor risk and dependency.

Order Status Breakdown: Real-time visibility into order execution (65% Delivered, 22% Pending, 13% Cancelled).

Monthly Purchase Trends: Highlights spending patterns across the year (2024) to assist in seasonal budget planning.

Tools & Technologies

Power BI (Dashboard Design & DAX Visualizations)

Data Analytics & Visualization

Supply Chain & Financial Insights