Implementation of Business Intelligence for Decision Making in the Inventory Process of the Logistics Area
Implementation of Business Intelligence for Decision Making in the Inventory Process of the Logistics Area |
||
 |
 |
|
| © 2023 by IJETT Journal | ||
| Volume-71 Issue-10 |
||
| Year of Publication : 2023 | ||
| Author : Christian Salvador-Callalli, Laberiano Andrade-Arenas |
||
| DOI : 10.14445/22315381/IJETT-V71I10P229 | ||
How to Cite?
Christian Salvador-Callalli, Laberiano Andrade-Arenas, "Implementation of Business Intelligence for Decision Making in the Inventory Process of the Logistics Area," International Journal of Engineering Trends and Technology, vol. 71, no. 10, pp. 326-335, 2023. Crossref, https://doi.org/10.14445/22315381/IJETT-V71I10P229
Abstract
Due to technological progress, organizations tend to improve in the technological aspect, emphasizing the logistics sector; this represents an advantage in the market due to the agility of its procedures. Companies belonging to the logistics sector or those that have this area in their organizational structure lack intelligent technology in their inventory process, so the logistics area is exposed to common errors of workers in terms of maintaining adequate supply, the rapid execution in the way of how to send a certain item and reliability in the classic Excel books for their ability to generate small reports. Based on the above, the main motive of the present research work is implementing a business intelligence solution to support the mentioned process, mainly by effectively using historical data stored on the company's server. During the project's development, the Kimball methodology was used, which is precisely designed to delimit step by step the complete procedure for the management of analytical projects, which influences the design of the most relevant information for the company. The implementation of this solution is intended to achieve the objective of this work, to generate high competitiveness in logistics through the automation of manual activities and help in decision-making.
Keywords
Logistics sector, Kimball methodology, Business intelligence, Data visualization, Decision making.
References
[1] Ahmad Obidat, Zaid Alziyadat, and Zaid Alabaddi, “Assessing the Effect of Business Intelligence on Supply Chain Agility. A Perspective from the Jordanian Manufacturing Sector,” Uncertain Supply Chain Management, vol. 11, no. 1, pp. 61–70, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[2] Simone Caruso et al., “Artificial Intelligence to Counteract ‘KPI Overload’ in Business Process Monitoring: The Case of Anti-Corruption in Public Organizations,” Business Process Management Journal, vol. 29, no. 4, pp. 1227–1248, 2023.
[Google Scholar] [Publisher Link]
[3] Jianwen Wang et al., “Business Intelligence Ability to Enhance Organizational Performance and Performance Evaluation Capabilities by Improving Data Mining Systems for Competitive Advantage,” Information Processing & Management, vol. 59, no. 6, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[4] Uday Kulkarni, Jose A. Robles-Flores, and Ales Popovic, “Business Intelligence Capability: The Effect of Top Management and the Mediating Roles of User Participation and Analytical Decision Making Orientation,” Journal of the Association for Information Systems, vol. 18, no. 7, pp. 516–541, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[5] Luis David Huallpa Tapia et al., “Application of Business Intelligence to Improve Utilities by Increasing Customer Satisfaction in Restaurants,” Proceedings of the 17th LACCEI International Multi-Conference for Engineering, Education and Technology, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[6] Lingzhe Liu, Hennie Daniels, and Ron Triepels, “Auditing Data Reliability in International Logistics-An Application of Bayesian Networks,” Proceedings of the 16th International Conference on Enterprise Information Systems, vol. 2, pp. 707-712, 2014.
[CrossRef] [Google Scholar] [Publisher Link]
[7] Andre M.R. Wajong, “Logistics Indicators Could Improve Logistics Performance of Hospitals,” MATEC Web of Conferences, vol. 108, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[8] Dong-Hui Jin, and Hyun-Jung Kim, “Integrated Understanding of Big Data, Big Data Analysis, and Business Intelligence: A Case Study of Logistics,” Sustainability, vol. 10, no. 10, pp. 1-15, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[9] Pablo Castillo Chura et al., “Datamart of Business Intelligence for the Sales Area of a Peruvian Tourism Company,” R. Silhavy, P. Silhavy, and Z. Prokopova (eds), Data Science and Algorithms in Systems, CoMeSySo 2022, Lecture Notes in Networks and Systems, Springer, Cham, vol. 597, pp. 415-429, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[10] Alexi Delgado, Fernando Rosas, and Chiara Carbajal, “System of Business Intelligence in a Health Organization using the Kimball Methodology,” 2019 IEEE CHILEAN Conference on Electrical, Electronics Engineering, Information and Communication Technologies, CHILECON, pp. 1-5, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[11] Ruiz Chan, and Yong Lopez, “Analysis and Proposal for the Application of a Business Intelligence Model to Improve Decision Making in the Last Mile Logistics Service Case: Nirex,” Thesis, The Professional Tittle of Bachelor of Management with a Mention in Management Business, 2021.
[Google Scholar] [Publisher Link]
[12] Jose Richard Barrenechea Minaya, “Implementation of Business Intelligence with the BEGA Methodology for Decision Making by the Head of Logistics at the San Sebastián SAC Transport Company,” Thesis, Academic Degree of Master in Systems Engineering with a Mention in Information Technologies, 2020.
[Google Scholar] [Publisher Link]
[13] Jimmy David Agüero Zevallos, “Application of Business Intelligence for Decision Making in Small and Medium-Sized Businesses in the Province of Pasco,” Thesis, Computer and Systems Engineer, 2019.
[Google Scholar] [Publisher Link]
[14] M. Carlos H. Bolaños et al., “Business Intelligence for the Analysis of Road Accidents in the City of Popayán,” Iberian Journal of Information Systems and Technologies, 130–141, 2020.
[Google Scholar] [Publisher Link]
[15] Youssra Riahi, “Business Intelligence: A Strategy for Business Development,” SSRG International Journal of Economics and Management Studies, vol. 4, no. 9, pp. 1-5, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[16] Abba Suganda Girsang, and Andhika Purwanto, “Controlling System for Stock Raw Material for Production Planning and Inventory Control in A Pharmacy Company,” International Review of Mechanical Engineering, vol. 11, no. 11, pp. 855–861, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[17] Wilson Castillo-Rojas, Fernando Medina Quispe, and Francisco Fariña Molina, “A Methodology for Data Warehousing Processes Based on Experience,” RISTI - Ibérica Magazine of Information Systems and Technologies, pp. 83–103, 2018.
[Google Scholar] [Publisher Link]
[18] A.M. Purnamasari et al., “Business Intelligent in an E-Commerce Industry,” IOP Conference Series: Materials Science and Engineering, vol. 598, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[19] Kiefer Stefano Ranti et al., “Data Warehouse for Analyzing Music Sales on a Digital Media Store,” Journal of Physics: Conference Series, vol. 1477, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[20] Forero-Castañeda Deivy Alexander, and Sánchez-Garcia Jorge Armando, “Introduction to Business Intelligence based on KIMBALL Methodology,” Revista Technology Investigación Academia TIA, vol. 9, no. 1, pp. 5–17, 2022.
[Google Scholar] [Publisher Link]
[21] Viktor László Takács et al., “Data Warehouse Hybrid Modeling Methodology,” Data Science Journal, vol. 19, no. 1, pp. 1–23, 2020.
[CrossRef] [Google Scholar] [Publisher Link]