DEVELOPMENT OF BUSINESS INTELLIGENCE FOR THE INTEGRATION OF FINANCIAL REPORTING SYSTEMS AT PT XYZ
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.
business intelligence; system integration; financial reporting.