Central data repository for cross-channel reporting

Problem

Fragmented Excel work and a legacy, unmaintained BI pipeline. ~100 KPIs with no unified definitions.

What I did

Built a centralized repository as single source of truth. Generalised the terminology to its essence; the same definitions apply across all inventory types. Reduced the KPI set from ~100 to ~50.

Result

One source of truth across inventory and delivery, powering BI, campaign reporting, and the reach forecast.