1 / 11

Managing Information and Monitoring Performance in the Water Industry

Managing Information and Monitoring Performance in the Water Industry. The Company. 450 employees 1,600,000 Customers 10,000 km underground pipes £50m annual capital programme. The Environment – A regulated industry. – June Returns, Periodic Reviews

boyd
Download Presentation

Managing Information and Monitoring Performance in the Water Industry

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Managing Information and Monitoring Performance in the Water Industry

  2. The Company • 450 employees • 1,600,000 Customers • 10,000 km underground pipes • £50m annual capital programme

  3. The Environment – A regulated industry • – June Returns, Periodic Reviews • – Financial Information • – CAPEX forecasting and monitoring • Decision support, • Supply planning and modelling

  4. The Starting Position - Architecture Works Management Finance HR GIS AS/400 Oracle CIS Lab Info Telemetry ?

  5. The Starting Position - Reporting Business Systems Spreadsheets / Bespoke Databases Manual querying and compilation, lack of procedures = Many versions of the truth !

  6. The Blueprint - Architecture Regulatory Financial Operational Information Portal Structured Database E T L BUSINESS SYSTEMS Finance Works CIS Lab GIS Telemetry

  7. The Blueprint – Reporting / Monitoring Overall Performance Assessment Digital Dashboard KPI’s Data Marts Finance Operations Cust. Services

  8. Decisions – ETL / Reporting Software • ETL • Functional • Affordable • Scalable Our choice – Business Objects data Integrator • Reporting • User friendly • Easy to administer • Functionally rich Our choice – Business Objects Web Intelligence

  9. Decisions – Prioritising the Programme Decisions – Prioritising the programme Regulatory Financial Operational Debt & Enquiries Electricity monitoring Capex Opex Information Portal Structured Database Structured Database E T L E T L BUSINESS SYSTEMS Finance Finance Works Works CIS CIS Lab Lab GIS GIS Telemetry Telemetry

  10. Progress and Benefits – so far • Departmental / Cost Centre accounts available to all • CAPEX project info available to all project managers • .NET project progress form linked to Data Mart • Electricity usage report using data from suppliers website • Debt and complaint information verified and automated • Cost of Water Production by site

  11. Blueprint for the future • River Basin analysis • Deployable Output • Drought forecast and analysis

More Related