A common activity for water authorities is the capture and analysis of water quality metrics. Compliance with water quality targets is critical and requires capture of file-based data for analysis, which is often done in spreadsheets in a time-consuming and complex process that is not easily shared with a wider audience nor available in real time.
The objective of OSIsoft PI was to show that file-based data can be automatically loaded into the PI System, the specific water quality analyses automatically performed on the data and ‘live’ results easily provided in a web-based dashboard accessible to all authorized users.
The PI System provides many interfaces including for file-based data. Files can be dropped into a folder or emailed into the PI System, potentially directly from a laboratory service provider. The PI Analyses Engine can be configured to execute analyses when data arrives, meaning that important information is immediately processed and available to users. The PI Notifications system may also be used to provide alerts based on configurable criteria such as quality exceedances.
The flagship trial demonstrated that it is able to interface with data sources to collect related data into a single model covering several locations. It’s able to undertake the calculation of water quality metrics using agreed methods provided by Lower Murray Water while performing the backfilling of analyses using all available data.
The trial is able to present data in real time dashboards and PI Collections (PI Vision) were used to auto-generate a dynamic tiled display of water quality data that users could filter by location or any of the water quality data points. Compliance summary displays were created to show at a glance. Note these will be prototypes, users will be trained to modify or create their own displays presenting data in ways that are most meaningful to them.
The flagship trial demonstrated that the PI System can automate the collection and analysis of lab data and present live dashboards showing current and historical performance against targets.
This provides a great efficiency in automation of the otherwise manual process. It also assists with tactical and strategic decision making in terms of meeting targets and analysing causes of water quality issues in real time.
Data & Analytics Program Lead David Bergmann said: “file based data such as that collected for water quality has traditionally sat outside the core business systems, now there is the opportunity to integrate and visualise this data with other operational data.”
For further information contact the D&A Program Lead - firstname.lastname@example.org.