Taming the Data Chaos through Business Analytics - A Roadmap for Enterprise Decisions


  • Aditya Ramamurthy - Hazen and Sawyer

Simple data analytics reveal basic insights; more sophisticated analytics, applied to data that has been pooled into a “data lake” with data from external and enterprise sources allows utilities to unearth deeper insights that will help to optimize performance. Because of the growing volume, complexity and strategic importance of asset management data, it is no longer desirable or even feasible for each department/ unit/division/function within a utility to manage this data by itself, or to build its own data analytics capabilities.

To get the most out of the new data resources, utilities are creating dedicated data groups that are potentially embedded within the core asset management program team to consolidate data collection, aggregation and analytics.

Recently, advances in technology have revolutionized data and performance reporting so that users (with limited IT development expertise) can perform data mining and develop high impact visuals for performance reporting. Water and Wastewater Utilities are implementing Business Intelligence (BI) frameworks to track and report key asset management performance indicators and other data analytics.

Benefits of this reporting framework include:
• Eliminates the reliance on core IT developers to develop and manage reporting frameworks as BI is now integrated with common applications, putting the non-IT user in a position to perform complex data analysis and develop aesthetically-pleasing visualizations
• Significantly reduces development cost and level of effort
• Through the concept of data “lakes”, data models can be constructed using data from various sources (CMMS, GIS, SCADA, project management, financial and customer information systems) with ease
• Eliminates the extensive costs and need for complex and disparate system integration that is typically required to connect data for effective performance reporting
• Reduces the time to develop high impact visualizations to hours or days, rather than weeks, months, and years
• Complete transferability to mobile devices for use at meetings and workshops

This presentation will discuss the asset management KPI frameworks (2 case studies) that have been implemented by utilities for effective integration, tracking and reporting of various data within their asset management programs.

For more information, please contact the author at aramamurthy@hazenandsawyer.com.

Hear about new publications with our email newsletter

We will never share your details with anyone else.


Newsletter Newsletter

Horizons Fall 2017 (pdf)

Horizons showcases significant water, wastewater, reuse, and stormwater projects and innovations that help our clients to achieve their goals, and can help you achieve yours. Articles are written by top engineers and process group leaders, demonstrating and explaining the beneficial application of a variety of technologies and tools.

View previous issues »