Following safety incidents, this pipeline operator needed better visibility into risk across 18,000+ miles of infrastructure. The data existed—buried in maintenance logs, inspection reports, incident databases, and compliance systems. But piecing it together took analysts days, and by the time executives saw the full picture, it was already out of date.

Nobody agreed on which metrics mattered. Each department had their own spreadsheets, their own definitions, their own priorities. Before we could build anything, we had to get 10+ stakeholders aligned on what 'risk visibility' actually meant for their business.

We started with interviews, not code. After talking to every stakeholder, we designed 40+ potential metrics, then facilitated workshops where executives debated and prioritized together. Only then did we build—using agile sprints that let us iterate based on real feedback. The result was a dashboard people actually used because they'd helped design it.