Machine Learning & AI

State, Local, & Education

Modern Data Platform

Regional Water Distribution System Enables Real-Time Analytics

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 tonearly a million people, and treats wastewater, returning it to the water cycle, fornearly 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 inBlueGraniteto build a revolutionary Azure platformthat transforms security infrastructure,and furthersadvanced analysismachine learning, andequipment-monitoring capabilities. 

Water Treatment

Vast Network, Superior Needs 

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 monitoring, capturing, 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. 

Custom AzureBuild 

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 online, as 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 pathways: one 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.

Ongoing Advantages 

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. 

RESULTS AT A GLANCE

  • Implemented Azure IoT Hub to scale across millions of connected devices and events per second.  

  • Instituted new advanced analytics and machine learning capabilities in a single unified platform that allow for more complex modeling than previously possible. 

  • Azure Stream Analytics works with Azure IoT Hub to enable real-time analytics on IoT devices.   

  • Uncovered additional opportunities, including predictive maintenance. 

  • Built equipment monitoring app with alerting capabilities.  

WANT TO LEARN MORE ABOUT BLUEGRANITE SOLUTIONS?

FEATURED EBOOK

Powe[R] BI: Enhance Your
Microsoft Power BI Experience
with R

As a specialized, open source statistical environment, R
represents the primary analysis language for many data
scientists and statisticians. By extending Power BI with R,
Microsoft has created several opportunities to enhance your
Business Intelligence solutions and visualizations.

Power-BI-Main.png