KPI migration

KPI migration commonly refers to the process of moving key performance indicators (KPIs) from one system, data model, or reporting environment to another while preserving their definitions, calculations, and operational meaning.

What KPI migration includes

In industrial and manufacturing environments, KPI migration typically involves:

• Inventory and mapping of existing KPIs such as OEE, yield, scrap, on-time delivery, and backlog across MES, ERP, QMS, and data warehouse tools.
• Translating KPI definitions into a new data model, database schema, or analytics platform, including how inputs (tags, transactions, quality records) are sourced and aggregated.
• Reimplementing calculations and logic in the target system (for example, moving from spreadsheet-based KPIs to an MES, BI tool, or data lakehouse).
• Validating and reconciling results between old and new environments to ensure that KPI values, thresholds, and trends remain consistent and trustworthy.
• Updating visualizations and workflows such as dashboards, scorecards, shop-floor displays, and management reports that consume these KPIs.

KPI migration can occur during MES or ERP upgrades, consolidation of plants into a common reporting model, introduction of a centralized data platform, or replacement of legacy reporting tools.

What KPI migration does not include

KPI migration is distinct from:

• Defining new KPIs from scratch, although gaps or inconsistencies may be discovered and addressed during migration.
• Business process redesign, such as changing production scheduling or quality workflows. Those changes may trigger KPI migration but are separate activities.
• Simple data backup or replication that copies raw data without re-establishing KPI logic and governance.

Operational perspective in manufacturing

From an operational standpoint, KPI migration often touches:

• OT and MES data, including machine states, downtime codes, and production counts feeding OEE and throughput metrics.
• ERP and supply chain data, such as work-order status, purchase orders, and delivery performance feeding supplier scorecards and on-time delivery KPIs.
• Quality systems, including nonconformance, rework, and scrap records feeding COPQ, defect rates, and customer complaint KPIs.
• Governance and documentation, where KPI definitions, owners, calculation rules, and data lineage are documented or revised during the migration.

Common confusion

KPI migration is sometimes confused with:

• KPI redesign or rationalization, which focuses on choosing which KPIs to use and how many. KPI migration is about transporting and re-establishing KPIs, though rationalization may occur as a side effect.
• System migration (for example, moving from one MES to another). System migration is broader and covers all data and functions; KPI migration focuses specifically on performance metrics and their implementation in the new environment.

In regulated and audited environments

In regulated manufacturing, KPI migration commonly includes retaining evidence of how KPIs were defined before and after migration, documenting changes in formulas or data sources, and ensuring that historical KPI trends remain interpretable when systems or data platforms change.