The Implementation of Business Intelligence on Visualisation of Transaction Data Analysis using Dashboard System Case Study: XYZ Convenience Store

J. Rahmadoni,Ricky Akbar,Hanifah Azra Lubis,Wahyudi

DOI: https://doi.org/10.1109/ISITDI55734.2022.9944494

2022-07-27

Abstract:So far, the XYZ Department Store's transaction data management process has been carried out using the Zahir Enterprise Application, which manages products data, supplier data, customer data, sales and purchase transaction data. This application, however, has not been able to help managers quickly analyze data in order to make decisions. As a result, using Business Intelligence (BI) to perform Dashboard System-Based Data Visualization Analysis is one solution to these issues. The BI Framework should be used as a reference when able to conduct studies to prove the application of BI, beginning with problem identification and progressing to the planning phase, which includes evaluating infrastructure and conducting design process. The analysis phase follows, and it concentrates on a thorough examination of every problem and business opportunity related to BI implementation. Furthermore, the data warehouse and ETL design processes are carried out and use PDI tool during the design phase. Finally, the implementation phase includes the selection and the use of BI software applications for analyzing and visualizing. Furthermore, the forecasting feature in the BI application can be used to make it easier for managers to predict future transactions by using times series predictions known as exponential smoothing. It is hoped that this research will result in a Dashboard System-based data visualization that will help managers make better decisions.

Computer Science,Business