The Development of Data Warehouse for Contractor System
Wimora Sarwindo1, Abba Suganda Girsang2
1Wimora Sarwindo, Computer Science Department, BINUS Graduate Program-Master of Computer Science, Bina Nusantara University, Jakarta, Indonesia.
2Abba Suganda Girsang,Computer Science Department, BINUS Graduate Program-Master of Computer Science, Bina Nusantara University, Jakarta, Indonesia.
Manuscript received on September 22, 2019. | Revised Manuscript received on October 20, 2019. | Manuscript published on October 30, 2019. | PP: 2196-2205 | Volume-9 Issue-1, October 2019 | Retrieval Number: A9708109119/2019©BEIESP | DOI: 10.35940/ijeat.A9708.109119
Open Access | Ethics and Policies | Cite | Mendeley
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: In the middle of the crowded infrastructure of facility and infrastructure while the data of project budget has been increasing every day, PT XYZ requires new technology of data warehouse in order to respond the needs of recording and extracting project budget data quickly and accurately because Ms Excel, recent software used by managing-data staff to store data manually, is fairly time-consuming to record and extract daily realization of project budget. Therefore, in order to help the company to learn the result of the project budgets that have already been spent for the various needs of project construction, the technology of data warehouse should be present in order to extract and record data more consistently and time-saving. Data warehouse technology to support the development of Data Warehouse is Pentaho because Pentaho is database application that is supported with database MYSQL and OLAP feature as a means to analyze and process data contained in multidimensional tables once the process of ETL is executed. ETL means the process of selecting and extracting data from one source into the designated source in order to produce better-quality data result. OLAP is developed by using pivot 4j view integrated by pentaho server to map the structure of fact and dimension table properly so that, the tables can get a proper connection to display desired information in term of graphs for the need of dashboard display. The dashboard that is coded through mdx queries in CDE Dashboard shows the final result of either monthly or yearly project budget obviously and reliably so that the company can learn the report and make decision that needs to be taken to control the budget costs and maintain the company profit. Both CDE Dashboard and pivot 4j view are integrated with pentaho server. Finally, report is presented by using pentaho report designer as a means to extract needed data more rapidly and consistently because data are called through id stored in different table, but the same field.
Keywords: Data Warehouse, Pentaho, MYSQL, Realization of Project Budget CDE Dashboard.