| Home

Overview


Original Research

DEVELOPMENT OF BUSINESS INTELLIGENCE FOR THE INTEGRATION OF FINANCIAL REPORTING SYSTEMS AT PT XYZ

JAROT S SUROSO 1, and DEA CARISSA 2.

Vol 17, No 10 ( 2022 )   |  DOI: 10.5281/zenodo.7302570   |   Author Affiliation: Universitas Bina Nusantara, Jakarta, Indonesia 1,2.   |   Licensing: CC 4.0   |   Pg no: 2383-2406   |   To cite: JAROT S SUROSO, and DEA CARISSA. (2022). DEVELOPMENT OF BUSINESS INTELLIGENCE FOR THE INTEGRATION OF FINANCIAL REPORTING SYSTEMS AT PT XYZ. 17(10), 2383–2406. https://doi.org/10.5281/zenodo.7302570   |   Published on: 31-10-2022

Abstract

The purpose of this study was to design a BI system. The methodology used in this study uses the BI roadmap approach (Moss and Atre 2003). The BI roadmap approach is used because it is agile and adaptive with changes in building BI products and is fully aimed at supporting BI development. In BI technology, there is a data integration process: Extract, Transform, and Load (ETL) which can help the process of converting the Online Transaction Processing (OLTP) system into Online Analytical Processing (OLAP). The results of the study obtained that the transaction data warehouse designed using PDI (Pentaho Data Integration), is very helpful in collecting transaction data from the original transaction data that already has a database and only as OLTP (Online Transactional Processing) data so that it can be used as OLAP (Online Analysis Processing) data so that it is analyzed using OLAP.


Keywords

business intelligence; system integration; financial reporting.