top of page

Looker Vendor Performance Dashboard

To design and implement a comprehensive dashboard that tracks vendor performance across key parameters—Spend, Service Quality, and Delivery Lead Time—to enable data-driven decision-making and continuous improvement in supplier management.

image.png

Project Leadership Highlights

  • End-to-end ownership from requirement gathering to dashboard deployment

  • Collaborated with cross-functional teams (Procurement, Logistics, Finance) to define KPIs

  • Designed user-centric visualizations in Looker for quick insights and deep dives

  • Integrated multiple data sources and ensured data accuracy, consistency, and real-time refresh

  • Created filterable views by vendor, category, region, and time period

Key Outcomes & Impact

  • Enabled real-time tracking of over 100+ vendors

  • Improved visibility into delivery lead time deviations by 30%

  • Facilitated vendor reviews with automated performance scores

  • Supported sourcing strategies by identifying high-performing and underperforming vendors

  • Reduced manual reporting efforts by 70% through automation

Tools and Methodologies

  • Looker BI

  • SQL Pipelines

  • Google BigQuery

  • Data Source: Excel

bottom of page