Vendor Scorecard: Redesigning a legacy supplier performance workflow into NIQ standards

Modernized a legacy Precima scorecard into the NIQ design system while prototyping comparison features that helped clients evaluate supplier performance more clearly.

Partner score — P&G
Vendor compliance scorecard overview
Supplier performance chart

Overview

Global retail ecosystems rely on hundreds of vendors, each with different data standards, timelines, and reliability. This fragmentation often leads to misaligned expectations and blame loops. The Vendor Scorecard was designed to bridge those silos — aligning teams on a unified view of performance and creating measurable trust between vendors and retailers.

Global retail ecosystems rely on hundreds of vendors, each with different data standards, timelines, and reliability. This fragmentation often leads to misaligned expectations and blame loops.

The Vendor Scorecard was designed to bridge those silos — aligning teams on a unified view of performance and creating measurable trust between vendors and retailers.

Global retail ecosystems rely on hundreds of vendors, each with different data standards, timelines, and reliability. This fragmentation often leads to misaligned expectations and blame loops.



The Vendor Scorecard was designed to bridge those silos — aligning teams on a unified view of performance and creating measurable trust between vendors and retailers.

TL;DR

The Problem

Vendor and supply chain teams were working from fragmented reports, inconsistent KPI definitions, and manual spreadsheets — making supplier reviews slow, reactive, and hard to trust.

The Insight

The core issue wasn’t missing data. It was missing confidence in how performance was calculated. Teams needed transparent scoring, shared definitions, and a faster path from summary to root cause.

The Solution

I designed a unified Vendor Compliance Scorecard that brought KPI health, trend comparisons, and drill-down evidence into one review-ready workflow — helping teams move from reconciliation to action.

The Impact

60% less manual reporting, aligned regional definitions, and better retailer-vendor decision-making. 

TL;DR

The Problem

Vendor and supply chain teams were working from fragmented reports, inconsistent KPI definitions, and manual spreadsheets — making supplier reviews slow, reactive, and hard to trust.

The Insight

The core issue wasn’t missing data. It was missing confidence in how performance was calculated. Teams needed transparent scoring, shared definitions, and a faster path from summary to root cause.

The Solution

I designed a unified Vendor Compliance Scorecard that brought KPI health, trend comparisons, and drill-down evidence into one review-ready workflow — helping teams move from reconciliation to action.

The Impact

60% less manual reporting, aligned regional definitions, and better retailer-vendor decision-making. 

  • 25%

    Audit prep time reduced

    Evidence-backed reporting cut manual review effort and reduced spreadsheet dependency.


    Ops efficiency

  • $820K

    Revenue risk surfaced earlier

    The scorecard highlighted vendor issues sooner, helping teams identify commercial risk before escalation.

    Business impact

  • 15%

    Supplier OTIF improved

    Clearer visibility into vendor performance made quality and timing issues easier to address.


    Supplier performance

  • $22.5K / qtr

    Quarterly audit cost savings

    Standardized reporting reduced manual audit effort and improved meeting-readiness across teams.


    Cost savings

25%

Audit prep time reduced

Evidence-backed reporting cut manual review effort and reduced spreadsheet dependency.


Ops efficiency

$820K

Revenue risk surfaced earlier

The scorecard highlighted vendor issues sooner, helping teams identify commercial risk before escalation.

Business impact

15%

Supplier OTIF improved

Clearer visibility into vendor performance made quality and timing issues easier to address.


Supplier performance

$22.5K / qtr

Quarterly audit cost savings

Standardized reporting reduced manual audit effort and improved meeting-readiness across teams.


Cost savings

Duration

  • 3 months

My Role

Lead Product Designer

Team Role

  • 2 Product Managers
  • 2 BI Developers
  • 2 Data Scientists
  • 3 Engineers

Target Audience

  • Vendor Managers
  • Retail Category Teams
  • Supply Chain Operations

Scope

Research, UX, UI, Prototyping, Testing

Tools

  • Figma
  • Excel
  • Highcharts
  • Jira

Industry

  • Retail supply chain
  • Vendor performance management

Platform

Web (Desktop-first)

Users Impacted

Used by regional vendor and retail teams during recurring performance reviews

Inventory Managed

Designed to support standardized supplier evaluation across multiple regions

The Challenge

Evolving a legacy supplier scorecard into a more modern, comparison-ready experience

Evolving a legacy supplier scorecard into a more modern, comparison-ready experience

The supplier scorecard already existed in the older Precima environment, but its structure and presentation no longer matched the direction of NIQ’s newer design standards. At the same time, business stakeholders wanted to demonstrate more advanced comparison functionality to clients — including side-by-side chart comparison and clearer sparkline labeling.

The challenge was therefore twofold: redesign the legacy scorecard into a more consistent NIQ experience, and prototype new comparison patterns that could better support client review conversations.

  • Supply Chain / Reports / Catalogue

  • Supply Chain / Reports / Catalogue

  • Supply Chain / Reports / Catalogue

  • Supply Chain / Reports / Catalogue

  • Supply Chain / Reports / Catalogue

  • Supply Chain / Reports / Catalogue

Supply Chain / Reports / Catalogue

Business Requirement

My task was to redesign the legacy supplier scorecard using NIQ design standards and create a prototype that demonstrated comparison functionality for clients — including chart comparison patterns and sparkline label interactions.

The goal was to make the scorecard feel more modern, more consistent, and more effective for performance review conversations.

Standardize the
experience

Standardize the experience

Bring the legacy scorecard into NIQ design patterns and visual standards.

Improve comparison workflows

Support side-by-side chart comparison and clearer metric interpretation.

Prototype for client
conversations

Prototype for client conversations

Use interaction concepts like sparkline labels to communicate future product value.

Business requirements and KPI logic

Design Principles

Principle → interface behavior → proof

01

Aligned

Bring the experience into NIQ standards — evolve beyond Precima patterns.

Interface behavior

Shared KPI chrome, spacing, and NIQ Discover visual language.

NIQ · KPI summary

OTIF

96%

Fill

94%

Compl.

OK

Risk

2

02

Comparable

Make supplier performance easier to compare period-over-period.

Interface behavior

Inline prior / YoY / peer-set comparison before deeper drill.

Period comparison

OTIF96.294.8
Fill rate93.195.0
Critical25
03

Communicable

Prototype for clearer client conversations and QBR packaging.

Interface behavior

Evidence packet: KPI context + filter state + next action.

Review packet

KPI context
Filter state
Evidence rows
Next action

Research & Insights

To redesign the scorecard effectively, I looked beyond the interface itself. I reviewed the legacy reporting structure, business requirements, metric definitions, and workflow patterns to understand how users moved from high-level KPI monitoring into comparison, investigation, and detailed validation.

The goal was not simply to modernize the UI, but to clarify how dense supplier-performance data should be structured for faster review, deeper comparison, and more confident decision-making.

Information Architecture & User Flows

The scorecard needed to support three behaviors: first-time orientation, repeat monitoring, and deep investigation.

Rather than treating every user the same, I structured the experience around how people actually moved through the report. New users needed a clear path from KPI summary to deeper evidence. Returning users needed to quickly check what changed. Power users needed faster filtering, richer comparison, and detailed validation.

This led to a layered information architecture built around four core views: Overview, Performance, Trends, and Compliance Details. Together, these views supported a consistent progression from high-level scanning to focused comparison, then into evidence-backed investigation.

Designed to help first-time users understand the report structure, review active filters, scan top-level KPIs, and move into supporting evidence only when needed.

Optimized for deeper analysis through faster filter refinement, multi-dimensional comparison, tooltip-based interpretation, and detailed validation in compliance views.

Built for repeat monitoring, helping users resume context quickly, compare periods, review key changes, and validate whether follow-up action was needed.

The architecture was designed to support different levels of familiarity while keeping the reporting flow consistent: scan → compare → investigate → validate.

KPI and Reporting Architecture

The redesign needed to support more than a visual refresh. It had to organize executive KPI summaries, comparison analysis, trend evaluation, and detailed validation into a structure that felt clear, layered, and review-ready.

Core decisions

A

Executive KPI Summary

Surfaced high-level signals like OSA rate, missed sales, flags, value sales, and operational health.

B

Comparison and Trend Analysis

Supported current vs previous period review, standard vs promo analysis, and comparison across performance dimensions.

C

Detailed Validation

Connected summary signals to geo analysis, compliance details, root causes, and tabular evidence.

Low-Fidelity Concepts and Iterations

Before moving into high-fidelity reporting screens, I explored how the scorecard should be structured at a lower level — from KPI grouping and chart hierarchy to comparison layouts and detailed evidence views.

These concepts helped test how users would move between summary signals, trend analysis, and tabular validation. The goal was to find a structure that felt modular, scalable, and easier to interpret before refining it into the final NIQ Discover-style reporting experience.

Layer 01

KPI-First

Strongest emphasis on executive KPI summary at the top, optimized for quick orientation.

KPI-First low-fidelity wireframe
Why it didn’t win

Too summary-heavy for deeper comparison and investigation.

Convergence

After exploring multiple directions, I converged on a more balanced reporting model that combined the strengths of each concept without overcommitting to any single one.

The KPI-first concept improved top-level orientation, but pushed deeper comparison too far down. The comparison-first concept made trend analysis stronger, but weakened quick scanability. The investigation-first concept brought evidence forward, but felt too deep too early for first-pass review. The modular reporting direction provided the strongest foundation because it created a more scalable structure across summary, comparison, and detailed validation.

The final direction moved toward a layered reporting flow: orient first, compare second, investigate third, and validate with detailed evidence last. This structure aligned better with how users actually consumed the scorecard — starting with high-level health signals, then moving into period comparison, trend interpretation, and deeper drilldown only when needed.

KPI-First

Executive summary stayed first — orientation before analysis.

KPI-First scorecard wireframe
Kept

Clear executive summary and stronger top-level orientation.

Comparison-First

Trend and period analysis moved higher in the workflow.

Comparison-First scorecard wireframe
Kept

Trend and period analysis moved higher in the workflow.

Investigation-First

Evidence stayed reachable without owning the first screen.

Investigation-First scorecard wireframe
Kept

Evidence and detailed validation remained essential.

Modular Reporting

The system spine that made summary → compare → investigate scalable.

Modular Reporting scorecard wireframe
Kept

A more scalable, system-friendly structure across report modules.

Final NIQ Discover Experience

The final direction translated the scorecard into a more structured NIQ Discover-style reporting experience — balancing executive KPI visibility, comparison workflows, trend analysis, and detailed evidence views within one system.

Executive KPI Overview

Surfaced top-level performance signals such as OSA rate, missed sales, flags, and value sales for faster orientation.

Comparison and Trend Analysis

Supported comparison across periods and performance dimensions, helping users understand what changed and where deeper investigation was needed.

Trends Views

Supported comparison across periods and performance dimensions, helping users understand what changed and where deeper investigation was needed.

Compliance Details

Enabled evidence-backed validation through detailed records, sorting, filtering, and drilldown-ready tables.

Impact & Outcome

The redesign created a more structured reporting workflow across summary, comparison, and validation. Rather than functioning as a single dashboard, the scorecard supported recurring supplier-performance reviews with clearer scanability, stronger comparison, and deeper investigation.

4+

Regional teams

Adoption

Adopted across recurring vendor review workflows, helping standardize how performance was monitored.

50+

Stakeholders

Usage

Used by recurring vendor, retail, and supply-chain stakeholders during review conversations.

50+

Stakeholders

Usage

Used by recurring vendor, retail, and supply-chain stakeholders during review conversations.

25%

faster

Ops efficiency

Reduced manual prep and made summary-to-evidence review more efficient.

25%

faster

Ops efficiency

Reduced manual prep and made summary-to-evidence review more efficient.

10+

Metrics

Reporting depth

Surfaced business-critical measures such as OSA, missed sales, units, vendor risk, and issue status in one reporting model.

10+

Metrics

Reporting depth

Surfaced business-critical measures such as OSA, missed sales, units, vendor risk, and issue status in one reporting model.

Validation

Testing whether the reporting structure actually worked

We explored three main paradigms
for the dashboard before
converging on a hybrid approach.

The final direction was shaped through iterative review and feedback on how the scorecard supported real reporting behaviors. The strongest signals were consistent: users needed faster top-level orientation, comparison had to become more visible, and detailed tables still needed to remain accessible for validation.

Rather than validating a single screen in isolation, the focus was on whether the overall reporting flow worked — from KPI summary, to comparison, to evidence-backed follow-up.

The evolving structure made the scorecard easier to scan at the top level while still supporting deeper analytical follow-up.
Jimmy MartinsJimmy Martins — Director of Design, NIQ

What improved

Top-level scan got faster without skipping real work.

Zoomed Compliance Levels KPI strip
Insight

The summary layer became easier to scan. KPI grouping and status blocks made it clearer what needed attention first, without forcing users into detailed analysis too early.

What feedback reinforced

Comparison had to sit higher in the reporting flow.

Insight

Comparison had to be more visible in the workflow. Trend and period-based analysis became more useful once it moved higher in the reporting structure instead of being buried below summary.

What stayed essential

Detailed evidence still closed the loop.

Insight

Detailed tables and compliance views remained critical. Even with stronger overview and trend views, users still needed evidence-backed records to validate what changed and why.

Detailed views remained essential for validating performance shifts, so the final structure kept evidence accessible without making the overview too dense.
Mayukh RMayukh R — Retail Category Manager, Walmart

Workflow decisions

Summary → compare → validate → align

The vendor scorecard follows one decision path — from KPI summary through comparison, evidence validation, and stakeholder alignment.

01

Scan scorecard summary

DecisionStart on the KPI health layer — orient on compliance status, critical flags, and regional performance before deeper comparison.

02

Compare performance

DecisionShift into period-over-period comparison — surface trend changes early so users interpret direction before committing to investigation.

03

Validate evidence

DecisionDrill into validation detail — keep audit-ready evidence accessible so supplier and retailer teams trust the same source of truth.

04

Align stakeholders

DecisionExport findings for QBR or escalation — package KPI context, comparison shifts, and supporting evidence in one review-ready artifact.

Reflection

What this work changed in my practice

Redesigning the vendor compliance scorecard reinforced how layered reporting, comparison timing, and accessible evidence shape trust in supplier performance workflows.

Structure complexity, don't remove it

In complex B2B tools, clarity comes less from removing complexity and more from structuring hierarchy logic, permissions, and analytical continuity well.

Exception-first beats data-first

Defaulting to items needing attention now — stockout risk, velocity anomalies, DC concentration — reduced time-to-diagnosis versus legacy full-table entry.

Context must survive drill-down

Preserving product, store, DC, and period context across tabs stopped analysts from rebuilding the investigation path on every click.

Trust is a UI problem

Confidence states, escalation paths, and exportable snapshots matter as much as the charts — operational trust is designed, not assumed.

Next Case Studies

Inventory Efficiency Report

Command-center experience that reduced issue detection time by 60% and surfaced $2.1M in stockout risk.