Search:  
Kwazulu-Natal Business News
9838
VIEWS

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-onlineBusiness Profilesspine-alignjane-shonfeldspaceacre
 
   
 
 
 
  Accomodation
Accommodation


Online Foreign Exchange
Foreign Exchange


Directory
Directory


Fax
Fax 2 Email


Finance
Finance


Furniture
Furniture


Casino
Online Casino


Restaurant
Restaurant


Auctions
Shop Online


Study IT
Study IT Online


Web design
Web Design


Weddings
Weddings


Work
Work from Home
 
 
 
 
 
Company News
 
 

 

© 2024 www.kbn.co.za. 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.

Name:
Email Address: