Case Study: Saint John Energy Zero30 | Deloitte

How Deloitte used the Awesense Platform to help Saint John Energy assess grid impact from the growing electrification needed to support net zero goals.

BC Hydro
Scope Snapshot
Goal

Enable a centralized, synchronized, and cleansed utility data model populated with Saint John Energy data to facilitate Deloitte’s development of a grid impact model.

The Data
  • GIS (including connectivity)
  • CYME
  • CIS
  • AMI metering
  • Manual metering
  • MV90
Awesense Tools Used
  • Energy Data Model (EDM)
  • Awesense Data Engine (grid and time series VEE)
  • EDM data ingestion APIs
  • EDM data retrieval APIs
  • True Grid Intelligence (TGI) web app

The Challenge

Saint John Energy (SJE) faces the challenge of achieving net-zero emissions by 2030. To analyze the feasibility of this ambitious goal, Deloitte, supporting SJE on the Zero30 program, required fast and easy access to a centralized, synchronized and cleansed utility data model populated with SJE data. You can learn more about why Saint John Energy chose Deloitte here.

The Solution & Results

Awesense helped solve this challenge by providing its advanced energy data management platform to integrate various utility data sources into a unified platform, ensuring the data was reliable and readily accessible for Deloitte’s analytical, modeling and operational needs.

Awesense worked closely with Deloitte and SJE to ingest, cleanse and connect data obtained from multiple SJE source systems — including GIS, AMI, manual and MV90 metering. Awesense’s ingestion framework ensured compatibility and mapping to a shared Energy Data Model (EDM). All time series data were aligned temporally and linked to GIS. Data validation checks were run and outcomes reported and, where possible, automated corrections were applied.

Once such collated, the data was made accessible in a variety of ways, both through the no-code UI of the True Grid Intelligence (TGI) digital twin viewer and through the EDM SQL API. Deloitte was able to easily query data from disparate systems in a unified way and take advantage of the advanced grid tracing functionality included with the EDM APIs, significantly speeding up their development of their grid impact modeling and analytics.

The success of this project led to SJE subsequently engaging Awesense to extend this one-time integration into a full-fledged grid data warehouse implementation featuring pipelines designed to support ongoing daily data refreshes without requiring manual intervention, as well as additional data sources.

Find out more about this particular case study, or contact us for more information on how we help you leverage your data.