Data Validation and Visualisation

Our address-matching routines are designed to connect client billing system addresses to authoritative sources such as OS Address Base Premium and Royal Mail PAF. We can link properties through this process in the billing system with external data sources and grade the matches, ensuring more accurate location information.

Additionally, we utilise external systems, such as OS Code-Point, to validate postcodes in billing systems.

We perform time-series data validation during the import phase to detect gaps, flatlines, and poor data quality. Netbase Alarms analysis identifies irregularities and abnormal patterns in time-series data, often signalling potential equipment failures or events. 

These alarms can automatically invalidate associated measured data and assist in merging DMAs in water balance analyses when a faulty asset is involved.

Our data-infilling projects involve collating and merging GIS and asset system data, establishing connectivity between assets, and applying rules-based engines to fill missing data gaps.

To ensure data accuracy in Netbase and engineering projects, we apply asset update routines that cross-check client data against industry-standard lookup tables. For instance, if the ‘date laid’ attribute for an imported pipe does not align with its material type (for example, cast iron), we make the necessary updates.

Validation will be carried out whilst calculating customer consumptions and night-use allowances. We scrutinise imported readings and consumptions from the client billing system, automatically invalidating negative calculated consumptions and detecting outliers for exclusion