Select your language

CKW AG - Cloud Meter

CKW AG - Project Cloud Meter

ckw

"With iRIX, we have a reliable partner at our side. The collaboration is characterized by exceptional transparency, open communication and a strong sense of shared responsibility"

Christoph Häne,

Introduction
As part of the federal government's Energy Strategy 2050, a new Electricity Supply Ordinance has been issued. This requires that at least 80% of the grid operators' conventional electricity meters be replaced by intelligent metering systems, so-called smart meters, by 2027.

Challenge
The nationwide introduction of smart meters marked a significant step for CKW because it created a data-based foundation for an optimized energy future.

180,000 customers had to be contacted and their meters replaced[1]. In addition to this Herculean logistical task, however, the resulting flood of metering data also had to be managed. Downstream systems had to be adapted and new ones implemented in order to be able to process the approximately 30 million measured values per day.

At the same time, the data had to be both easily understandable and accessible to the end user and comply with strict data protection guidelines. The fact that each customer only has access to his own data is a basic requirement and must be ensured at all times.

Solution
T
oday, CKW customers can view their consumer data securely and on a daily basis on the myCKW customer portal[2]. In addition, this data is made available to the public in anonymized and aggregated form as part of the Open Data strategy[3].

To this end, CKW's Data Analytics team has worked closely with iRIX to build a highly scalable analytic platform in the Azure Cloud. At its heart is the Spark Appliance Azure Databricks[4], which validates smart meter data using Structured Streaming, enriches it with master data and makes it available in a data lake and an Azure SQL Database with Hyperscale[5].

In 2019, CKW received the Neos Award in bronze for its customer portal. A nice reward for all involved in this project.

 

[1] https://www.ckw.ch/energie/netz-und-infrastruktur/stromzaehler-und-messen/zaehlerwechsel, 18.08.2023

[2] https://www.ckw.ch/kontakt/online-portale, 18.08.2023

[3] https://www.ckw.ch/landingpages/open-data, 18.08.2023

[4] https://www.databricks.com/de, 18.08.2023

[5] https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-architecture?view=azuresql, 18.08.2023

Technologies used

Further customer projects

Optimisation of the planning processes

Optimisation of the planning processes

Thanks to Jedox for significantly more efficient and error-free planning processes

read more

Comprehensive reference database

Comprehensive reference database

Differently structured data can be visualised and compared at any time

read more

Application for the automatic placement of bids

Application for the automatic placement of bids

iRIX links Axpo Solutions with tertiary power exchange

read more

Contact us

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.