Choosing a Platform for Commercial Interval Data

Interval data is one of the most useful assets a commercial energy customer has, but only once it is clean, complete, and organized. Raw exports from a utility portal are not that on their own; they need to be ingested, checked, reconciled, and analyzed before they can support a decision. A platform, whether a disciplined spreadsheet workflow or dedicated software, is what does that work. This guide explains how to choose one: what data handling to require, what analysis to expect, and what authorization and privacy considerations to keep in mind.

What an Interval Data Platform Is For

The job of an interval data platform is to turn raw meter readings into trustworthy information. Your demand and interval data arrives as a time-stamped series of usage values, and in that raw form it is prone to gaps, offsets, and inconsistencies. A platform ingests that series, verifies it, reconciles it against what you were billed, and presents your load shape in a form you can actually reason about.

Everything downstream depends on that foundation. Whether you are trying to understand commercial demand charges, price a supply contract, or validate a bill, you are relying on the interval data being correct. A platform that gets ingestion and reconciliation right earns its place; one that skips those steps produces confident-looking analysis on unverified numbers.

Data Ingestion and Reconciliation

The first thing to evaluate in any platform is how it handles the data itself, because this is where most problems originate.

Ingestion

The platform has to reliably take in your utility's data. Both ComEd in northern Illinois and Ameren Illinois in central and southern Illinois provide interval data for commercial accounts, and a platform should handle the formats and delivery methods your utility uses. If you operate multiple sites, ingestion needs to work across all of them without manual reformatting for each meter.

Reconciliation

This is the step that separates a serious tool from a dashboard. Interval exports commonly contain gaps where readings are missing, duplicate or overlapping intervals, time-zone offsets that misplace usage relative to peak periods, and unit inconsistencies. The interval totals also do not always match the totals your utility billed. A good platform reconciles the interval data to billed kWh, so you know the series is complete and correct before you use it. Never make a decision on interval data that has not been reconciled; an unverified peak or an export artifact can send you optimizing against a pattern that is not real.

Data hygiene over time

Beyond the initial load, the platform should keep the data clean as new intervals arrive, flag when readings are missing or look anomalous, and let you trace any figure back to the underlying meter. Data that silently degrades over time is worse than no data, because it looks authoritative while being wrong.

Load-Shape Analysis

Once the data is trustworthy, the platform's analytical job is to make your load shape legible. The core question interval data answers is when you use energy, and the platform should make that easy to see.

Useful analysis includes clear views of daily and seasonal load shape, identification of when and how large your peaks are, comparison across days, weeks, or sites, and the ability to relate usage to the periods that matter for cost. In the ComEd and PJM zone, that includes the peak hours that set the capacity tag; for Ameren Illinois in MISO, it includes that market's own demand and peak structure. The platform does not have to make these decisions for you, but it should surface the patterns clearly enough that you and your facility operators can investigate them.

A caution worth building into any analysis: a pattern in the data is a hypothesis, not a conclusion. If the platform highlights a recurring afternoon peak, the next step is to confirm with operators what is actually running then, not to assume. The best platforms make it easy to move from "here is a pattern" to "here is what caused it" rather than presenting the pattern as an answer. This is exactly the kind of investigation that feeds demand management and, in turn, commercial energy procurement, where an accurate load shape lets suppliers price your actual usage rather than a generic assumption.

What to Look For

Pulling the criteria together, a sound evaluation weighs a handful of factors and matches them to your situation.

• Reliable ingestion of your utility's data format across all your sites and meters.
• Reconciliation to billed usage, so the data is verified before analysis. Treat this as non-negotiable.
• Clear load-shape and peak analysis that surfaces when energy is used and makes patterns easy to investigate.
• Traceability, so any figure can be traced back to the meter and the underlying interval.
• Scale that fits you. A single simple site needs far less than a multi-site portfolio with complex loads. Match the sophistication of the tool to the size of the problem rather than over-buying capability you will not use.
• Fit with your other work, such as connecting cleanly to a commercial utility bill review or supporting the analysis behind a commercial energy audit.

Sophistication is not the same as value. The right platform is the one that keeps your data trustworthy and your load legible at the scale you actually operate, not the one with the most features.

Privacy and Authorization

Because interval data is detailed information about your facility, how it is accessed and stored matters.

Interval data belongs to the account holder. You can retrieve it yourself or authorize a third party, such as a supplier, broker, or advisor, to access it on your behalf. Any platform or provider that pulls your data should do so under an authorization that you grant and can revoke, and should be clear about how the data is stored, who within the provider can see it, and what happens to it if you end the relationship. Detailed usage data can reveal operating patterns, occupancy, and production schedules, so treat access to it with the same care you would apply to other sensitive business information.

Practically, confirm the current data-access and authorization process directly with your utility, since the mechanisms and any required forms change over time and are best taken from the primary source. Understand what you are authorizing before you grant it, keep track of who has access, and revoke access you no longer need.

Choosing Well

A good interval data platform is, at its heart, a discipline: ingest the data reliably, reconcile it to what you were billed, make the load shape clear, treat patterns as hypotheses to confirm, and control who can see the data. Whether that discipline lives in dedicated software or a well-built workflow matters less than that it is actually applied. Choose the tool that enforces those habits at the scale you operate, and the interval data you already own becomes a foundation you can trust for managing demand, buying supply, and checking your bills.

Sources

• ComEd
• Ameren Illinois
• Illinois Commerce Commission

This guide explains how to evaluate a platform for handling commercial interval data. It does not endorse specific products or quote prices; the right choice depends on your sites, load complexity, and how you use the data.