Supplier Performance Dashboard for Supply Chain

Overview

Supply chain managers are drowning in data but starving for insights. Critical performance data is often siloed across multiple systems—an ERP for deliveries, spreadsheets for quality checks, and a helpdesk for tracking issues. This makes it nearly impossible to get a quick, holistic view of a supplier's true performance, which leads to reactive problem-solving instead of proactive management. This dashboard solves that problem by connecting to these disparate sources and presenting a single source of truth. It allows managers to spot negative trends before they become crises, hold suppliers accountable with objective data, and make smarter, more strategic sourcing decisions.

Retool Features Used

Multi-Source Data Integration: to connect and merge data in real-time from a PostgreSQL database, a Google Sheet, and a Zendesk API, creating a single, unified view.
Interactive Dashboard Filters: to allow users to filter the entire dashboard by a specific supplier or date range, providing instant, customized views of the data.
Master-Detail View (Modal Drill-Down): to enable users to click any supplier in the main table and open a detailed modal with tab-organized information on recent orders, quality logs, and support tickets.
Data Visualization Components: to use line charts for visualizing historical performance trends and color-coded badges to provide at-a-glance status information in tables.