Data Analytics & Visualization - Purchase Order Monitoring Dashboard and Reminder System

Project Background
• PO data scattered across multiple sheets, making it difficult to extract insights.
• Missed PO expirations date could lead to cost, time, and operational losses.

Objective
Visualize PO data to simplifies data analysis, enabling faster decision-making and PO expirations reminders to prevent overlooked expirations.

Impacts
Improved visibility, planning, and accountability, reduced manual checks, and timely follow-up on expiring purchase orders.

Purchase Order Monitoring Dashboard Features
• Panel filters: PO Release Year
• Scorecards: Total PO and its amount, Total open PO and its amount, Total PO released this month, Total Closed PO, Total canceled PO, Total upcoming PO expire
• Charts: PO utilization by percentage and amount, PO amount per vendor, upcoming PO expire list, PO release trend
• PO details table

Purchase Order Expiration Reminder System Features
• Auto-send emails when a PO expires in 1 month and 2 months before the PO expiration date.

Tools: Google Spreadsheet, Google Looker Studio, Google Apps Script