Qlik Case Studies Leading gas distribution company innovates to provide information management at the “qlik” of a button

Edit This Case Study Record

	Leading gas distribution company innovates to provide information management at the “qlik” of a button Qlik

Leading gas distribution company innovates to provide information management at the “qlik” of a button

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Utilities
Use Cases	Process Control & Optimization Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	Kayserigaz, a leading natural gas distribution company, was facing challenges in consolidating data stored in the SAP and Oracle databases. The company was struggling with managing inconsistencies and inaccurate data, and providing one version of the truth. They needed a single system that could provide end-users with visibility into more than one data source. The aim of their Business Intelligence (BI) project was to provide effective, information-driven dashboards that would increase the efficiency of the decision-making process. Read More
About Customer	Kayserigaz is one of the leading natural gas distribution companies in Turkey. The company is owned by EWE AG, which has an eighty per cent holding in the Turkish energy supplier, the Çalik Group and Kayseri municipality, each with a ten per cent holding. It plans and delivers gas expansion projects, builds, runs and maintains the natural gas distribution for the province of Kayseri. Delivering gas to consumers and businesses and providing customer service, Kayserigaz also sells to the retail segment of the utilities market. The company has approximately 170 employees, who are supported by an IT team consisting of 6 people. Read More
Solution	Kayserigaz implemented QlikView, a Business Intelligence (BI) tool, to combine data from its SAP and Oracle database to enhance the relevance of the reports with detailed information and calculate Key Performance Indicators, which had not been possible before. The most critical information that impacts on the organisations customer service levels is now available to all end-users at the touch of a button. 50 million invoice tables for subscribers and over 250,000 items containing detailed information on each of the subscribers is now available for analysis and reporting, making data become profitable information. The company moved towards self-service analysis and reporting, empowering the users. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Utilities

Use Cases

Process Control & Optimization

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

Kayserigaz, a leading natural gas distribution company, was facing challenges in consolidating data stored in the SAP and Oracle databases. The company was struggling with managing inconsistencies and inaccurate data, and providing one version of the truth. They needed a single system that could provide end-users with visibility into more than one data source. The aim of their Business Intelligence (BI) project was to provide effective, information-driven dashboards that would increase the efficiency of the decision-making process.

About Customer

Kayserigaz is one of the leading natural gas distribution companies in Turkey. The company is owned by EWE AG, which has an eighty per cent holding in the Turkish energy supplier, the Çalik Group and Kayseri municipality, each with a ten per cent holding. It plans and delivers gas expansion projects, builds, runs and maintains the natural gas distribution for the province of Kayseri. Delivering gas to consumers and businesses and providing customer service, Kayserigaz also sells to the retail segment of the utilities market. The company has approximately 170 employees, who are supported by an IT team consisting of 6 people.

Solution

Kayserigaz implemented QlikView, a Business Intelligence (BI) tool, to combine data from its SAP and Oracle database to enhance the relevance of the reports with detailed information and calculate Key Performance Indicators, which had not been possible before. The most critical information that impacts on the organisations customer service levels is now available to all end-users at the touch of a button. 50 million invoice tables for subscribers and over 250,000 items containing detailed information on each of the subscribers is now available for analysis and reporting, making data become profitable information. The company moved towards self-service analysis and reporting, empowering the users.

Impact #1	Reports previously generated by the IT department that took many hours to extract, are now generated by the users themselves using QlikView, at speeds that are incomparable to the old days.
Impact #2	Insight into the data and its inconsistencies across the different databases.
Impact #3	A move towards self-service analysis and reporting, empowering the users.

Impact #1

Reports previously generated by the IT department that took many hours to extract, are now generated by the users themselves using QlikView, at speeds that are incomparable to the old days.

Impact #2

Insight into the data and its inconsistencies across the different databases.

Impact #3

A move towards self-service analysis and reporting, empowering the users.

Benefit #1	A 10% increase in work efficiency across the entire organisation.

Benefit #1

A 10% increase in work efficiency across the entire organisation.

Download PDF Version

Overview

Leading gas distribution company innovates to provide information management at the “qlik” of a button

Operational Impact

Quantitative Benefit