An Energy Dashboard for Cities and Campuses: KPIs That Drive Action

Start with the decision, not the interface

The most common failure of municipal and campus energy programs is choosing a polished platform before deciding what it is for. A dashboard that changes no one's behavior becomes an expensive reporting screen. Before selecting metrics, write down the recurring decisions: when to shut down heating in an unused wing, which building to retrofit first, where to set tariffs or reduction targets, and which incentive program to run for residents.

Real city deployments show the value of tying metrics to goals. Raleigh's community climate action dashboard is built around the council's goal to cut community greenhouse gas emissions 80 percent by 2050 and shows progress across transportation, renewable energy, building efficiency, waste, and more, explicitly so that residents and officials can make decisions about projects, investments, and everyday actions. If you cannot produce an equivalent list of decisions with an owner for each indicator, build that list first — it will take less time than rebuilding the system.

A workable rule: one metric, one named owner, one type of decision. If you cannot say who will act and what they will do when a number changes by ten percent, reformulate or remove that metric from the top screen.

• List five to ten operational decisions that recur weekly or monthly.
• Assign an accountable person and a response time to each.
• Show on the first screen only the KPIs tied to those decisions.
• Keep supporting data in a second layer for deeper analysis.

Three useful forms of a KPI

The U.S. Department of Energy's eGuide for ISO 50001 describes three forms of energy performance indicators, and the same logic transfers cleanly to a city or campus. A single metric — total electricity or heat consumption — works when conditions are stable and few variables change, such as a warehouse with fixed lighting and no heating. But once weather, occupancy, or operating hours fluctuate, raw consumption stops being informative.

The second form is an intensity ratio: kilowatt-hours per square meter of conditioned floor area, or energy per user. Intensity is what allows honest comparison across buildings and months; universities such as Bocconi publish energy use per square meter of built space among their key environmental performance indicators. The third and most accurate form is a model, typically built by regression, that accounts for several variables at once (temperature, occupancy, hours) and separates real savings from weather effects.

A mature dashboard uses all three layers: the single metric tracks the budget and overall trend, the intensity ratio makes objects comparable, and the model produces a defensible estimate of the effect of each measure. Start simple, but design the structure so normalization and modeling can be added later without rework.

• Single metric — budget control and overall trend.
• Intensity ratio — fair comparison across buildings, districts, and months.
• Multi-variable model — credible attribution of savings to specific actions.
• Document the calculation method and revisit it when assets change.

Normalize before you compare

The surest way for an energy dashboard to mislead is to compare unadjusted numbers across periods. A mild winter lowers heating demand without a single efficiency measure, while a cold one hides the effect of work already done. To avoid this, normalize by heating and cooling degree-days, floor area, number of users, and actual operating hours of each asset.

The international standard ISO 50006:2023 supplies the methodological frame for this work. It guides organizations on how to establish, use, and maintain energy performance indicators (EnPIs) and energy baselines (EnBs) to evaluate performance and demonstrate improvement. The core idea is to fix a baseline before a program begins and compare only against it rather than against an arbitrary 'previous year,' revising the baseline whenever the asset portfolio, building use, or operating regimes change materially.

Leading campuses push the same discipline to fine granularity. The Hong Kong University of Science and Technology runs more than 1,400 smart meters across 20 buildings feeding a public dashboard, and divides the campus into 104 energy zones so consumption can be monitored precisely and wastage located quickly. For a city, the analogue is splitting the territory into districts and economic sectors, as Raleigh does across transport, buildings, and renewable energy.

• Agree on the normalization method before launch.
• Use degree-days for heating and cooling.
• Revise the baseline when the asset portfolio changes.
• Split the territory into zones to localize anomalies fast.

Benchmark against real peers

Even perfect year-over-year trends cannot tell you how well you perform relative to comparable organizations, so pair the internal trend with external benchmarks. Since 2020 the U.S. EPA's Higher Education Benchmarking Initiative (HEBI) has given colleges and universities free scorecards showing how their campus buildings' energy and water performance ranks against peers; the second round covered nearly 100 campuses from more than 50 institutions. Institutions use the results to spot where they lag and where to direct effort.

Cities can rely on harmonized indicator sets instead of starting from scratch. The European CoME EASY project, built on ISO 50001 principles and the Covenant of Mayors approach, combined KPIs from major international initiatives into a single database with mandatory and optional fields across sectors: strategy and planning, governance, energy and climate, and mobility. Such a standardized structure lets a city collect data once and reuse it for internal management, external benchmarking, and multiple reporting commitments without duplicate collection efforts.

Choose benchmarks for comparability: building type, climate, and use of space. Do not compare a laboratory to a dormitory or an industrial district to a residential neighborhood — the result will be meaningless and will erode trust in the dashboard.

Match metric and cadence to the audience

One dashboard cannot serve an operator, a manager, and the public equally well. An operator needs hourly and daily readings by zone to find anomalies quickly; at HKUST the campus is deliberately split into energy zones precisely to enable timely interventions when abnormal consumption appears. A manager needs monthly cost and emissions trends for budget and priority decisions. A public interface should show simple quarterly and annual summaries, or it will be ignored and breed cynicism.

Public visibility disciplines performance: an open city or campus dashboard makes goals measurable and creates outside pressure to deliver. It also raises the stakes for data quality and methodological clarity, because every error is visible. HKUST staff note that even with careful data cleaning, errors and gaps remain and that accuracy is higher for landmark buildings, so less prominent sites need extra resampling, error correction, and outlier removal. Any mistake seen by the public undermines trust in the whole system.

Design three layers: an operational layer (detailed, for specialists, updated frequently), a management layer (consolidated monthly views), and a public layer (simple annual or quarterly summaries). Each layer has its own cadence, its own KPI set, and its own access permissions.

• Operational layer: hourly, by zone, aimed at anomaly detection.
• Management layer: monthly energy, cost, and emissions trends.
• Public layer: simple quarterly and annual summaries.
• Assign clear ownership for data quality and published methods.

Data quality and the annual audit

A dashboard built on bad data is worse than none: it breeds false confidence and discredits the energy team's work. Build in validation processes from day one: automatic checks for gaps and outliers, reconciliation with meter readings and billing, a documented error-correction routine, and a change log for the methodology. As HKUST emphasizes, data quality is paramount, and different buildings warrant different maintenance strategies to keep readings reliable.

Revisit the KPI set itself on a regular cycle. Asset portfolios, tariffs, climate targets, and regulations change, and a metric that was useful a year ago can become stale. In the ISO 50001 approach, indicators and the methods for calculating them must be reviewed and updates recorded. A practical rhythm is an annual dashboard audit coupled with the energy policy and baseline review.

Close the loop: for every KPI, define threshold values that trigger a specific action, and verify that the action actually happens. A metric that has never led to a decision within a quarter is a candidate for redesign.