Development of Key Performance Indicator (KPI) Reports for Water Billing System in Business Intelligence Application

In today's world, in order to achieve strategic objectives and to track enterprise performance, large amount of data gets analyzed thus becoming an essential business activity to improve decision-making. Key Performance Indicators (KPIs) are associated with specific purpose, so that work progress towards organization's objectives or mission can be measured. However, huge and small business requires such indicators to be carried out in the form of data warehousing (DW)/ business intelligence (BI) applications. To develop KPI Reports for Utility Billing Information System (UBIS), which further facilitates activities for Water Billing Department, becomes the main objective of this research. A list of requirements that is needed to develop this kind of reports was identified in order to achieve the stated objective. Furthermore, in order to design and develop DW for UBIS, DW/BI developing process was used, the dimensional model (DM) of the UBIS-KPI was defined and its DW model was designed. Moreover, the prototype of a BI application was developed based on the proposed DW model. To ensure that UBIS user's requirements are satisfactorily met, Computer System Usability Questionnaires (CSUQ) was used to evaluate the prototype. Finally, providing guidance to BI developers and supporting decision making of Water Billing department serves as the key contribution of this study.