Qlik Case Studies South Staffs Water Reduces Reports from 100 to 30 with QlikView

Edit This Case Study Record

	South Staffs Water Reduces Reports from 100 to 30 with QlikView Qlik

South Staffs Water Reduces Reports from 100 to 30 with QlikView

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
Challenge	South Staffs Water, a water utility serving 1.29 million people and 38,000 businesses in the West Midlands of the United Kingdom, was facing a challenge of information overload. The company had over 100 static reports, making it difficult to develop a single version of the truth from their raw data. This data was housed in multiple sources including Oracle, Excel spreadsheet software, and Microsoft Access. The company needed to reduce these reports to between 20 and 30 to avoid complete information overload. Their vision was for one consolidated reporting front end that gave their users a single version of the truth. Additionally, the company was under constant scrutiny from the Office of Water Services (Ofwat), its regulator, and needed to meet external challenges from them. Read More
About Customer	South Staffs Water is a water utility serving 1.29 million people and 38,000 businesses in the West Midlands of the United Kingdom. Its domestic customers pay the third lowest water bills in England and Wales, partly attributable to the utility being ranked fifth in the industry for efficiency and low operating costs. With an annual turnover of £84.5 million, South Staffs Water is the third largest water only company in England and Wales and serves an area of 1,500 square kilometres. The utility supplies 300 million litres of water a day across a network of pipes that total 6,000 kilometres in length and supply around 500,000 homes. Technology is a principal driver for efficiency and responsiveness at South Staffs Water in multiple ways including works management, customer service, operations and maintenance, finance, and data reporting. Read More
Solution	South Staffs Water opted for QlikView, a Business Discovery platform, to help reduce information overload and improve reporting on KPIs. The software delivered a true and interactive enterprise reporting tool with complete flexibility and a rapid return on investment. QlikView was seen as the key to unlocking the value of the utility’s business data by producing instant self-service ad hoc reports. These reports combined the information from IBM Maximo with other systems including Oracle Financials. This no longer required the intervention of the IT department because key users could generate reports themselves on a self-service basis. The company found new and innovative ways of improving efficiency with QlikView for operational and planning purposes. It also helped supply information to the regulator quickly and easily. 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

Challenge

South Staffs Water, a water utility serving 1.29 million people and 38,000 businesses in the West Midlands of the United Kingdom, was facing a challenge of information overload. The company had over 100 static reports, making it difficult to develop a single version of the truth from their raw data. This data was housed in multiple sources including Oracle, Excel spreadsheet software, and Microsoft Access. The company needed to reduce these reports to between 20 and 30 to avoid complete information overload. Their vision was for one consolidated reporting front end that gave their users a single version of the truth. Additionally, the company was under constant scrutiny from the Office of Water Services (Ofwat), its regulator, and needed to meet external challenges from them.

About Customer

South Staffs Water is a water utility serving 1.29 million people and 38,000 businesses in the West Midlands of the United Kingdom. Its domestic customers pay the third lowest water bills in England and Wales, partly attributable to the utility being ranked fifth in the industry for efficiency and low operating costs. With an annual turnover of £84.5 million, South Staffs Water is the third largest water only company in England and Wales and serves an area of 1,500 square kilometres. The utility supplies 300 million litres of water a day across a network of pipes that total 6,000 kilometres in length and supply around 500,000 homes. Technology is a principal driver for efficiency and responsiveness at South Staffs Water in multiple ways including works management, customer service, operations and maintenance, finance, and data reporting.

Solution

South Staffs Water opted for QlikView, a Business Discovery platform, to help reduce information overload and improve reporting on KPIs. The software delivered a true and interactive enterprise reporting tool with complete flexibility and a rapid return on investment. QlikView was seen as the key to unlocking the value of the utility’s business data by producing instant self-service ad hoc reports. These reports combined the information from IBM Maximo with other systems including Oracle Financials. This no longer required the intervention of the IT department because key users could generate reports themselves on a self-service basis. The company found new and innovative ways of improving efficiency with QlikView for operational and planning purposes. It also helped supply information to the regulator quickly and easily.

Impact #1	Reduced information overload from 150 to 20 to 30 reports
Impact #2	Combined data from multiple sources into a single version of the truth
Impact #3	Pinpointed inefficiencies for instant remediation

Impact #1

Reduced information overload from 150 to 20 to 30 reports

Impact #2

Combined data from multiple sources into a single version of the truth

Impact #3

Pinpointed inefficiencies for instant remediation

Benefit #1	Reduced the number of reports from 100 to between 20 and 30
Benefit #2	Reduced the time to get an accurate view of the stock value across the organization from up to three days to seconds

Benefit #1

Reduced the number of reports from 100 to between 20 and 30

Benefit #2

Reduced the time to get an accurate view of the stock value across the organization from up to three days to seconds

Download PDF Version

Overview

South Staffs Water Reduces Reports from 100 to 30 with QlikView

Operational Impact

Quantitative Benefit