Business Intelligence to Optimize Decision-Making in a Telecommunication Company

Business Intelligence to Optimize Decision-Making in a Telecommunication Company
  IJETT-book-cover           
  
© 2023 by IJETT Journal
Volume-71 Issue-8
Year of Publication : 2023
Author : Ronny Elmer Mallma Trujillo, Santiago Domingo Moquillaza Henríquez, Miguel Angel Cano Lengua
DOI : 10.14445/22315381/IJETT-V71I8P208

How to Cite?

Ronny Elmer Mallma Trujillo, Santiago Domingo Moquillaza Henríquez, Miguel Angel Cano Lengua, "Business Intelligence to Optimize Decision-Making in a Telecommunication Company," International Journal of Engineering Trends and Technology, vol. 71, no. 8, pp. 85-101, 2023. Crossref, https://doi.org/10.14445/22315381/IJETT-V71I8P208

Abstract
This article presents an implementation of business intelligence in the sales area with the objective of optimizing decision-making in a telecommunications company because there is not good quality of reports and satisfaction in the use of reports is not suitable for correct decision-making due to the lengthy time it takes to do it manually, in addition, the quality is not optimal for data analysis. A Data Mart was developed under the Ralph Kimball methodology adapted to the agile Scrum methodology. Finally, software quality tests were carried out for BI implementation according to ISO/IEC 25010. The expected results were obtained regarding the improvement in report generation time of 97.22 %, an improvement in the data quality of the reports by 29.08%, an improvement in user satisfaction by 40% and finally, the perception in decision-making was optimized by 38.66%, according to the results it was concluded that business intelligence provides notable benefits regarding the quality of information, report generation time to make optimal decisions and improvement of decision making. For the telecommunications scenario, this research is important since, in the literature review, it is not observed papers that narrate the implementation of a business intelligence solution applied to the telecommunications sector.

Keywords
Business intelligence, Decision making, Telecommunications, Ralph Kimball, ISO/IEC 25010.

References
[1] Georgia Garani et al., “A Data Warehouse Approach for Business Intelligence,” IEEE 28th International Conference on Enabling Technologies: Infrastructure for Collaborative Enterprises, pp. 70-75, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[2] Sasiwimon Tanphet, and Paweena Wanchai, “Applying Business Intelligence Technology for Equipment Maintenance and Repair Plan of Telecommunications Services Provider,” 20th International Conference on Advanced Communication Technology, pp. 448-453, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[3] Mohamed Al-Zadjali, and Kamla Ali Al-Busaidi, “The Values of BI-Empowered Customer Service in Telecom,” International Journal of Electronic Customer Relationship Management, vol. 11, no. 4, pp. 363-383, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[4] Jerzy Kisielnicki, and Anna Maria Misiak, “Effectiveness of Agile Compared to Waterfall Implementation Methods in IT Projects: Analysis Based on Business Intelligence Projects,” Faculty of Management, vol. 9, no. 1, pp. 273-286, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[5] M. Suresh Babu, K. Bhavana Raj, and D. Asha Devi, “Future Trends of Business Intelligence and Big Data Analytics in Ubiquitous Environment,” International Journal of Engineering and Advanced Technology, vol. 8, no. 3s, pp. 773-778, 2019.
[Google Scholar] [Publisher Link]
[6] T. D. La and R. Martín, “System Based on Business Intelligence for the Generation of Reports According to the Levels of Services that Govern the Technical Support Area for Technology Companies,” pp. 1-8, 2020.
[7] Fakhri Alam Khan et al., “Efficient Data Access and Performance Improvement Model for Virtual Data Warehouse,” Sustainable Cities and Society, vol. 35, pp. 232–240, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[8] O. Yazidi Alaoui et al., “Creating Strategic Business Value from Big Data Analysis - Application Telecom Network Data and Planning Documents,” International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, pp. 691–695, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[9] Staffs Keele, “Guidelines for Performing Systematic Literature Reviews in Software Engineering,” EBSE Technical Report, 2007.
 [Google Scholar] [Publisher Link]
[10] Dhamotharan Seenivasan, “Improving the Performance of the ETL Jobs,” International Journal of Computer Trends and Technology, vol. 71, no. 3, pp. 27-33, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[11] Mohd Arif Fahmi Bidin, and Alwi Mohd Yunus, “Business Intelligence Using Data Mining for Organizational Sustainability: A Case Study of Digi Telecommunication SdnBhd,” International Journal of Academic Research in Business and Social Sciences, vol. 7, no. 12, pp. 471-485, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[12] Dani Abu Ghaida, “The Influence of Organisational and Technological Factors on BI Adoption in the Telecommunication Industry across the Middle East and Africa,” Journal for Global Business Advancement, vol. 11, no. 3, pp. 332-350, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[13] Sidra Ashraf, and Shoab A. Khan, “Visualizations-based Analysis of Telco Data for Business Intelligence,” 6th IEEE International Conference on Software Engineering and Service Science, pp. 242-246, 2015.
[CrossRef] [Google Scholar] [Publisher Link]
[14] Chiung-I Chang, and Jui-Chih Ho, “Two-layer Clustering Model for Mobile Customer Analysis,” IT Professional, vol. 19, no. 3, pp. 38-44, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[15] Gnanakurubaran Luxman, and Mascrenghe M. Alroy, “An Empirical Study to Identify the Causes of Customer Chrun in the Telecommunication Industry and Customer Loyalty,” 3rd Interdisciplinary Conference of Management Researchers, 2018.
 [Publisher Link]
[16] Rokhmatul Insani, and Hira Laksmiwati Soemitro, “Business Intelligence for Profiling of Telecommunication Customers,” Second Asia Pacific Conference on Advanced Research, 2016.
 [Google Scholar] [Publisher Link]
[17] V.D. Kolychev, and А.А. Shebotinov, “Application of Business Intelligence Instrumental Tools for Visualization of Key Performance Indicators of an Enterprise in Telecommunications,” Scientific Visualization, vol. 11, no. 1, pp. 20–37, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[18] Lior Fink, NirYogev, and Adir Even, “Business Intelligence and Organizational Learning: An Empirical Investigation of Value Creation Processes,” Information & Management, vol. 54, no. 1, pp. 38–56, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[19] M. Al-Hasan, and M.S. Hossain, “Adapting SCRUM in Data Analytics Solution Development for Telecom Operators in Bangladesh,” International Conference on Electrical, Computer and Communication Engineering, pp. 1-5, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[20] Giridhar Maji, and Soumya Sen, “A Data Warehouse Based Analysis on CDR to Depict Market Share of Different Mobile Brands,” Annual IEEE India Conference, pp. 1-6, 2015.
[CrossRef] [Google Scholar] [Publisher Link]
[21] Giridhar Maji, and Soumya Sen, “Data Warehouse Based Analysis on CDR to Retain and Acquire Customers by Targeted Marketing,” 5th International Conference on Reliability, Infocom Technologies and Optimization (Trends and Future Directions), pp. 221-227, 2016.
[CrossRef] [Google Scholar] [Publisher Link]
[22] Preethi Subramanian, and Sellappan Palaniappan, “Telecom Network Monitoring and Fault Isolation with Visual Analytics,” Proceedings of the 2nd International Conference on Software Engineering and Information Management, pp. 54-58, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[23] Revo Faris Saifuddin, Rachmadita Andreswari, and Edi Sutoyo, “Design of Business Intelligence Dashboard to Support Decisions in Provision of Network Services Based on Telkomsel Internet Network Traffic using the Business Dimensional Lifecycle Method,” eProceedings of Engineering, vol. 8, no. 4, 2021.
 [Google Scholar] [Publisher Link]
[24] ParthaPratim Ray, “A Survey on Visual Programming Languages in Internet of Things,” Scientific Programming, vol. 2017, pp. 1–6, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[25] Alrence Santiago Halibas et al., “Determining the Intervening Effects of Exploratory Data Analysis and Feature Engineering in Telecoms Customer Churn Modelling,” 4th MEC International Conference on Big Data and Smart City, pp. 1-7, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[26] Hemlata Jain, Ajay Khunteta, and Sumit Srivastava, “Churn Prediction in Telecommunication using Logistic Regression and Logit Boost,” Procedia Computer Science, vol. 167, pp. 101-112, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[27] Attili Venkata Ramana, Annaluri Sreenivasa Rao, and E. Kesavulu Reddy, “Applications of Business Intelligence and Decision Making for the Customer Behaviour Analysis in Telecom Industry,” International Journal of Recent Technology and Engineering, vol. 7, no. 6s2, pp. 688-693, 2019.
 [Publisher Link]
[28] Liwei Chen et al., “How does Employee Infusion Use of CRM Systems Drive Customer Satisfaction? Mechanism Differences between Face-To-Face and Virtual Channels,” MIS Quarterly, vol. 45, no. 2, pp. 719–754, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[29] 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]
[30] Muhammad Saqib et al., “Integrating Knowledge Management and Business Intelligence Practices to Improve Organisational Performance,” Majan International Conference, pp. 1-10, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[31] Lennerholt Christian, Van Laere Joeri, and Söderström Eva, “Implementation Challenges of Self-Service Business Intelligence: A Literature Review,” Proceedings of the 51st Hawaii International Conference on System Sciences, vol. 51, pp. 5055-5063, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[32] Yousra Harb, and Sahar Alhayajneh, “Intention to use BI tools: Integrating Technology Acceptance Model (TAM) and Personality Trait Model,” IEEE Jordan International Joint Conference on Electrical Engineering and Information Technology, pp. 494–497, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[33] Ralph Kimball, and Margy Ross, The Data Warehouse Toolkit The Definitive Guide to Dimensional Modeling, 3rd Edition, John Wiley and Son, 1998.
[Google Scholar] 
[34] Apoorva Srivastava, Sukriti Bhardwaj, and Shipra Saraswat, “SCRUM Model for Agile Methodology,” International Conference on Computing, Communication and Automation, pp. 864-869, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[35] ISO 25000 Portal, 2023. [Online]. Available: https://iso25000.com/index.php/en/
[36] Balseca Chisaguano, and Evelyn Amparo, “Quality Assessment of Software Products in Software Development Companies Applying the ISO/IEC 25000 Standard,” Escuela Politecnica Nacional, Bibdigital, 2015.
[Google Scholar] [Publisher Link]
[37] G. E. Silva Peñafiel et al., “Analysis of Methodologies to Develop Data Warehouse Applied to Decision Making, Cienciav Digital, vol. 3, no. 3.4, pp. 397–418, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[38] Lamia Yessad, and Aissa Labiod, “Comparative Study of Data Warehouses Modeling Approaches: Inmon, Kimball and Data Vault,” International Conference on System Reliability and Science, pp. 95–99, 2016.
[CrossRef] [Google Scholar] [Publisher Link]
[39] K. Villamizar Suaza et al., “Test Modeling for BI (Business Intelligence) Projects,” Proceedings of the 14th Latin American and Caribbean Conference for Engineering and Technology, 2016.
[CrossRef] [Publisher Link]
[40] Rita Sofia da Silva Antunes, “DATUS: Dashboard Assessment Usability Model - A Case Study with Student Dashboards,” Theses, Instituto Universitário de Lisbon, 2020.
[Google Scholar] [Publisher Link]
[41] Laura Silvia Vargas Perez et al., “MECHDAV: Proposal of A Systematized Model of Technical Evaluation of the Quality of the Use of RAD Tools for Visual Environments,” Processes and Metrics Magazine, 2006,
 [Google Scholar] 
[42] Reinaldo Alberto Sánchez Turcios, “t-Student: Uses and Abuses,” Mexican Journal of Cardiology, vol. 26, no. 1, pp. 59–61, 2015.
[Google Scholar] [Publisher Link]
[43] T. Aditya Kumar, G. Sravanthi, and D. Ratna Deepthi, “Competitive Advantage through Business Intelligence for E-Commerce,” International Journal of Computer & Organization Trends, vol. 3, no. 6, pp. 43-48, 2013.
[Google Scholar] [Publisher Link]
[44] M. A. Baherifard et al., “Improving the Effect of Electric Vehicle Charging on Imbalance Index in the ‎Unbalanced Distribution Network Using Demand Response Considering Data ‎Mining Techniques,” Journal of Operation and Automation in Power Engineering, 2022.
[CrossRef] [Google Scholar] [Publisher Link]
[45] Mohamed Al-Zadjali, and Kamla Ali Al-Busaidi, “Empowering CRM through Business Intelligence Applications: A Study in the Telecommunications Sector,” International Journal of Knowledge Management, vol. 14, no. 4, pp. 68–87, 2018.
[CrossRef] [Google Scholar] [Publisher Link]