Management Information System (MaJIs) Eng. Mutaekulwa T.K Mutegeki - PowerPoint PPT Presentation

Management Information System (MaJI’s) Eng. Mutaekulwa T.K Mutegeki EWURA Tanzania Maseru, 30 th October, 2013 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 1 Page 1 Seite 1 Seite 1

Contents Background  Background  Users of MaJI’s  Data Collection, Verification and Use  Key Components of MaJI’s  Benefits  Challenges  Planned Improvements 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 2 Page 2 Seite 2 Seite 2

Background.. Backgrou….nd  Compilation of data for performance monitoring was introduced by the Ministry of Water in 1994 after the establishment of three semi-autonomous water utilities (Tanga, Moshi and Arusha)  Performance monitoring was pegged on tracking improvement on revenue collection and expenditure. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 3 Page 3 Seite 3 Seite 3

Background… Backgrou..nd  In 1997  19 fully autonomous water utilities were established  Intensification of performance monitoring by the Ministry of Water - 50 performance indicators  Data and indicators were reported in paper form 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 4 Page 4 Seite 4 Seite 4

Background..  Management Information system (MajI’s) was launched in 2006;  Software based  Tailor made database developed locally on the basis of data and indicators which were reported in paper form.  For 19 regional water utilities, DAWASA and DAWASCO.. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 5 Page 5 Seite 5 Seite 5

Background.  In June, 2013, web-based MaJI’s was launched by EWURA  Includes all water supply and sewerage authorities (130 utilities).  Revised indicators. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 6 Page 6 Seite 6 Seite 6

Users of MaJI’s.. User GrouUps  EWURA  Ministry of Water  Regional Water Utilities  DAWASA/DAWASCO  Small,District Towns and National Projects Water Utilities  MaJI’s is managed by EWURA Benchmarking facilitates comparative competition. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 7 Page 7 Seite 7 Seite 7

Users of MaJI’s Service Data input MajIs Database Provider/util ity Analysis and compilation of data Service provider Regulator Ministry resp. for Water Self assessment Performance Monitor Policy + Reporting Monitoring +Bench- implementation+ marking Investments +MDG’s Reports Customers, Government, Global Monitoring(MDG)’s, stakeholders 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 8 Page 8 Seite 8 Seite 8

Data Collection,Verification and Use Data has to be entered into MajIs for each month latest by the 15th of the following month  Type presentation title here 2/19/2014 19.02.201410/14/13 19.02.201410/14/13 Page 9 Page 9 Seite 9 Seite 9

Key Components of MaJI’s.. ey Aspects of MAJI’s  Data Comparison : Data entry forms includes a comparison column showing the values of the previous record 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 10 Page 10 Seite 10 Seite 10

Key Components of MaJI’s… Data Validation §Any figure entered in entry sheets that contain a comparison column will be compared with the previously reported figure §Deviations of more than +100% or -50% will require the user to confirm the correctness of the entered information. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 11 Page 11 Seite 11 Seite 11

Key Components of MaJI’s.. Comment Function  .  The comment allows users to view and comment on the monthly record. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 12 Page 12 Seite 12 Seite 12

Key Components of MaJI’s.. Mandatory data field  Some of the data entry fields have been defined as mandatory data  . fields. A record can only be locked and sent to EWURA, if least all mandatory fields have been filled in. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 13 Page 13 Seite 13 Seite 13

Key Components of MaJI’s…  Identification of data inaccuracies by analyzing trends and provide early feedback 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 14 Page 14 Seite 14 Seite 14

Key Components of MaJI’s…  Easy to make comparative analysis and benchmarking of different Utilities 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 15 Page 15 Seite 15 Seite 15

Key Components of MaJI’s. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 16 Page 16 Seite 16 Seite 16

Benefits of MaJI’s..  The proper use of MAJIS allows utilities to get away with persisting problems in:  Delays in submission of reports  Minimize calculation errors for indicators  Data inconsistence  Main input for the preparation of Water Utilities Performance benchmarking reports which are available at www.ewura.go.tz 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 17 Page 17 Seite 17 Seite 17

Benefits of MaJI’s  Facilitates the utility’s internal monitoring and planning processes.  Computation and analysis of requested tariff increases.  To track the attainment of performance targets  To make realistic projections e.g. for project proposal and loan applications 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 18 Page 18 Seite 18 Seite 18

Challenges Delays have been encountered in the submission of reports mainly due to:  Lack of dedication by CEO’s  Frequent change of staff knowledgeable with MajIs.  In some utilities, IT staff are the ones responsible for data entry and verification.  Frequent fallout of internet availability at the Utilities. 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 19 Page 19 Seite 19 Seite 19

Planned Improvements - MaJI’s  To provide an additional field for all raw data entry sheets on which service providers will be indicating their data quality in terms of accuracy and reliability. The combined effect of data accuracy and reliability will give the confidence grading of that particular data.  EWURA is working on a possibility for the public to access selected data of water utilities by logging into MaJI’s website. www.majis.ewura.go.tz 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 20 Page 20 Seite 20 Seite 20