There are a range of complex underlying issues contributing to poor data quality.
In 2018, REG developed a survey for the sector to gain a greater understanding of the root causes for inconsistent data quality to support the development of a sector-wide improvement programme.
The following common themes affecting data quality were identified:
We were very pleased with the quality and openness of the responses received and would like to thank the 130 respondents who took the time to complete the invaluable survey.
The ONRC phase has also involved analysis to understand the root causes of poor results and potential areas for improvement for the sector and RCAs. This identified the primary root causes of poor data quality as follows:
The subsequent ONRC improvement programme (phase 1) is helping RCAs move their data quality towards the expected standard. This includes development of eight practice overview documents:
The practice overview documents were a part of the 2018 REGional workshop programme consisting of an introduction at R14 (August 2018) and detailed learning around R15 (October/November 2018).
The results of the new 2017/18 data quality reports along with the data quality survey results supported the development of a potential sector-wide improvement programme that was introduced at the R15 REGional workshop towards the end of 2018.
Across the workshops, there was a high level of support and agreement with the areas of focus of the potential work programme.
An improvement programme of six projects was agreed, which has some crossover with the DEfT programme (Asset Management Data Standard) project. The DEfT programme will focus on data standards while the Data Quality Project will focus on developing guidance (including case studies) and enabling a complementary learning programme that will build the sectors data quality capability.
Guidance is being produced throughout 2019 to help RCAs improve their data quality for their 2021/31 AMP’s as follows:
1. Updates to practise overviews:
2. New practise overviews:
3. A metric library [XLSX, 52 KB] that provides detail about each data quality metric (second release to follow at IPWEA).
|Published March 2019
Released at RIMS Forum 20–21 March 2019
4. New guidance
5. A metric library [XLSX, 52 KB] that provides detail about each data quality metric, now including; metric purpose, consequence of poor-quality data, potential reason(s) for not being at the expected standard unique to this metric.
|Published June 2019
Released at IPWEA 2019
6. Upcoming guidance (subject to change):
|Published by July and August 2019|
7. Case studies (up to 12) showcasing:
|Published by October 2019|
REG is exploring partnering with a suitably experienced organisation to develop and deliver a technical training programme to help the sector apply the guidance and improve their data quality.
The guidance developed by REG will be the basis of the data quality learning programme which is expected to be supported by an enhanced online presence to help build enduring sector capability.
The REG learning and development programme and in particular the REGional workshop programme will continue to be a key medium to facilitate the culture change, consult and inform RCAs of the new guidance and project outputs.