Visualizing Drug Sales Data at Knia Pharma Using Business Intelligence
Keywords:
data visualization, decision-making, Tableau, business intelligence, ETLAbstract
Data visualization is a technique for presenting data in a form that is easy to understand. It supports the process of analysis so that more accurate conclusions can be drawn. Business Intelligence (BI) is one solution for a pharmacy to provide access to relevant data in support of decision-making. Increasingly tight business competition requires a pharmacy to make decisions quickly and accurately, so a tool such as Tableau is needed to process and visualize data into valuable information. This study collected data through interviews with the pharmacy owner to obtain the information requirements and applied the Business Intelligence Roadmap as the approach for analysis and the development of the visualization. Source data from spreadsheet files were integrated through an Extract, Transform, and Load (ETL) process and organized into a star schema before being visualized. The result of the study is a BI dashboard able to display drug-sales data in detail, thereby assisting the pharmacy owner in the business decision-making process. The visualization reveals drug-sales patterns that can be used to increase profit in the future.
References
[1] K. M. Hidayat, Mardiani, and S. Warisman, “Perancangan data warehouse transaksi obat-obatan pada RS. ABC Palembang,” pp. 1–10, 2013.
[2] D. Aryanti and J. Setiawan, “Visualisasi data penjualan dan produksi PT Nitto Alam Indonesia periode 2014–2018,” 2018.
[3] A. Bachtiar, Dharmayanti, and Husnaisa, “Visualisasi data terbuka ketahanan pangan Provinsi Jawa Barat,” 2017.
[4] D. Saepuloh, “Visualisasi data COVID-19 Provinsi DKI Jakarta menggunakan Tableau,” 2020.
[5] S. Negash, “Business intelligence,” Communications of the Association for Information Systems, vol. 13, Art. no. 15, 2004. Available: https://doi.org/10.17705/1CAIS.01315
[6] H. Chen, R. H. L. Chiang, and V. C. Storey, “Business intelligence and analytics: From big data to big impact,” MIS Quarterly, vol. 36, no. 4, pp. 1165–1188, 2012. Available: https://doi.org/10.2307/41703503
[7] R. Kimball and M. Ross, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd ed. Indianapolis, IN, USA: John Wiley & Sons, 2013. Available: https://www.wiley.com/en-gb/the-data-warehouse-toolkit-the-definitive-guide-to-dimensional-modeling-3rd-edition-p-9781118530801
[8] C. M. Olszak and E. W. Ziemba, “Approach to building and implementing business intelligence systems,” Interdisciplinary Journal of Information, Knowledge, and Management, vol. 2, pp. 135–148, 2007. Available: https://doi.org/10.28945/105
[9] N. Côrte-Real, T. Oliveira, and P. Ruivo, “Assessing business value of Big Data Analytics in European firms,” Journal of Business Research, vol. 70, pp. 379–390, 2017. Available: https://doi.org/10.1016/j.jbusres.2016.08.011
[10] S. Few, Information Dashboard Design: Displaying Data for At-a-Glance Monitoring, 2nd ed. Burlingame, CA, USA: Analytics Press, 2013. Available: https://www.analyticspress.com/idd.php
[11] O. M. Yigitbasioglu and O. Velcu, “A review of dashboards in performance management: Implications for design and research,” International Journal of Accounting Information Systems, vol. 13, no. 1, pp. 41–59, 2012. Available: https://doi.org/10.1016/j.accinf.2011.08.002
[12] L. M. Padilla, S. H. Creem-Regehr, M. Hegarty, and J. K. Stefanucci, “Decision making with visualizations: A cognitive framework across disciplines,” Cognitive Research: Principles and Implications, vol. 3, Art. no. 29, 2018. Available: https://doi.org/10.1186/S41235-018-0120-9
[13] S. Hjelle, P. Mikalef, N. Altwaijry, and V. Parida, “Organizational decision making and analytics: An experimental study on dashboard visualizations,” Information & Management, vol. 61, no. 6, Art. no. 104011, 2024. Available: https://doi.org/10.1016/j.im.2024.104011
[14] B. Wixom and H. Watson, “The BI-based organization,” International Journal of Business Intelligence Research, vol. 1, no. 1, pp. 13–28, 2010. Available: https://doi.org/10.4018/jbir.2010071702
[15] N. Ain, G. Vaia, W. DeLone, and M. Waheed, “Two decades of research on business intelligence system adoption, utilization and success: A systematic literature review,” Decision Support Systems, vol. 125, Art. no. 113113, 2019. Available: https://doi.org/10.1016/j.dss.2019.113113
[16] V.-H. Trieu, “Getting value from business intelligence systems: A review and research agenda,” Decision Support Systems, vol. 93, pp. 111–124, 2017. Available: https://doi.org/10.1016/j.dss.2016.09.019
[17] W. Yeoh and A. Koronios, “Critical success factors for business intelligence systems,” Journal of Computer Information Systems, vol. 50, no. 3, pp. 23–32, 2010. Available: https://scholar.google.com/scholar?q=Yeoh+Koronios+Critical+Success+Factors+for+Business+Intelligence+Systems+2010
[18] R. A. Williams, N. J. Sheikh, G. M. Duman, and E. Kongar, “Critical success factors of business intelligence systems implementation,” IEEE Engineering Management Review, 2022. Available: https://doi.org/10.1109/EMR.2022.3197096
[19] V. L. Sauter, Decision Support Systems for Business Intelligence, 2nd ed. Hoboken, NJ, USA: John Wiley & Sons, 2010. Available: https://doi.org/10.1002/9780470634431
[20] S. Arikunto, Prosedur Penelitian: Suatu Pendekatan Praktik. Jakarta, Indonesia: Rineka Cipta, 2014.
[21] L. T. Moss and S. Atre, Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications. Boston, MA, USA: Addison-Wesley, 2003.
[22] A. I. Y. Fatah, “Implementasi data warehouse dan data mining untuk penentuan rencana strategis penjualan batik,” 2014.
