Abstract
Abstract XYZ is a company engaged in the port sector. To support the company’s business processes, XYZ uses two applications to carry out operational activities, namely the CARTOS application to manage invoices and the Finance application to record company costs and revenues. To produce a cost accounting report, XYZ is still processing and visualizing it manually with data sources from the two applications mentioned earlier. This resulted in quite a long time processing data into information. So that reporting to management cannot be done in real time. Therefore XYZ needs a system that can help management to analyze and manage data into information in real time. The Business Intelligence (BI) method is one of the solutions for company needs, especially in analyzing and providing access to data to help make better decisions. 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 XYZ. The method used in developing business intelligence dashboards refers to the executive information system life cycle method which consists of justification, planning, business analysis, design, construction, and dissemination. The results of this research are dashboard visualization using the Power BI tool that displays information and knowledge needed in the monitoring process and becomes material to produce management decisions related to cost accounting reports.
Highlights
XYZ is a company engaged in the port sector
To support the company’s business processes, XYZ uses two applications to carry out operational activities, namely the CARTOS application to manage invoices and the Finance application to record company costs and revenues
This study discusses the design and implementation of business intelligence solutions ranging from architecture, data warehouse, Extract Transform Load (ETL) processes and visualization in the form of a dashboard in accordance with the needs of XYZ
Summary
Abstract: XYZ is a company engaged in the port sector. To support the company’s business processes, XYZ uses two applications to carry out operational activities, namely the CARTOS application to manage invoices and the Finance application to record company costs and revenues. To produce a cost accounting report, XYZ is still processing and visualizing it manually with data sources from the two applications mentioned earlier. This resulted in quite a long time processing data into information. 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 XYZ. The results of this research are dashboard visualization using the Power BI tool that displays information and knowledge needed in the monitoring process and becomes material to produce management decisions related to cost accounting reports
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
