Enhancing Asset Management through Digital Condition Assessment and Data Visualization

Presentation Description: Systematic assessment of water and wastewater pump stations and treatment facilities is both labor- and data-intensive. This presentation explores strategies to streamline data collection and manage information digitally throughout all phases of a condition assessment project. The approach improves efficiency in field data gathering, asset evaluation, and communication of results—supporting capital improvement planning across a range of facility types.

A key innovation was the implementation of a fully digital workflow—from mobile field data collection to real-time cloud-based transmission and centralized analysis. Standardized assessment criteria were developed to evaluate mechanical, electrical, instrumentation and control, and emergency power assets for condition, performance, reliability, and obsolescence. These metrics enabled calculation of the Asset Health Index (AHI), Likelihood of Failure (LoF), and Remaining Service Life, which guided the prioritization of rehabilitation and replacement projects.

The methodology has been successfully applied to both small lift stations and large, complex treatment facilities, demonstrating its scalability and adaptability. A major success of the project was the creation of a Microsoft Power BI dashboard that visualized assessment data, analytical results, and project recommendations. This interactive platform empowers users to explore system health, asset-level insights, and investment planning across the full planning horizon.

The presentation will showcase the methodology, digital tools, and visualization strategies used in the project—demonstrating how a scalable, data-driven approach to asset management accelerates decision-making, enhances transparency, and strengthens long-term infrastructure reliability.