Strategic Implementation of Big Data Automation for Wastage Management Reporting Using Analytical Hierarchy Process in The Tobacco Industry

Ilham Guspuji Maulana; Yos Sunitiyoso

doi:10.35877/454RI.qems2623

Ilham Guspuji Maulana School of Business Management, Institut Teknologi Bandung, Bandung, Indonesia (ID)
Yos Sunitiyoso School of Business Management, Institut Teknologi Bandung, Bandung, Indonesia (ID)

https://doi.org/10.35877/454RI.qems2623

Keywords: AHP, Big Data Automation, Power BI, Data Visualization, Data and Analytics

Viewed = 0 time(s)

Abstract

In today's data-driven era, big data automation is crucial, often referred to as "the new oil." Industries, particularly the fast-moving consumer goods (FMCG) sector like the tobacco industry, must undergo digital transformation to stay competitive. The integration of big data automation with reporting processes is significantly correlated, as it can automate repetitive reporting tasks, enhancing efficiency. This automation enables decision-makers to make faster and more accurate decisions.

This research focuses on assessing the capacity and factors involved in the collaboration between the operations department and the digital team to automate repetitive reporting processes by integrating big data from various sources such as SAP and Microsoft Forms. The study employs a combination of qualitative and quantitative methods, along with the Analytic Hierarchy Process (AHP), to identify optimal business solutions. Insights from this research prioritize big data automation and reporting projects to meet business needs. Results indicate among four alternative project groups, the Central Data Wastage project is the top priority with a score of 51.7%, followed by SMD Wastage at 25.2%, PMD Wastage at 14.7%, and FMD Wastage at 8.4%. Five stakeholders participated in this research, including a product manager, business user, business analyst, and two developers. These participants contributed to assessing criteria, sub-criteria, and alternative project groups. This research not only helps prioritize projects but also facilitates seamless digitalization within the operations team, fostering synergy with the digital team.

References

Boopathy, S., Kumar, P. S., & Karaaslan, M. (2022). Predictive Analytics with Data Visualization. Journal of Ubiquitous Computing and Communication Technologies, 4(2), 75–96. https://doi.org/10.36548/jucct.2022.2.003

Bulut, E., & Duru, O. (2018). Analytic Hierarchy Process (AHP) in Maritime Logistics: Theory, Application and Fuzzy Set Integration. In International Series in Operations Research and Management Science (Vol. 260, Issue January 2018). Springer International Publishing AG 2018. https://doi.org/10.1007/978-3-319-62338-2_3

Goepel, K. (2018). Implementation of an Online Software Tool for the Analytic Hierarchy Process (AHP-OS). International Journal of the Analytic Hierarchy Process, 10(3), 469–487. https://doi.org/10.13033/IJAHP.V10I3.590

Han, Y., Wang, Y., Chai, F., Ma, J., & Li, L. (2020). Biofilters for the co-treatment of volatile organic compounds and odors in a domestic waste landfill site. Journal of Cleaner Production, 277. https://doi.org/https://doi.org/10.1016/j.jclepro.2020.124012

Ishizaka, A., & Labib, A. (2011). Review of the main developments in the analytic hierarchy process. Expert Systems with Applications, 38(11), 14336–14345. https://doi.org/10.1016/J.ESWA.2011.04.143

Kumar, R., Madhu, E., Dahiya, A., & Sinha, S. (2015). Analytical hierarchy process for assessing sustainability. World Journal of Science, Technology and Sustainable Development, 12(4), 281–293. https://doi.org/10.1108/WJSTSD-05-2015-0027

Novotny, T. E., Bialous, S. A., Burt, L., Curtis, C., Luiza Da Costa, V., Usman Iqtidar, S., Liu, Y., Pujari, S., & Tursan D’espaignet, & E. (2015). The environmental and health impacts of tobacco agriculture, cigarette manufacture and consumption. Bull World Health Organ, 93. https://doi.org/10.2471/BLT.15.152744

Saaty, T. L. (2002). Decision making with the Analytic Hierarchy Process. Scientia Iranica, 9(3), 215–229. https://doi.org/10.1504/IJSSCI.2008.017590

Sadh, P. K., Kumar, S., Chawla, P., & Duhan, J. S. (2018). Fermentation: A boon for production of bioactive compounds by processing of food industries wastes (By-Products). Molecules, 23(10). https://doi.org/10.3390/molecules23102560

Sinambela, A. D. D., Zahra, A., & Jaman, J. K. (2024). Using Power BI to Apply Business Intelligence to Product Sales. Sistemasi: Jurnal Sistem Informasi, 13(2), 506–516. https://doi.org/10.32520/STMSI.V13I2.3036

Toufaili, A. El, Pozzetto, D., Padoano, E., Toneatti, L., & Fakhoury, G. (2023). Selection of a Suitable Waste to Energy Technology for Greater Beirut Area Using the Analytic Hierarchy Process. International Journal of Environmental Science and Development, 14(6), 340–347. https://doi.org/10.18178/ijesd.2023.14.6.1453

Velasquez, M., & Hester, P. T. (2013). An Analysis of Multi-Criteria Decision Making Methods.

Wallbank, L. A., MacKenzie, R., & Beggs, P. J. (2017). Environmental impacts of tobacco product waste: International and Australian policy responses. Ambio, 46(3), 361–370. https://doi.org/10.1007/s13280-016-0851-0

Yolanda, V. C., & Heriyanti, A. P. (2024). Wastewater Quality Characteristics Test in Domestic Wastewater Treatment Plant Dinas Lingkungan Hidup Kota Semarang. Indonesian Journal of Earth and Human, 1, 44–52. https://journal.unnes.ac.id/journals/ijeh/article/download/2678/235/8694