Power BI dashboard: Purchase Orders Analysis

A comprehensive Power BI visualizing pending purchase orders (billing/receipt) to identify delays, vendor performance, and trends, enabling actionable insights for procurement efficiency

Key Insights:

  • Pending Receipt: 8% of POs were pending receipt, with an amount of $ 2M, primarily due to supply chain bottlenecks..
  • Pending Billing: Identified $12M in pending billing delays, with SteelWorks Ltd. accounting for 40% of the total pending amount.

Project Impact:

  • Analyzed $2.5M in pending billing delays, identified supply chain bottlenecks causing 180-day receipt delays, and flagged top 3 vendors contributing to 65% of issues. Delivered insights that improved vendor tracking, cash flow, and procurement efficiency.