DATA WAREHOUSE TO DECISION SUPPORT SYSTEMS FOR PROVINCIAL WATERWORKS AUTHORITY

Abstract

The objective of this research is to develop data warehouse system to analyze the sale planning for Provincial Waterworks Authority using On-Line Analytic Processing technique and data presentation in the business intelligence report. The operation data are import data from sales daily database to extract and transform data into a data warehouse framework.

The system is designed to support decision making about sale planning for executives level. For the result from this research the satisfaction by executives and administrators found that the average user satisfaction is at a good level.