Utilization of Business Intelligence in Sales Information Systems
Article Sidebar
Main Article Content
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%.
Article Details
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
References
A. A. Nurdin and D. Djuniadi, “Securing audio chat with cryptool-based twofish algorithm,” J. Soft Comput. Explor., pp. 37–43, 2022, doi: 10.52465/joscex.v3i1.65.
A. Amirullah et al., “Penerapan Perencanaan Strategis SI/TI Dengan Metode Ward & Perppard Pada UMKM Kuliner,” J. Sist. Inf., vol. 14, no. 1, pp. 2599–2610, 2022.
Z. Sun, K. Strang, and S. Firmin, “Business analytics-based enterprise information systems,” J. Comput. Inf. Syst., vol. 57, no. 2, pp. 169–178, 2017, doi: 10.1080/08874417.2016.1183977.
D. Arnott, F. Lizama, and Y. Song, “Patterns of business intelligence systems use in organizations,” Decis. Support Syst., vol. 97, pp. 58–68, 2017, doi: 10.1016/j.dss.2017.03.005.
Y. Duan, G. Cao, and J. S. Edwards, “Understanding the impact of business analytics on innovation,” Eur. J. Oper. Res., vol. 281, no. 3, pp. 673–686, 2020, doi: 10.1016/j.ejor.2018.06.021.
T. H. Davenport, “From analytics to artificial intelligence,” J. Bus. Anal., vol. 1, no. 2, pp. 73–80, 2018, doi: 10.1080/2573234X.2018.1543535.
L. Fink, N. Yogev, and A. Even, “Business intelligence and organizational learning: An empirical investigation of value creation processes,” Inf. Manag., vol. 54, no. 1, pp. 38–56, 2017, doi: 10.1016/j.im.2016.03.009.
L. M. D. Yiu, A. C. L. Yeung, and T. C. E. Cheng, “The impact of business intelligence systems on profitability and risks of firms,” Int. J. Prod. Res., vol. 59, no. 13, pp. 3951–3974, 2021, doi: 10.1080/00207543.2020.1756506.
P. Rikhardsson and O. Yigitbasioglu, “Business intelligence & analytics in management accounting research: Status and future focus,” Int. J. Account. Inf. Syst., vol. 29, no. February, pp. 37–58, 2018, doi: 10.1016/j.accinf.2018.03.001.
N. A. Jalil, P. Prapinit, M. Melan, and A. Bin Mustaffa, “Adoption of business intelligence - Technological, individual and supply chain efficiency,” Proc. - 2019 Int. Conf. Mach. Learn. Big Data Bus. Intell. MLBDBI 2019, pp. 67–73, 2019, doi: 10.1109/MLBDBI48998.2019.00021.
L. M. D. Yiu, A. C. L. Yeung, and A. P. L. Jong, “Business intelligence systems and operational capability: an empirical analysis of high-tech sectors,” Ind. Manag. Data Syst., vol. 120, no. 6, pp. 1195–1215, 2020, doi: 10.1108/IMDS-12-2019-0659.
N. P. Rana, S. Chatterjee, Y. K. Dwivedi, and S. Akter, “Understanding dark side of artificial intelligence (AI) integrated business analytics: assessing firm’s operational inefficiency and competitiveness,” Eur. J. Inf. Syst., vol. 31, no. 3, pp. 364–387, 2022, doi: 10.1080/0960085X.2021.1955628.
D. Appelbaum, A. Kogan, M. Vasarhelyi, and Z. Yan, “Impact of business analytics and enterprise systems on managerial accounting,” Int. J. Account. Inf. Syst., vol. 25, no. April, pp. 29–44, 2017, doi: 10.1016/j.accinf.2017.03.003.
K. Conboy, P. Mikalef, D. Dennehy, and J. Krogstie, “Using business analytics to enhance dynamic capabilities in operations research: A case analysis and research agenda,” Eur. J. Oper. Res., vol. 281, no. 3, pp. 656–672, 2020, doi: 10.1016/j.ejor.2019.06.051.
R. Eidizadeh, R. Salehzadeh, and A. C. Esfahani, “Analysing the role of business intelligence, knowledge sharing and organisational innovation on gaining competitive advantage,” J. Work. Learn., vol. 29, no. 4, pp. 250–267, 2017, doi: 10.1108/JWL-07-2016-0070.
Y. Niu, L. Ying, J. Yang, M. Bao, and C. B. Sivaparthipan, “Organizational business intelligence and decision making using big data analytics,” Inf. Process. Manag., vol. 58, no. 6, p. 102725, 2021, doi: 10.1016/j.ipm.2021.102725.
D. Delen and S. Ram, “Research challenges and opportunities in business analytics,” J. Bus. Anal., vol. 1, no. 1, pp. 2–12, 2018, doi: 10.1080/2573234X.2018.1507324.
Y. Park, O. A. El Sawy, and P. C. Fiss, “The Role of Business Intelligence and Communication Technologies in Organizational Agility: A Configurational Approach,” J. Assoc. Inf. Syst., vol. 18, no. 9, pp. 648–686, 2017, doi: 10.17705/1jais.00467.
B. M. Drake and A. Walz, “Evolving Business Intelligence and Data Analytics in Higher Education,” New Dir. Institutional Res., vol. 2018, no. 178, pp. 39–52, 2018, doi: 10.1002/ir.20266.
G. Richards, W. Yeoh, A. Y. L. Chong, and A. Popovič, “Business Intelligence Effectiveness and Corporate Performance Management: An Empirical Analysis,” J. Comput. Inf. Syst., vol. 59, no. 2, pp. 188–196, 2019, doi: 10.1080/08874417.2017.1334244.
R. Ramanathan, E. Philpott, Y. Duan, and G. Cao, “Adoption of business analytics and impact on performance: a qualitative study in retail,” Prod. Plan. Control, vol. 28, no. 11–12, pp. 985–998, 2017, doi: 10.1080/09537287.2017.1336800.
A. Popovič, R. Hackney, R. Tassabehji, and M. Castelli, “The impact of big data analytics on firms’ high value business performance,” Inf. Syst. Front., vol. 20, no. 2, pp. 209–222, 2018, doi: 10.1007/s10796-016-9720-4.
D. Skyrme and D. Amidon, “Managing extracted knowledge from big social media data for business decision making,” J. Knowl. Manag., vol. 1, no. 1, pp. 27–37, 1997.
A. A. Nurdin, “Decision support system for choosing the best tourist attractions using simple additive weighting (SAW) method,” J. Soft Comput. Explor., vol. 2, no. 2, pp. 77–85, 2021.
A. A. Nurdin, A. N. Pristanti, and N. Samantha, “Business process modeling at steak restaurant using business process model and notation,” J. Soft Comput. Explor., pp. 85–92, 2022, doi: 10.52465/joscex.v3i2.80.
M. K. Anam, T. Nasution, S. Erlinda, L. Efrizoni, and S. Susanti, “The Analysis and Optimization of Business Processes for Students in Higher Education Based on Togaf 9.2,” Sci. J. Informatics, vol. 8, no. 2, pp. 230–243, 2021, doi: 10.15294/sji.v8i2.29952.
V. H. Trieu, “Getting value from Business Intelligence systems: A review and research agenda,” Decis. Support Syst., vol. 93, pp. 111–124, 2017, doi: 10.1016/j.dss.2016.09.019.
Y. Chen and Z. Lin, “Business Intelligence Capabilities and Firm Performance: A Study in China,” Int. J. Inf. Manage., vol. 57, no. August 2020, p. 102232, 2021, doi: 10.1016/j.ijinfomgt.2020.102232.
T. Difa Anggrainy and A. Rusiana Sari, “Implementation of Extract, Transform, Load on Data Warehouse and Business Intelligence Using Pentaho and Tableau to Analyze Sales Performance of Olist Store,” Int. Res. J. Adv. Eng. Sci., vol. 7, no. 2, pp. 368–374, 2022.
M. Mariani, R. Baggio, M. Fuchs, and W. Höepken, “Business intelligence and big data in hospitality and tourism: a systematic literature review,” Int. J. Contemp. Hosp. Manag., vol. 30, no. 12, pp. 3514–3554, 2018, doi: 10.1108/IJCHM-07-2017-0461.
N. U. Ain, G. Vaia, W. H. DeLone, and M. Waheed, “Two decades of research on business intelligence system adoption, utilization and success – A systematic literature review,” Decis. Support Syst., vol. 125, no. July, p. 113113, 2019, doi: 10.1016/j.dss.2019.113113.
N. A. Mahoto, R. Iftikhar, A. Shaikh, Y. Asiri, A. Alghamdi, and K. Rajab, “An intelligent business model for product price prediction using machine learning approach,” Intell. Autom. Soft Comput., vol. 30, no. 1, pp. 147–159, 2021, doi: 10.32604/iasc.2021.018944.
M. R. Llave, “Business Intelligence and Analytics in Small and Medium-sized Enterprises: A Systematic Literature Review,” Procedia Comput. Sci., vol. 121, pp. 194–205, 2017, doi: 10.1016/j.procs.2017.11.027.
P. B. Seddon, D. Constantinidis, T. Tamm, and H. Dod, “How does business analytics contribute to business value?,” Inf. Syst. J., vol. 27, no. 3, pp. 237–269, 2017, doi: 10.1111/isj.12101.
D. Sledgianowski, M. Gomaa, and C. Tan, “Toward integration of Big Data, technology and information systems competencies into the accounting curriculum,” J. Account. Educ., vol. 38, pp. 81–93, 2017, doi: 10.1016/j.jaccedu.2016.12.008.
M. H. P. Swari, M. Qusyairi, E. P. Mandyartha, and H. E. Wahanani, “Business Intelligence System using Simple Moving Average Method (Case Study : Sales Medical Equipment at PT. Semangat Sejahtera Bersama),” J. Phys. Conf. Ser., vol. 1899, no. 1, 2021, doi: 10.1088/1742-6596/1899/1/012121.
W. Yunus, R. I. Desanti, and W. Wella, “Data Visualization And Sales Prediction of PD. Asia Agung (Ajinomoto) Pontianak in 2019,” IJNMT (International J. New Media Technol., vol. 7, no. 2, pp. 51–57, 2020, doi: 10.31937/ijnmt.v7i2.1697.
R. Bakri, U. Data, and A. Saputra, “Marketing Research : The Application of Auto Sales Forecasting Software to Optimize Product Marketing Strategies,” J. Appl. Sci. Eng. Technol. Educ., vol. 1, no. 1, pp. 6–12, 2019, doi: 10.35877/454ri.asci1124.
O. Müller, M. Fay, and J. vom Brocke, “The Effect of Big Data and Analytics on Firm Performance: An Econometric Analysis Considering Industry Characteristics,” J. Manag. Inf. Syst., vol. 35, no. 2, pp. 488–509, 2018, doi: 10.1080/07421222.2018.1451955.
R. Torres, A. Sidorova, and M. C. Jones, “Enabling firm performance through business intelligence and analytics: A dynamic capabilities perspective,” Inf. Manag., vol. 55, no. 7, pp. 822–839, 2018, doi: 10.1016/j.im.2018.03.010.
A. Ashrafi, A. Zare Ravasan, P. Trkman, and S. Afshari, “The role of business analytics capabilities in bolstering firms’ agility and performance,” Int. J. Inf. Manage., vol. 47, no. January, pp. 1–15, 2019, doi: 10.1016/j.ijinfomgt.2018.12.005.
V. Grover, R. H. L. Chiang, T. P. Liang, and D. Zhang, “Creating Strategic Business Value from Big Data Analytics: A Research Framework,” J. Manag. Inf. Syst., vol. 35, no. 2, pp. 388–423, 2018, doi: 10.1080/07421222.2018.1451951.
S. F. Wamba, A. Gunasekaran, S. Akter, S. J. fan Ren, R. Dubey, and S. J. Childe, “Big data analytics and firm performance: Effects of dynamic capabilities,” J. Bus. Res., vol. 70, pp. 356–365, 2017, doi: 10.1016/j.jbusres.2016.08.009.
S. Ji-fan Ren, S. Fosso Wamba, S. Akter, R. Dubey, and S. J. Childe, “Modelling quality dynamics, business value and firm performance in a big data analytics environment,” Int. J. Prod. Res., vol. 55, no. 17, pp. 5011–5026, 2017, doi: 10.1080/00207543.2016.1154209.
M. Alnoukari and A. Hanano, “Integration of business intelligence with corporate strategic management,” J. Intell. Stud. Bus., vol. 10, no. 3, pp. 38–62, 2020.
C. Cheng, H. Zhong, and L. Cao, “Facilitating speed of internationalization: The roles of business intelligence and organizational agility,” J. Bus. Res., vol. 110, no. February 2019, pp. 95–103, 2020, doi: 10.1016/j.jbusres.2020.01.003.
P. Tong-On, S. Siripipatthanakul, and B. Phayaphrom, “The implementation of business intelligence using data analytics and its effects towards performance in hotel industry in Thailand,” Int. J. Behav. Anal., vol. 1, no. 2, pp. 1–17, 2021.
K. Božič and V. Dimovski, “Business intelligence and analytics use, innovation ambidexterity, and firm performance: A dynamic capabilities perspective,” J. Strateg. Inf. Syst., vol. 28, no. 4, p. 101578, 2019, doi: 10.1016/j.jsis.2019.101578.
B. Puklavec, T. Oliveira, and A. Popovič, “Understanding the Determinants of Business Intelligence System Adoption Stages : An Empirical Study of SMEs,” Ind. Manag. Data Syst., vol. 118, no. 1, pp. 236–261, 2018.
J. Q. Dong and C. H. Yang, “Business value of big data analytics: A systems-theoretic approach and empirical test,” Inf. Manag., vol. 57, no. 1, p. 103124, 2020, doi: 10.1016/j.im.2018.11.001.
A. Popovič, B. Puklavec, and T. Oliveira, “Justifying business intelligence systems adoption in SMEs: Impact of systems use on firm performance,” Ind. Manag. Data Syst., vol. 119, no. 1, pp. 210–228, 2019, doi: 10.1108/IMDS-02-2018-0085.
M. Banerjee and M. Mishra, “Retail supply chain management practices in India: A business intelligence perspective,” J. Retail. Consum. Serv., vol. 34, pp. 248–259, 2017, doi: 10.1016/j.jretconser.2015.09.009.
A. Griva, C. Bardaki, K. Pramatari, and D. Papakiriakopoulos, “Retail business analytics: Customer visit segmentation using market basket data,” Expert Syst. Appl., vol. 100, pp. 1–16, 2018, doi: 10.1016/j.eswa.2018.01.029.
F. E. Bordeleau, E. Mosconi, and L. A. de Santa-Eulalia, “Business intelligence and analytics value creation in Industry 4.0: a multiple case study in manufacturing medium enterprises,” Prod. Plan. Control, vol. 31, no. 2–3, pp. 173–185, 2020, doi: 10.1080/09537287.2019.1631458.
A. Gunasekaran, Y. Y. Yusuf, E. O. Adeleye, and T. Papadopoulos, “Agile manufacturing practices: the role of big data and business analytics with multiple case studies,” Int. J. Prod. Res., vol. 56, no. 1–2, pp. 385–397, 2018, doi: 10.1080/00207543.2017.1395488.
L. P. K. Ade, A. M. Akanbi, and A. I. Tubosun, “The influence of marketing intelligence on business competitive advantage (a study of diamond bank Plc),” J. Compet., vol. 9, no. 1, pp. 51–71, 2017, doi: 10.7441/joc.2017.01.04.
S. Ahmad, S. Miskon, R. Alabdan, and I. Tlili, “Towards sustainable textile and apparel industry: Exploring the role of business intelligence systems in the era of industry 4.0,” Sustain., vol. 12, no. 7, 2020, doi: 10.3390/su12072632.
Z. xiong Huang, K. S. Savita, and J. Zhong-jie, “The Business Intelligence impact on the financial performance of start-ups,” Inf. Process. Manag., vol. 59, no. 1, p. 102761, 2022, doi: 10.1016/j.ipm.2021.102761.
U. R. Kulkarni, J. A. Robles-Flores, and A. Popovič, “Business intelligence capability: The effect of top management and the mediating roles of user participation and analytical decision making orientation,” J. Assoc. Inf. Syst., vol. 18, no. 7, pp. 516–541, 2017, doi: 10.17705/1jais.00462.
A. S. Aydiner, E. Tatoglu, E. Bayraktar, S. Zaim, and D. Delen, “Business analytics and firm performance: The mediating role of business process performance,” J. Bus. Res., vol. 96, no. November 2018, pp. 228–237, 2019, doi: 10.1016/j.jbusres.2018.11.028.
M. Kraus, S. Feuerriegel, and A. Oztekin, “Deep learning in business analytics and operations research: Models, applications and managerial implications,” Eur. J. Oper. Res., vol. 281, no. 3, pp. 628–641, 2020, doi: 10.1016/j.ejor.2019.09.018.
H. D. Yulianto and R. Fauzi, “Design of Web-based Online Sales Information System,” IOP Conf. Ser. Mater. Sci. Eng., vol. 879, no. 1, pp. 1–10, 2020, doi: 10.1088/1757-899X/879/1/012007.
S. B. Montgomery, T. Lappalainen, M. Gutierrez-Arcelus, and E. T. Dermitzakis, “Rare and common regulatory variation in Population-Scale sequenced human genomes,” PLoS Genet., vol. 7, no. 7, 2011, doi: 10.1371/journal.pgen.1002144.
S. Oliver, A. M. Marpaung, and M. Galinium, “Developing Food Sensory Analysis Information System using Waterfall Software Engineering Model,” J. Appl. Information, Commun. Technol., vol. 4, no. 2, pp. 63–81, 2017, doi: 10.33555/ejaict.v4i2.85.
V. Apriana and S. Fauziah, “Applying Waterfall Method on Sales Information System,” J. Mantik, vol. 5, no. 36, pp. 820–826, 2021.
N. U. Nabilla and S. Hidayat, “Pengembangan Business Intelligence Pada Sistem Informasi Distributor,” Univ. Islam Indones. Yogyakarta, vol. 2, no. 2, pp. 1–5, 2021, [Online]. Available: https://journal.uii.ac.id/AUTOMATA/article/view/19503.
T. Thesing, C. Feldmann, and M. Burchardt, “Agile versus Waterfall Project Management: Decision model for selecting the appropriate approach to a project,” Procedia Comput. Sci., vol. 181, pp. 746–756, 2021, doi: 10.1016/j.procs.2021.01.227.