Select your language

CKW – Centralschweizerische Kraftwerke AG - DWH Automation

CKW - Centralschweizerische Kraftwerke AG - DWH Automation


„iRIX takes care of our challenges as if they were their own. In the process, we work together to develop solutions that stand up in practice.“

Michael Huwiler, Team Leader Business Intelligence & Data Integration

Centralschweizerische Kraftwerke AG (CKW), based in Lucerne, produces, trades and distributes electricity to business and private customers. Like all market participants, it faces major challenges such as:

  • Falling electricity prices
  • Development of new business areas and opening up of new markets
  • Liberalisation of the electricity market - free choice of energy supplier for private customers
  • Digitalisation of the electricity market - automated supplier switching at the click of a mouse

The DWHs and their reporting, which were built up erratically in the past, only partially meet the constantly changing requirements. The effects:

  • Data is trapped in silos and can only be merged poorly
  • New requirements are implemented only very slowly or not at all
  • Many business users switch to Excel
  • New technologies or organisational forms are not used

iRIX Software Engineering AG was commissioned to conduct a preliminary business intelligence study and is now supporting its implementation. The following table shows the work already carried out.

In the realisation of the various sub-steps, attention was paid to balance in terms of technology, governance/organisation and added value for business users. We would like to highlight the following results in particular:

  • Implementing a new Datamart and replacing an existing one (technical project)
  • Establishing Scrum in the BI team (organisation/governance)
  • Introduction of a DWH automation tool (technology)

Added value for the client

  • No break between consulting, implementation and operation
  • Measures to anchor BI better throughout the organisation
  • Clear BI roadmap with options for action
  • Future-oriented architecture
  • Development of new organisational forms (Scrum)


Technologies used

Wherescape RED, Microsoft SQL Server, Tableau

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

Application for the automatic placement of bids

Application for the automatic placement of bids

iRIX links Axpo Solutions with tertiary power exchange

read more

Webpat II

Webpat II

Group-wide and fast search tool for patents

read more

Contact us

Subject *
Name *
Email *
I agree with the privacy policy

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.