Skip to main content

Gaining the tools to analyse, manage and improve asset data



To support a province wide asset survey and improve day-to-day data management, Northern Ireland Water needed to be able to create, edit, analyse and audit its asset records more easily.

Northern Ireland Water and AMT-SYBEX worked together to develop a set of Bulk Upload and Data Integrity (BUDI) tools based on AMT-SYBEX Affinity Systemreach software.

The new tools simplify and automate the process of gathering, validating, reviewing and uploading asset data from each site – significantly reducing manual workload for the asset information team, and creating a more comprehensive and accurate record of the company’s assets.

The Challenge

To improve business efficiencies and asset data quality, Northern Ireland Water was about to embark on a large-scale survey of above-ground assets at 3,500 sites across the province. For the asset information team, this posed a major challenge: without proper tools for data entry and management, even the day-to-day workload of creating and updating asset records was very time-consuming. To process the huge volumes of data that would be collected by the survey, the team needed to take an entirely new approach.

The Solution

After a full competitive tendering process, Northern Ireland Water worked with AMT-SYBEX to develop a set of Bulk Upload and Data Integrity (BUDI) tools that would substantially automate and streamline the process of gathering, validating, uploading and monitoring asset data. The joint project team delivered the new tools, which are built on Affinity Systemreach software, on schedule and slightly under budget.

The Benefits

  • Reduces additional asset data management workload and avoids the need to hire a substantial number of additional data entry staff.
  • Automatically validates data at the point of collection, saving time and improving data quality.
  • Dramatically simplifies the creation and management of complex hierarchical asset records.
  • Increases the auditability of data and processes, making it easier to demonstrate regulatory compliance.
  • Lays the foundations for a more comprehensive and accurate record of the company’s assets, which will ultimately help to enhance maintenance processes and increase operational efficiency.

Northern Ireland Water (NIW) is a government-owned company that provides water supply and wastewater treatment services to customers throughout the country. NIW employs approximately 1,200 people at offices across Northern Ireland.

NIW owns and manages reservoirs, treatment works, pumping stations and water mains that supply approximately 795,000 domestic, agricultural, commercial and business properties with 619 million litres of water every day.

NIW also owns and manages wastewater treatment works and wastewater pumping stations dealing with 134 million cubic metres of wastewater per day.

“Our business is focused on delivering the best possible value to our customers by providing safe, reliable and cost-effective water and wastewater services,” says Sean O’Boyle, Asset Information Development Manager at Northern Ireland Water. “In practical terms, this means that the maintenance of our assets is of paramount importance. On a day-to-day basis, many of our core business processes revolve around the inspection and maintenance of thousands of assets across the country.”

Download the full case study now...