sales@agilitz.com
Client
A global medical devices manufacturer consolidating data from SAP and Dynamics 365 into a single enterprise data lake.
The challenge
Teams needed shared KPIs across two ERP estates. Differences in data models and business definitions made it difficult to compare results consistently.
What we delivered
- Worked with business teams to define the questions the programme needed to answer and turn them into consistent KPI definitions.
- Traced the data required for those KPIs back to SAP and Dynamics 365 and aligned it to a shared reporting model.
- Documented calculation rules and the underlying data relationships so teams could understand how each KPI was produced.
Benefits and outcomes
- Delivered business KPIs using data from both ERP systems in the consolidated data lake.
- Gave business teams a consistent way to compare performance across the two estates.
- Made the connection between KPI calculations and their source data traceable.