Kwazulu-Natal Business News

Send  Share  RSS  Twitter  21 Oct 2011

WATER: Umgeni Water Achieves Optimisation with QlikView


Recent Kwazulu-Natal Business News

Self-built Umgeni Water BI financial data model lays basis for future improvement of plant operations performance.

Umgeni Water, the KZN water authority, has dramatically improved, hastened and saved on its analysis of resource consumption, and also paved the way for improving operational outputs in the future, with business intelligence (BI) software from QlikView South Africa.

In 2009, the state-owned provider of bulk potable water realised it needed better insight into its use of chemicals, energy and human resources in a drive to better improve operational efficiencies. Ultimately, it realised, this would give greater insight over plant operations and output quality, says Radesh Padayachee, Umgeni Water Business Systems manager.

Umgeni Water - Build Your Own

To achieve this, the company requested demos from business intelligence (BI) providers, including Durban-based Insight Consulting. Based on QlikView’s features, integration and dashboards, Umgeni went on to request a proof-of-concept (POC) financial data model from the provider, and when that succeeded, signalled that it wanted to embark on development of a full-scale financial data model.

Roy Beni, business analyst at Umgeni, says based on QlikView’s reputation for ease of use and development, the authority wanted to build the fleshed-out data model itself and train its own users, having closely observed the three-day POC. Where needed, Insight Consulting stepped in with guidance, says Upuli de Abrew, Insight Consulting director.

Umgeni Water - Current and Future Application

The financial data model remains Umgeni Water’s flagship BI application, but the company has extended it to other areas of the business, to enable financial modelling in the areas of lab statistics, telephone cost management and so forth. “Currently we have 18 live data models.”

Umgeni lists its quantifiable savings as paper (reports are no longer printed) and productivity – that is, time spent on analysis. Umgeni’s enterprise resource planning system allows it to draw financial data from operational systems, but this could take up to two weeks, says Raj Moodley, Umgeni Water’s Financial Controller. “With QlikView, business users have direct access to operational intelligence, without delays.”

“They love it. From plant supervisors tracking electricity use to engineers measuring wastage to compliance officials gathering audit stats, users love the point-and-click results, graphical views, quick updates, anytime access and flexible queries. Our entire user base of 54 got to grips with the software in half an hour. As for the financial department, it is the best thing I have had as a business management tool.”

Umgeni Water - ROI

The abovementioned gains in productivity and paper savings have already translated into impressive return on investment, Moodley continues.

“We are at financial year-end, and haven’t been able to move beyond the financial data models, but in the near future the software could provide the basis for activity-based costing that will have an impact on plant outputs, which we can then feed into the tariff system to benefit customers.”

What else is in store for Umgeni Water and QlikView’s future together?

study-it-onlinespine-alignBusiness Profilesjane-shonfeldspaceacre

Online Foreign Exchange
Foreign Exchange


Fax 2 Email



Online Casino


Shop Online

Study IT
Study IT Online

Web design
Web Design


Work from Home
Company News


© 2021 All rights reserved.

Daily Newsletter Subscription


Subscribe to the Kwazulu-Natal Business News Daily News and information email (it's free).

Thank You
Your email address has been added.

Email Address: