A dynamic business development requires companies to be faster and more careful in every decision making. The wrong action can cause a lack of effectiveness which results in losses received by the company. Because of its importance, many companies are competing to extract information and knowledge from their data. The main objective is to support decisions made based on the results of information and knowledge analysis representing company decisions. One method used is Business Intelligence (BI). BI is defined as one of the data utilization methodologies to produce information to become knowledge in supporting strategic decision making. XYZ is a company engaged in the port sector, where PT XYZ serves terminal loading and unloading services and container buildup. To support the company's business processes, XYZ uses two applications, the CARTOS application to manage invoices and the Finance Application to record company costs and revenues.
Business Intelligence is a way to collect, store, organize, reshape, summarize data and provide information, both in the form of company internal business activity data, as well as company external business activity data including business activities of competitors that are easily accessed and analyzed for various management activities [1].
Business Intelligence is a series of applications and technologies for collecting, storing, analyzing, and presenting data access to assist company officials in decision making [2].
In addition, according to DJ Powers, said that Business Intelligence explained about a concept and method of how to improve the quality of business decision making based on data-based systems [3]
From the three sources above, it can be concluded that Business Intelligence is the concept of collecting data, storing data and selecting data to provide information to help and improve the quality of business decision making for companies. So it can be said that the information system is a place for data entry, while the business intelligence application is a place for data analysis. Where the concept of business intelligence turns information into new knowledge and understanding for an organization.
Previous studies that are relevant to this study include research conducted by Muhd Zaimi Abd. Majid, Wan Zahran Zakaria, and Ali Keyvanfar with the research title Executive Information Site Management System for Project Performance Monitoring: System Requirements Study. In this research, it is discussed how to monitor and control the development of a construction project work by utilizing the Executive Information System technology[4]. The study uses the Classic Waterfall Model method in developing the system.
Next is a study conducted by Meyliana, Henry A. E Widjaja, and Stephen W. Santoso with the title of University dashboard research: An implementation of executive dashboard to university[5]. In this research the data warehouse development method uses the Key Performance Indicator approach which is owned by the university.
Based on research conducted by Mohammad Taleghani with the title Executive Information Systems development lifecycle explained the concepts and architecture in the development of EIS [6]. Also explained what criteria support in evaluating an EIS so as to produce an EIS that suits user needs.
Based on research conducted by Joko Christian by using a data warehouse development method using a business life cycle approach and using the functionality testing of the prototype in the form of white box testing as feedback from the user [7]. This research uses a web service system as an intermediary between the data warehouse and the applications used and the research produces a model that cannot be implemented yet.
Lutfi Izhariman, Eko Darwiyanto and Shinta Yulia Puspitasari conducted research under the title Design of Hospital Executive Information System for Evaluating Service Performance at Mohammad Hoesin Hospital Palembang [8]. In this study, it was discussed how to design an Executive Information System (EIS) that can support the processing of patient medical record data to display information on medical service indicators. The EIS design requires a data warehouse through the ETL (extract, transform, load) process in hospital operational data and displays the results of data analysis using OLAP (Online Analytical Processing) technique.
Edy Martha, et al, also conducted research using the EIS system life cycle engineering methods and built a system model with the help of UML [9]. His research resulted in a web-based executive information system application to process data at the Cabinet Secretariat.
Research conducted by Arif N, et al, using the EIS life cycle development method with primary data contained in the data warehouse is processed so that it becomes a form that can be analyzed by OLAP Server and uses a dashboard application to perform and view the results of the analysis [10]. The results of his research are in the form of a model design in building an executive information system at UGM that can show conditions in an organization in the form of a graphical display on the dashboard, so that it can be used as a material for university executive level consideration for decision making.
This research will produce the design and results of the implementation of executive information systems in accordance with the needs of PT XYZ. This research will use the EIS Lifecycle development method in which there are 6 stages of development namely justification, planning, business analysis, design, construction and deployment. The data to be used in this application is sample data from XYZ that is pulled from the XYZ operational system.
Case Description
In the case of XYZ, currently to process data and visualize the data to be a cost accounting report is still done manually using the Microsoft Excel application. Based on the results of interviews with management, there are several issues related to the process, including :
-
Data obtained from the supporting application outputs mentioned earlier are still in the form of raw data and take time to process data into information.
-
Data that can be stored and processed in Microsoft Excel is limited so that the monitoring and view of historical data is still not optimal.
-
The process of reporting cost accounting reports to management cannot be done in real time.
PT XYZ requires a BI application that provides monitoring information related to profit and loss per project to improve management effectiveness and efficiency in strategic decision making. Therefore, the development of BI applications can be a solution to assist managers in monitoring business processes, specifically related to profit and loss per project. Development includes the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard.