Company metrics tree: the full P&L on one canvas

For the same global QSR brand, leadership had a different problem: not a lack of data, but a lack of structure.

Metrics lived in separate dashboards across teams and tools. When revenue dropped or a KPI moved unexpectedly, figuring out why meant jumping between reports, asking analysts, and losing hours before arriving at an answer.

The company needed a single instrument that could show the full hierarchy of business metrics — from EBITDA down to unit-level drivers — and let any stakeholder quickly understand what changed, why it changed, and which part of the business was responsible. Both top-down for leadership reviewing the big picture, and bottom-up for unit leaders investigating their specific area.

• Metrics scattered across dashboards in different teams and tools
• Hours of cross-report navigation just to answer 'why did this move?'
• No shared definitions — same KPI meant different things in different rooms
• Leadership and unit leads didn't share a common view of the business

A custom interactive metrics tree built on Apache Superset — not a standard dashboard layout, but a navigable, zoomable tree that maps the company's full metric hierarchy in one canvas.

Every node shows the current value, MoM and YoY change, with color-coding to surface problems at a glance. Every week, leadership opens the tree at the top of strategic reviews — it takes seconds to see which metrics are green and which need attention.

When something is off, they zoom in on the problem node and drill through to the detailed section. Unit leads use the same view to prepare for those meetings: they know exactly which numbers will be discussed and can come ready with context. Anyone in the company can open the tree at any time and understand where the business stands without asking an analyst.