Designing an Online Analytical Processing (OLAP) for Project Feasibility Study in Siau Tagulandang Biaro District

Authors : Miracle Theofilus Rumondor, Dyah Cita Irawati

Volume/Issue : Volume 4 - 2019, Issue 12 - December

Google Scholar :

Scribd :

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.


Paper Submission Last Date
30 - June - 2023

Paper Review Notification
In 1-2 Days

Paper Publishing
In 2-3 Days

Video Explanation for Published paper

Never miss an update from Papermashup

Get notified about the latest tutorials and downloads.

Subscribe by Email

Get alerts directly into your inbox after each post and stay updated.

Subscribe by RSS

Add our RSS to your feedreader to get regular updates from us.