1898 & Co. worked with Ozarks to evaluate potential technology solutions based on the utility’s needs, team capabilities, potential future use cases and cost constraints. Following evaluation, 1898 & Co. designed and implemented a modern data analytics platform in Microsoft Azure using data lake storage and Azure Synapse Analytics.
The goal was to build a cloud-native data platform that allowed Ozarks to ingest and aggregate its meter data on a daily basis.
The initial use case was to gain visibility to data that could validate time-of-use rates, providing clarity on how much impact the rates were having in reducing the utility’s peak load during the day. By validating that data, Ozarks gained additional visibility into other parts of the grid for future analytics use cases.
The initial phase focused on collaborating with Ozarks staff to gain an understanding of existing technology as well as evaluating the needs of future projects beyond the initial use case requirements. This evaluation rolled up to a technology platform recommendation to fit the unique needs of the cooperative.
The second phase involved platform design and deployment of the data in Microsoft Azure using Terraform, an Infrastructure as Code tool. The core of the deployed services was Microsoft Synapse Analytics and Azure Data Lake Storage, creating a highly scalable yet cost-effective platform.
Following platform deployment, 1898 & Co. built out the required pipelines to ingest meter data on a daily basis and created the necessary aggregations to support time-of-use rate analysis. The data feeds and aggregations were then made available to the required stakeholder via Power BI.
The Ozarks team was trained during the duration of the deployment process to gain functionality in managing and interacting with the platform.