go to top scroll for more


Projects: Projects for Investigator
Reference Number NIA_NGTO041
Title Big Data Analytics for Cable Systems
Status Completed
Energy Categories Other Power and Storage Technologies(Electricity transmission and distribution) 100%;
Research Types Applied Research and Development 100%
Science and Technology Fields PHYSICAL SCIENCES AND MATHEMATICS (Computer Science and Informatics) 100%
UKERC Cross Cutting Characterisation Not Cross-cutting 100%
Principal Investigator Project Contact
No email address given
National Grid Electricity Transmission
Award Type Network Innovation Allowance
Funding Source Ofgem
Start Date 01 December 2019
End Date 31 July 2021
Duration ENA months
Total Grant Value £405,000
Industrial Sectors Power
Region London
Programme Network Innovation Allowance
Investigators Principal Investigator Project Contact , National Grid Electricity Transmission (100.000%)
  Industrial Collaborator Project Contact , National Grid Electricity Transmission (0.000%)
Web Site https://smarter.energynetworks.org/projects/NIA_NGTO041
Objectives This project will make use of multiple sources of data that may correlate to underground cable asset condition data. Best-practice approaches to data analytics will be applied to filter and pre-process all sources of data. Once the data has been cleaned and organised, an exploratory data analysis will be performed to identify data sources that could be indicators of asset condition. Finally, the most promising combination of data sources will be identified and discussed, with clear recommendations for further work after this initial study is complete.This project will investigate the following data sources:1. Historical loading of cable circuits (Voltage and current)2. Alarm data3. Dissolved Gas Analysis (DGA) 4. Defect Data5. Work order data6. Weather data7. Local soil dataBy considering a wide range of different input data sources during this feasibility-level study, the project will ensure that future, more detailed, studies are cost-effective by narrowing the scope and reducing data volume overheads. This project will cover the following four work packages. WP1. Data collection and generationData will be collected from multiple sources from across our business and from external parties to support the main body of work. Data will also be generated where required from weather models or purchased from external suppliers.WP2. Data scrubbing/pre-processingThe data collected during WP1 will need to be processed and cleaned to different extents in preparation for any analysis or modelling. A scrubbing phase will include: Removal of any anomalous data from consideration Clarification where necessary Data processed into a standard format and central database ready for further analysesWP3. Data analysisDuring the exploratory data analysis phase correlations or patterns will be assessed between data sources. The project will attempt to identify utilisation factors which correlate his historic changes in our condition assessment of cable systems; providing new tools to asset manager. This could lead to the conclusion that additional data may be required, or whether any data source needs further clarification.WP4. Historic Temperature Profile EstimationIn this work package, the project will attempt to create historic temperature profiles for each cable circuit in the country. This will use the existing load data, historic weather data and a suitably parametrised thermal model for a cable circuit. These temperature profiles will then be combined with existing research on how cables degrade with temperature and method for estimations of remaining life will be made. This work package will also involve the design of a suitable thermal model for this type of analysis, as there are multiple factors which need to be considered for this type of analysis.WP5. Identification of key variables/combinations of variablesKey variables identified in WP3 will be further assessed in combination with other variables, with the aim of concluding which data sources are good indicators of the condition of underground cables. A report summarising the findings from all four work packages, with recommendations for further work, and highlighting the lessons learned during the project. To identify key data sources (or combinations of sources) that may be used to estimate underground cable asset condition, which can be used to support our condition assessments.
Abstract One of a Network owners main priorities is maintaining its assets in a cost-effective way. National Grid ET own and maintain over 1,400km of underground cables, which reflects roughly 15% of its transmission system.This project will investigate whether any relationships exist between asset condition and a range of operational and environmental data sets; proving insight into factors which can influence our condition assessments. This knowledge will allow NGET to quantify and mitigate the risk posed by different design, operational and environmental factors, with the aim of improving our management of cable systems.
Publications (none)
Final Report (none)
Added to Database 09/11/22