Download PDF
Qlik > Case Studies > South Staffs Water Reduces Reports from 100 to 30 with QlikView
Qlik Logo

South Staffs Water Reduces Reports from 100 to 30 with QlikView

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Utilities
Use Cases
  • Process Control & Optimization
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
The 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 The 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.
The 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.
Operational Impact
  • Reduced information overload from 150 to 20 to 30 reports
  • Combined data from multiple sources into a single version of the truth
  • Pinpointed inefficiencies for instant remediation
Quantitative Benefit
  • Reduced the number of reports from 100 to between 20 and 30
  • Reduced the time to get an accurate view of the stock value across the organization from up to three days to seconds

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.