Kenvue - Vendor Risk & Performance Dashboard

Overview

Kenvue's Real Estate function manages vendor relationships and service contracts across 10 manufacturing and distribution sites globally. With contracts spanning multiple categories — from facility services to building automation and security — the team needed a structured way to monitor the supplier portfolio, track contract lifecycle, and anticipate renewal risks before they became operational issues.

To support this need, I designed a Power BI dashboard focused on vendor performance, contract value visibility, and proactive risk management. The goal was to move the RE team from scattered contract data to a clear, decision-ready view of the entire supplier ecosystem.

‍

‍

The Challenge

Managing vendors across multiple sites and regions involves tracking several dimensions simultaneously: contract values, expiry timelines, payment status, supplier KPIs, and renewal priorities. The main challenge was not just aggregating this data, but structuring it in a way that allowed the team to act quickly and with confidence.

Key reporting needs included:

• monitoring total active contract value and spend by category
• tracking supplier performance across on-time delivery, quality, and compliance
• identifying contracts expiring within 90 days requiring immediate action
• visualizing a risk matrix combining contract value and days to expiry
• controlling overdue invoices and YTD savings vs budget

The dashboard had to serve both an executive audience — needing a high-level portfolio view — and an operational one, requiring enough detail to manage individual vendors and contracts.

‍

‍

My Role

I worked on the project as a Power BI and data management specialist, covering the full analytical and design workflow.

My contribution included:

• designing the data model (star schema with fact and dimension tables)
• structuring the SQL analytical layer for data extraction and quality control
• building the DAX measure library for KPI calculation and time intelligence
• designing a three-page dashboard experience balancing clarity and depth
• translating RE business requirements into a usable, decision-oriented reporting tool

‍

The Solution

The result was a Vendor & Contract Management Dashboard structured across three pages, each addressing a distinct business need.

The dashboard combines:

• KPI cards for immediate portfolio health monitoring
• spend analysis by category and region
• supplier scorecard with conditional formatting for performance tiers
• top/bottom performer ranking with trend analysis over time
• contract risk matrix mapping value against days to expiry
• renewal pipeline with expiry timeline and risk classification

This structure allows stakeholders to move quickly from strategic overview to operational detail:

• Which suppliers are underperforming against KPI targets?
• Which high-value contracts are approaching expiry without auto-renewal?
• Where is spend concentrated across categories and sites?
• Which vendors require immediate intervention or review?

‍

‍

Dashboard Structure

The dashboard is organized into three pages. The Executive Overview provides a portfolio-level summary with spend trends and contract status. The Vendor Performance page scores every supplier across delivery, quality, and compliance KPIs, enabling direct comparison and trend monitoring. The Contract Risk & Renewal page combines a risk matrix and expiry timeline to help the RE team prioritize renewal actions before contracts lapse.

‍

Analytical Value

From a business perspective, the dashboard supports several critical decisions:

• identifying suppliers at risk of contract non-renewal in high-value categories
• monitoring budget adherence through YTD invoiced vs contracted value
• detecting overdue invoice exposure before it impacts operations
• comparing supplier efficiency across sites and regions
• creating a shared performance view for RE, procurement, and finance stakeholders

Rather than functioning as a static report, the dashboard is designed as a proactive management tool — built to surface risk before it becomes a problem.