A Consistent Scorecard Across Every Location

The problem

Each location reported differently, so head office could not fairly compare performance or spot a struggling location until the numbers were already bad, and consolidating the network view was a manual monthly job.

What we did

We standardized KPIs across locations, connected each site's source systems into one model, and built roll-up reporting with drill-down from network to site, plus an AI agent that reviews every location weekly and surfaces the handful worth a phone call.

What we connected

• Per-site POS & booking systems
• The finance system
• Payroll & rota data
• BigQuery
• Looker Studio
• Slack digests

What we automated

• Every site's data collected on schedule
• KPIs calculated once, identically, for all sites
• Network roll-up with drill-down to each location
• A weekly AI review surfacing outliers

Reliability & controls

• Shared metric definitions across the network
• Site data validated before it reaches the scorecard
• Like-for-like comparisons only
• Alerts explained, with the numbers shown