The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company
Abstract Introduction: XYZ is a company engaged in the port sector. XYZ is engaged in the business of loading and unloading terminal services and container buildup. To support the company's business processes. Case Description: XYZ uses two applications in carrying out operational activities, namely the CARTOS application to manage bills and the Finance application to record company costs and revenues. To produce a cost accounting report, PT XYZ is still processing and visualizing it manually using Microsoft Excel applications with data sources from the two applications previously mentioned. There are problems related to the process, where the processing time to process data into information is quite long. So that reporting to management cannot be done in real time. Discussion and Evaluation: The development of business competition is very rapid, the management of XYZ must be able to make decisions quickly and accurately, so company needs tools that can help the management to analyze and manage data into information in real time. The Business Intelligence (BI) method is one of the solutions to the company's needs, especially in analyzing and providing access to data to help make better decisions. Conclusion: This study discusses the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard in accordance with the needs of PT XYZ. The method used in developing the business intelligence dashboard refers to the executive information system lifecycle method which consists of justification, planning, business analysis, design, construction and deployment. The results of this research are dashboard visualization using Power BI tools that display information and knowledge needed in the monitoring process and become material for generating management decisions related to cost accounting reports.