Utilization of Business Intelligence in Sales Information Systems

Abstract

Business intelligence is one of the concepts that can facilitate the process of processing data of a company which will later become the basis for the decision-making process of the sales process. Distributor company needs an information system that can help the company in managing and analyzing data and can make sales and profit predictions in the future. This study aims to create an information system that can visualize data analysis and the results of forecasting sales data by avocado fruit distributor companies. In this study, we will apply the concept of Business Intelligence using Power BI Desktop which is equipped with sales prediction analysis on the sales information system. The data processing process in this study uses the process of integrating Excel tools with Power BI Desktop. The dataset of sales in this study was obtained from the Kaggle site and the software development in this study using the SDLC (system development life cycle) waterfall development method. In this study, we found that the development of business intelligence in the sales information system provides convenience that can be felt by distributors, namely in terms of revenue and time. In this case, forecasting is done with the forecast feature in Power BI Desktop with a confidence interval of 95%.