Data & platform.
Green Button, interval data, integrations, data quality and warehousing: the plumbing that moves utility data into the tools you use.
Integrating a utility data API: what the payload should contain and how to build on it
A developer guide to consuming a utility data API: the fields a bill and interval payload must carry, units, idempotency, webhook versus polling, and mapping to warehouse, BI and ERP.
Choosing an energy management information system: a requirements checklist
Requirements for choosing energy management information system software: data acquisition, validation, analytics, integrations, security, scoring, red flags and RFP questions.
Energy data management: what it is, and what a platform has to do
Energy data management for organizations that buy energy: the data types, the lifecycle from collection to serving, what a platform has to do, and how to evaluate one.
Utility bill automation: what it covers, and what to look for
Utility bill automation covers five stages: collection, extraction, validation, workflow and delivery. A buyer's guide to what good looks like at each, with a vendor checklist.
Extracting utility data across mixed commodities at portfolio scale
One bill is easy to read by hand. A portfolio of electricity, gas, water and steam across hundreds of formats is a different problem. Here is why mixed-commodity extraction breaks templates and OCR, and what it actually requires.
Putting Green Button interval data to work: demand management and cost allocation
The monthly bill tells you what you used, not when. Interval data is the when, and Green Button makes it portable. Here is how to turn it into lower demand charges and fair cost allocation.
What "clean, structured utility data" actually requires
Everyone says they want clean utility data. Few can define it in a way another person could check. Here are the specific, testable properties that separate data you can trust from data that just looks tidy.
Energy data management for logistics and warehousing
Warehousing and distribution portfolios have distinctive load profiles and big demand charges. Here is how to collect and use the utility data behind them.
Designing an energy data pipeline from ingestion to insight
The stages, layers, and roles that move utility bills and interval data from raw sources to trusted dashboards, forecasts, and reports.
Energy data governance for multi-site organizations
How large portfolios keep utility data consistent across sites, utilities and commodities: ownership, definitions, quality rules, lineage and access.
Connecting utility data to your energy tools: one clean dataset, many destinations
Energy teams feed utility bills and interval data into benchmarking, feasibility, BI, and emissions tools. The real bottleneck is getting clean, standardized data out of many utilities first. Here is how the shared foundation works.
Building energy and utility dashboards in Power BI from utility data
A practical guide for Canadian energy and facility teams: how to model meter and bill data, avoid the garbage-in problem, choose refresh options, and build Power BI measures that hold up.
Utility data collection for energy consultants and ESCOs
How energy and sustainability consultants collect utility data across many client accounts using authorized connections, Green Button, and bill digitization.
Build vs buy: utility and energy data management
The real cost of building an in-house utility-data pipeline versus buying a platform: labor, maintenance, data quality, and when each choice actually makes sense.
What is an EMIS (energy management information system)?
A plain guide to what an EMIS is and does, how it differs from a BAS/BMS and from ENERGY STAR Portfolio Manager, and why clean data is the prerequisite.
Utility data for multi-site retail portfolios
Hundreds of stores across many utilities and rate structures. How to standardize, benchmark, and allocate energy cost, spot outlier stores, and support ESG for a chain.
Handling customer utility data securely and compliantly
Utility data is personal information. A Canada-first guide to consent, PII, data minimization, encryption, retention, and frameworks like PIPEDA, SOC 2, and ISO 27001.
Interval data vs monthly bills: what each one is good for
Monthly bills settle what you owe; interval data explains why. A practical look at granularity, storage tradeoffs, and when you need 15-minute reads or just the bill.
Building a utility data warehouse for energy and emissions
A practical data model for utility bills and meter reads: accounts, meters, service points, commodities, slowly changing tariffs, lineage, and serving BI and ESG.
A facility manager's guide to utility data
Energy is the largest controllable operating cost in most buildings. This guide shows facility managers how to turn scattered utility data into decisions that cut it.
Offering Green Button Connect My Data as a utility
Green Button Connect My Data lets customers authorize secure, automated sharing of their usage data. Here is what the standard requires and how to implement it well.
Meter data management (MDM) basics for utilities
MDM sits between smart meters and billing, turning raw interval reads into validated data. Here is what an MDMS does, how VEE works, and why data quality matters.
Modernizing a utility Customer Information System (CIS)
A utility CIS runs meter-to-cash, but many were built before smart meters existed. Here is what modernization involves, what drives it, and how to de-risk the move.
Integrating utility data with ERP and accounting systems
How to get clean utility data into your ERP or accounting system: the integration patterns (file, EDI 810, API), what has to be true before you connect, and how allocation works.
Automating utility bill data entry for AP and energy teams
Manual bill keying is slow, error-prone and costly. What it really costs, why utility bills are harder than normal invoices, and how to automate capture and validation.
Utility data formats: EDI 810/867, Green Button, PDF, CSV
A plain guide to the formats utility data actually arrives in: PDF bills, CSV exports, Green Button XML and EDI 810/867, what each one is good for, and where they break.
Energy Dashboards That Drive Action, Not Just Charts
The dashboards people act on share a few habits: the right KPIs, audience-specific views, drill-down to the bill, and trustworthy data underneath.
Normalizing Multi-Meter Energy Data: One Common Basis Across Sites and Commodities
Mixed units, ragged billing periods, and multi-meter buildings break comparisons. Here is how to build one common basis for energy data.
Anomaly Detection on Utility Bills and Meter Data: Catching Errors, Faults, and Leaks Early
Billing errors, tariff changes, equipment faults, and leaks show up in the data first. How rule-based, statistical, and model-based detection catch them.
Automating Utility Data Collection: Portals, APIs, Green Button, and the Gaps Bill Parsing Fills
Portal downloads, utility APIs, Green Button Connect, aggregators, scraping, and PDF parsing compared on coverage, latency, and maintenance cost.
Submetering and Tenant Billing: From Raw Meter Data to Allocatable Records
Submeters generate a flood of raw readings that are useless until they become clean, allocatable records. Here is how to turn meter and submeter data into defensible tenant billing and reporting, the common pitfalls, and the Ontario rules that shape it.
Getting Clean Utility Data Into ESG Platforms and BI Tools
ESG platforms and BI tools are only as good as the utility data behind them. Here is how to deliver structured records with consistent units and periods through APIs and exports, and how to avoid the spreadsheet trap that quietly breaks reporting.
Utility Data Quality: The Hidden Blocker in Energy and GHG Programs
Missing periods, estimated reads, unit mismatches, and broken meter mapping quietly undermine energy and emissions programs. Here is why data quality is the real bottleneck and how to build a validation layer that catches problems before they reach a report.
Green Button Connect My Data (CMD) for Energy Managers and Resellers
Connect My Data gives authorized third parties ongoing, automated access to a customer's utility data. Here is how CMD differs from Download My Data, how the authorization works, and what it enables for analysis and reporting at scale.
How to get your energy data in Ontario: a plain guide to Green Button
Ontario law now requires utilities to hand over your energy data in a standard, machine-readable form. It is called Green Button. Here is what that means in plain terms, how to get your data (or your customers' data) automatically, and what you can do with it.
Getting clean data out of utility bills: manual entry vs OCR vs reasoning
Three ways to turn a stack of utility bills into usable data, and why the difference shows up the moment you scale past a handful of accounts. A practical comparison for anyone tired of re-keying bills.
Why utility bills need reasoning, not OCR
OCR reads characters. Utility data needs a system that understands tariffs, meters and the relationships between fields. Here is the difference, and why it matters for billing accuracy.
Green Button and the standardized-data problem
Green Button promises interoperable energy data. In practice, ingestion is where programs stall. A look at how we normalize XML, PDFs and portals into one model.
Trusted-domain AI: confidence and provenance for energy
General models hallucinate. Energy decisions cannot afford that. How EnergyAI's Knowledge Trust Framework grounds every answer in curated, cited knowledge.
39 articles in Data & platform