Lineage
Trace every KPI back to its source.
Visual lineage from source system through staging, transformation, semantic model, dashboard and the certified KPI.
Procurement Spend · end-to-end lineage
6 steps · refreshed daily 02:00 UTC
Source System
Coupa
Source of truth for POs, invoices and supplier master.
→
Staging Layer
SQL Staging
Nightly extract of POs, invoices, supplier records into raw schema.
→
Transformation
Spend Transformation
Currency conversion, intercompany elimination, GL mapping.
→
Semantic Model
Procurement Semantic Model
Certified business definitions, hierarchies, calculated measures.
→
Dashboard
Procurement Dashboard
Power BI workspace consumed by Finance leadership.
→
KPI
Procurement Spend
Certified KPI reported in monthly board pack.
Lineage details
| # | Step | Description | Owner | Refresh | Status |
|---|---|---|---|---|---|
| 1 | Coupa | Source of truth for POs, invoices and supplier master. | — | Daily | ● Active |
| 2 | SQL Staging | Nightly extract of POs, invoices, supplier records into raw schema. | — | Daily | ● Active |
| 3 | Spend Transformation | Currency conversion, intercompany elimination, GL mapping. | — | Daily | ● Active |
| 4 | Procurement Semantic Model | Certified business definitions, hierarchies, calculated measures. | — | Daily | ● Active |
| 5 | Procurement Dashboard | Power BI workspace consumed by Finance leadership. | — | Daily | ● Active |
| 6 | Procurement Spend | Certified KPI reported in monthly board pack. | — | Daily | ● Active |
Lineage insights
End-to-end refresh
Daily · 02:00 UTC
SLA: T+5 hours from source close
Total steps
6
Data quality
98%
Last validated
2026-05-15