Power BI Scorecards + WPI

Each CDMO has its own PSQDC scorecard. The sponsor has one integrated WPI.

Standard KPI definitions, thresholds, weighting, and recovery-to-target actions reduce subjectivity and create a shared fact base for sponsor/CDMO performance conversations.

Integrated Visibility

24/7 performance visibility across the external manufacturing network.

Power BI integrates scorecard data from Excel workbooks, exported CDMO application reports, and direct API connections where available. Sponsor leaders can see the portfolio-level WPI, then drill down to CDMO, site, product, program, KPI, recovery action, and owner.

Power BI quality scorecard with weighted performance index trend

CDMO DrilldownCDMO-1CDMO-2CDMO-3CDMO-4

Data architecture

Power BI: WPI rollups, trend views, partner comparisons, and recovery-to-target dashboards.
Data sources: Excel, CDMO exported reports, SharePoint/Teams files, and direct API feeds where available.
Scorecard structure: each CDMO has a PSQDC scorecard; sponsor has consolidated WPI and drilldown.
Thresholds: common green, blue, yellow, and red rules reduce interpretation gaps.
Recovery: at-risk KPIs connect to owners, due dates, mitigation actions, and escalation logic.

Scorecard Domains

Performance comparison without flattening partner context.

People / Partnership

Governance participation, action closure, escalation behavior, responsiveness, and team effectiveness.

Safety

Safety events, inspection findings, campaign readiness, EHS escalations, and operating discipline.

Quality

Batch release, deviations, CAPA, complaints, audits, training, document control, and right-first-time trends.

Delivery

Schedule adherence, milestone performance, release cycle time, shipment performance, and recovery-to-plan.

Materials Management / S&OP

Demand/supply alignment, materials readiness, inventory visibility, capacity, campaign planning, and continuity risk.

Financial

Budget, PO coverage, change orders, invoice accuracy, milestone payments, and cost of poor quality.

Innovation / CI

Improvement roadmap, cycle-time reduction, quality event reduction, automation, knowledge transfer, and partner development.

Risk and Continuity

Open risks, risk severity, mitigation progress, alternate supply, BCP readiness, and executive escalation triggers.

WPI Governance

Weighting, thresholds, data refresh cadence, ownership, signoff, and monthly performance review routines.