Published in Data Science and Engineering (DSE) Record 2021 Vol. 2 No. 1 pp. 36-44
Abstract
This study aims to develop a data warehouse system that integrates data from many sources of the Provincial Waterworks Authority (PWA). The system per-forms Extract-Transform-Load (ETL) and displays a map showing the incorrect water meter coordinates between the monthly water meter readings and the water meter installation points from the PWA’s Geographic Information System (GIS). Therefore, the PWA administrators can inspect and plan a survey of water meter installation sites to continue improving the information in the GIS. The system developed in this research was evaluated by comparing the accuracy of the differ-ence between the monthly water meters readings coordinates and the water meter coordinates from the GIS together with the results of creating abstract visualiza-tions in the form of a plan and a graph showing the water meters route with high incorrect coordinates. This approach allows the users to use it as information in planning the survey of the water meter installation site. The evaluation also shows a comparison of working time from the existing process with the newly devel-oped system. It was found that the newly developed system takes less time to op-erate than the user’s actual operation.