Data Quality Improvement for Enterprise Asset Management

Engineering and Contracting Services

Maintaining accurate and high quality data records is critical to the success any enterprise asset management strategy.

381K

The number of overhead line equipment (OLE) and high- voltage electrification assets needing to be monitored, distributed across 9,408 kilometres

94%

Reduction in time spent analysing data to accurately assess the condition and quality of assets.

£783K

Efficiency savings derived from automating manual surveys, processing data and planning maintenance activities

Situation

Our client is an early stage growth company specialising in managing complex civil engineering and electrification projects in the railway industry. They needed to reduce the amount of time spent in monitoring and analysing the condition of over 381,000 assets located across 9,408 kilometres of railway infrastructure. The client needed to overcome a challenge where 14 regional business units created their own methods of recording and storing data related to surveys for these assets.

Technology

We worked in partnership with two subject matter experts in project planning for the railway sector and geospatial analysis in the transport sector. Together we discovered that all 14 regional business units collected and stored the information we needed in spreadsheets. We built a data lake to store the raw data files and began analysing the patterns with which the regional business units collected and stored information relating to the 381,000 assets. We discovered that the cause of the inefficiency and the prolonged length of time it took perform a survey of the assets came down to a lack of consistency in data governance.

Show More
Analytics

To automate processes we needed to find hidden and consistent patterns in the datasets. We employed a wide range of data mining techniques to find these patterns and discovered that a lot of the geographical records for the assets were wrong. For example, some assets that were physically in Birmingham were showing up in the Atlantic Ocean. We solved this problem with an innovative yet simple set of clustering and algorithmic techniques based on asset identification numbers.

Results

In less than 5 weeks our team delivered a complete solution that mapped over 381,000 assets and components spread across 9,408 kilometres of railway infrastructure. By improving data quality by 90% we unlocked a 94% reduction in time spent assessing the quality and condition of assets in person throughout the railway network. This helped the client generate over £783,000 per year in operational efficiency savings.

Note: Delivered in collaboration with Pang & Chiu and Open Data Consultants.

Project Gallery

1/1

®

EVIDENCE BASED SOLUTIONS

ABOUT

+44 (0) 203 920 9378

info@authenticevidence.com

278 Northfields Avenue, Ealing, London, United Kingdom

SOCIAL
  • White LinkedIn Icon
  • White Twitter Icon
  • White Facebook Icon

© 2020 by Authentic Evidence Limited.