Based in the Accounts and Accountability Report for the 2018 Regional Revenue and Expenditure Budget, the total budget allocated for the Road and Bridge Construction Program reached Rp.49,475,379,000.00. This large amount of budget requires an analysis of the value of the economic benefits of the project through a public study. In the current initial phase of development planning, feasibility studies of public projects are done to qualitatively analyze the economic benefits instead of quantitatively. Moreover, the data of projects are still processed using Microsoft Excel, making it difficult for the government to analyze due to unavailability of tools that integrate all project information. For this reason, this research was conducted to design a tool for better data analysis in a project feasibility study to present information on the economic benefits of the project for the community, and produce information from various perspectives. This qualitative research was conducted in the form of content descriptive analysis by designing Data Warehouse and OLAP. This research resulted in a tool that can display numerical analysis information and graphical analysis information on the public aspects of the feasibility study.

Keywords : Data Warehouse, OLAP.