Data is presented more clearly with Microsoft Power BI
Kapacity developed a tool that estimates the normal water consumption in the supply network for each day and for each section and spots whether the actual consumption deviates significantly from the normal. The tool zooms in on water consumption at night, as it is low and more stable, making it easier to see data fluctuations and thus signs of a leak.
The collected data is sent from VandCenter Syd’s flow meters to an Azure Data Lake, which collects all data and analyzes it across platforms and languages. Every morning, the statistical model runs in Azure, and VandCenter Syd can then read the result in a Power BI report, which shows the result and follows the developments in different sections.
There has also been placed an alarm in the system, if something that differs significantly from normal development occurs. In those cases, an alarm message will be sent to the Operations Department at VandCenter Syd.
The new solution is a much more transparent presentation of data than what VandCenter Syd previously had, says Andreas Bjørn Bassett.