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.