Public Sector / Modern Data Platform

Regional Water Distribution System Enables Real-Time Analytics


Company Overview

Clean water – it’s essential to human health and the health of the planet. Based in the U.S. mid-Atlantic region, one of the world’s largest advanced wastewater treatment facilities provides clean water to nearly a million people, and treats wastewater, returning it to the water cycle, for nearly as many. Radical and rapid technology changes require the water treatment giant to maintain vigilance against potential vulnerabilities in its system. To that end, the utility brought in BlueGranite to build a revolutionary Azure platform that transforms security infrastructure, and furthers advanced analysis, machine learning, and equipment-monitoring capabilities. 

The Challenge

Theutility’s vast freshwater distribution and wastewater treatment system comprises  innumerable pieces of equipment, and thousands of miles of pipes, featuring tens of thousands of sensors generating critical information.Protecting this network and monitoringcapturing, and analyzing the infinite amounts of data it produces, is imperative. 

Like other large-scale utilities and manufacturers, the utility uses an agingSupervisory Control and Data Acquisition (SCADA)systemtomanageits massive network.LegacySCADA systems are simple to operate and easy to repair. Theylink, control,and monitorcomponents and networks for large-scale operations.Buttechnology’s rapid evolution exposed vulnerabilities in these systems.

Because SCADA systems are at the backbone of much of the nation’s infrastructure, securing them from digital attacks and viruses is a priority. Commandeering control of just one device could bring down a whole system. The wastewater treatment utility needed to implement technology that protects it from such emerging threats;a systemthat also fosters agile business evolution. The enterprise-grade Microsoft Azure cloud platform was the perfect fit. 

The Solution

BlueGraniteworked with the utility to design and implement a custom Azure buildout and a custom web app. The app allows end users to bring additional equipment sensors onlineas they become available, into the self-service reporting environment; this allows process engineers to validate that the sensors are configured and functioning correctly before alerting and process controls are triggered. 

BlueGranite used a cloud-based,managedIoT Hubserviceas the conduit betweenthe utility's tens of thousands of equipment sensors and the cloud.The managed Azure service securely scales to millions of connected devices and events per second, allowing the utility to store the vast amounts of data it generates for future exploration. The new infrastructure offers the capability to secure each individual device connected to the network; in the event a device  becomes compromised,it also holds theabilityto shut down individual components, rather than the whole system. 

We createdtwo data load pathwaysone feeds “hot” (or live)data into thenew platformas it’s generated, while a “cold”path feeds in data from the utility’s legacy system (which is still operational during the transition to new technology). The utility can now see all of its data in one place, without having to go back and forth between systems.  

Additional Azure technologies collectsand cleanse and store data at scale, enablingreal-time analytics on the utility’s equipment network. The platform connectsto Power BI foreasy, but secureaccess to dynamic reporting and rich visuals. 

BlueGranitealso designeda web application that monitors equipment temperatures and sends alerts if equipment reaches critical thresholds. It supervises fluctuations; if something exceeds a specific low or high threshold for a defined time period, it alerts the operator in charge notifyingthem what sensor is affected, and what the data values are. This enables rapid response,  and haspotential to save money and equipment.


The Results

Azure and Power BI laythefoundation for advanced analytics,opening up a world of possibility for the water management operation – from predicting maintenance events and preventing early equipment replacement to averting widespreadservice outages orcatastrophes.  

New, near real-time reporting and actionable dashboardsare nowvitaltothe utility’soperations. From the ability to now cost-effectively collect and store mass amounts ofcontinuously generated system data, to the newly implemented web app alerting system, theAzureplatformisrevolutionizingbusiness. 

ThisAzure-based solution provides the scale and analytic capabilities to meetthe utility’sfuture business needs.The solutionwas, in part, designed to address vulnerabilities in the utility’s legacy SCADA system. This approach can translate across industries – particularly those that still rely SCADA architecture, such as manufacturing, gas and oil, power generation and distribution, as well as large-scale facilities like airports andlarge freighterships that use it to oversee mechanical processes.

BlueGranite offers a wealth of resources for those exploring Azure technology. Contact us today to learn more. 


Kickstart Your Digital Transformation With BlueGranite's Business Intelligence Solutions