Results on Data Apps

This deliverable describes the results obtained from the developed data apps defined in D1.1 and summarises the relevant insights generated by each app. The motivation for these functional units is to uncover insights from three-phase smart meter data that can aid decision-making and enhance grid management, prioritise investments, facilitate the provision of reliable services to customers, and support the global agenda to control CO2 emissions. These insights are also relevant to several other stakeholders, including electricians and installers who work directly on phase connections and attend to customer issues. By leveraging the three phase smart meter datasets shared by our partners through this project, several apps have been prototyped and validated for DSOs to operationalise further.

The presented apps have been categorised into three main groups, the first group comprising data apps that are particularly for data preparation and topology refinement, thereby setting the stage for their usability in other data apps. These apps include the data extractor - for timeseries data loading and topology refinement, SM classifier for characterisation and classification of smart meters, SM phase mapper for refining per phase topology information and mapping SMs based on their voltage measurements, and data corrector serving as a data updating patch, particularly for cleaning SM profiles, phase correction and topology cleaner. The second category contains data apps for phase imbalance analytics. Hence, the phase imbalance profiler and phase imbalance analyser have been presented. The last category covers apps that help identify heavy electrification loads and the phases they are connected to. In this case, the focus was on electrical heating identification, electric vehicles, and photovoltaic panels.

Running the developed data apps on large-scale datasets can require effort in some use cases; hence, the results on the scaling of the data apps with respect to datasets and compute are presented. This further exposed the opportunity to reflect on areas for further exploration.