Water Billing System with Business Intelligence and Data Analytics

Abstract

Water resource management involves the day to day operations such as computing water consumptions and collecting payments of water consumers. It also includes the activity of planning, developing, distributing, and managing the optimum use of water resources. Two of the major problems in water resource management are the lack of an automated system for collection and the distribution of water facilities. This study is about the development of a Water Billing System with Business Intelligence and Data Analytics for Water Resource Management using Linear Regression a web-based application that implements business intelligence and linear regression. In the development, the researchers used the agile model to systematically create the system. The system is evaluated by IT- Experts to meet the software Industry standards. The developed system can generate a dashboard through the implementation of business intelligence particularly data aggregation that can produce different graphs in terms of water consumption, consumer distribution, revenue collections, and collectibles. The developed system can generate data analytics through the implementation of a Linear Regression Algorithm that can also produce forecasts and patterns in terms of water consumption, revenue collections, and collectibles based on previous data trends. As a result, there is a significant increase in collections based on the last four months' implementation of the system. Using the ISO-9126 as an evaluation instrument the system has passed the industry standard because the evaluation results show only two verbal interpretations; “Highly” and “Very Acceptable”.