Home / Current Issue / Paper 1702898
A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization
Subject area: Science,Engineering and Technology · Area of research: Data Warehousing
Abstract
This paper explores the transformative potential of cloud-based data warehousing frameworks in enhancing real-time business intelligence (BI) and optimizing decision-making processes within modern organizations. As businesses increasingly rely on data to drive operational efficiency and competitive advantage, traditional on-premises data warehousing systems have proven inadequate in addressing the demand for real-time analytics. Cloud-based data warehousing provides scalable, flexible, and cost-effective solutions that enable businesses to integrate vast amounts of data, access it in real time, and leverage advanced analytics tools for informed decision-making. This study reviews the theoretical models supporting cloud computing and data warehousing, analyzes applications across various industries, and discusses the challenges and solutions related to the implementation of cloud-based systems. Key findings highlight the significant benefits of real-time access to integrated data, including faster decision-making, improved accuracy, and enhanced competitive advantage. The paper concludes with practical recommendations for businesses considering the adoption of cloud-based data warehousing solutions and outlines future research directions, particularly in the areas of AI integration, data governance, and adoption in industries with slower BI uptake.
Keywords
Cloud-Based Data Warehousing, Real-Time Business Intelligence, Decision-Making Optimization, Data Integration, Competitive Advantage, Cloud Computing
References
[1] Adewoyin, M. A. (2021). Developing frameworks for managing low-carbon energy transitions: overcoming barriers to implementation in the oil and gas industry.
[2] Ajayi, A., & Akerele, J. I. (2021). A High-Impact Data-Driven Decision-Making Model for Integrating Cutting-Edge Cybersecurity Strategies into Public Policy, Governance, and Organizational Frameworks. International Journal of Multidisciplinary Research and Growth Evaluation, 2(1), 623-637. doi:https://doi.org/10.54660/IJMRGE.2021.2.1.623-637.
[3] Barros, G. (2010). Herbert A. Simon and the concept of rationality: boundaries and procedures. Brazilian Journal of Political Economy, 30, 455-472.
[4] Bulusu, L. (2012). Open source data warehousing and business intelligence: CRC Press.
[5] Chen, H.-M., Chang, K.-C., & Lin, T.-H. (2016). A cloud-based system framework for performing online viewing, storage, and analysis on big data of massive BIMs. Automation in Construction, 71, 34-48.
[6] Cohen, M. D., March, J. G., & Olsen, J. P. (2012). “A Garbage Can Model” at forty: a solution that still attracts problems. In The garbage can model of organizational choice: Looking forward at forty (pp. 19-30): Emerald Group Publishing Limited.
[7] El-Seoud, S. A., El-Sofany, H. F., Abdelfattah, M., & Mohamed, R. (2017). Big Data and Cloud Computing: Trends and Challenges. International Journal of Interactive Mobile Technologies, 11(2).
[8] Elumilade, O. O., Ogundeji, I. A., Achumie, G. O., Omokhoa, H. E., & Omowole, B. M. (2021). Enhancing fraud detection and forensic auditing through data-driven techniques for financial integrity and security. Journal of Advanced Education and Sciences, 1(2), 55-63.
[9] Gadde, H. (2020). AI-Enhanced Data Warehousing: Optimizing ETL Processes for Real-Time Analytics. Revista de Inteligencia Artificial en Medicina, 11(1), 300-327.
[10] Garani, G., Chernov, A., Savvas, I., & Butakova, M. (2019). A data warehouse approach for business intelligence. Paper presented at the 2019 IEEE 28th International Conference on Enabling Technologies: Infrastructure for Collaborative Enterprises (WETICE).
[11] Gastermann, B., Stopper, M., Kossik, A., & Katalinic, B. (2015a). On-premises cloud storage-Security aspects for small and medium-sized enterprises. Paper presented at the The International MultiConference of Engineers and Computer Scientists.
[12] Gastermann, B., Stopper, M., Kossik, A., & Katalinic, B. (2015b). Secure implementation of an on-premises cloud storage service for small and medium-sized enterprises. Procedia Engineering, 100, 574-583.
[13] Ghosh, S., Hughes, M., Hughes, P., & Hodgkinson, I. (2021). Corporate digital entrepreneurship: Leveraging industrial internet of things and emerging technologies. Digital Entrepreneurship, 183, 1-339.
[14] Gibson, J., Rondeau, R., Eveleigh, D., & Tan, Q. (2012). Benefits and challenges of three cloud computing service models. Paper presented at the 2012 Fourth International Conference on Computational Aspects of Social Networks (CASoN).
[15] Golec, D., Strugar, I., & Belak, D. (2021). The benefits of enterprise data warehouse implementation in cloud vs. on-premises. ENTRENOVA-ENTerprise REsearch InNOVAtion, 7(1), 66-74.
[16] Goyal, S. (2014). Public vs private vs hybrid vs community-cloud computing: a critical review. International Journal of Computer Network and Information Security, 6(3), 20-29.
[17] Hassan, Y. G., Collins, A., Babatunde, G. O., Alabi, A. A., & Mustapha, S. D. (2021). AI-driven intrusion detection and threat modeling to prevent unauthorized access in smart manufacturing networks. Artificial intelligence (AI), 16.
[18] Höfer, C., & Karagiannis, G. (2011). Cloud computing services: taxonomy and comparison. Journal of Internet Services and Applications, 2, 81-94.
[19] Ike, C. C., Ige, A. B., Oladosu, S., Adepoju, P., & Afolabi, A. I. (1769). Advancing Predictive Analytics Models for Supply Chain Optimization in Global Trade Systems. International Journal of Applied Research in Social Sciences. https://doi. org/10.51594/ijarss. v6i12.
[20] Liu, Y., Soroka, A., Han, L., Jian, J., & Tang, M. (2020). Cloud-based big data analytics for customer insight-driven design innovation in SMEs. International Journal of Information Management, 51, 102034.
[21] Mounir, N., Guo, Y., Panchal, Y., Mohamed, I., Abou-Sayed, A., & Abou-Sayed, O. (2018). Integrating Big Data: simulation, predictive analytics, real time monitoring, and data warehousing in a single cloud application. Paper presented at the Offshore technology conference.
[22] Mwilu, O. S., Comyn-Wattiau, I., & Prat, N. (2016). Design science research contribution to business intelligence in the cloud—A systematic literature review. Future Generation Computer Systems, 63, 108-122.
[23] Nair, P. R., & Anbuudayasankar, S. (2018). Tackling supply chain management through high-performance computing: Opportunities and challenges. Silicon Photonics & High Performance Computing: Proceedings of CSI 2015, 1-7.
[24] Niu, Y., Ying, L., Yang, J., Bao, M., & Sivaparthipan, C. (2021). Organizational business intelligence and decision making using big data analytics. Information Processing & Management, 58(6), 102725.
[25] Nordeen, A. (2020). Learn Data Warehousing in 24 Hours: Guru99.
[26] Obisesan, A. B. (2021). Implementing Data Warehouse On-premises.
[27] Odio, P. E., Kokogho, E., Olorunfemi, T. A., Nwaozomudoh, M. O., Adeniji, I. E., & Sobowale, A. (2021). Innovative financial solutions: A conceptual framework for expanding SME portfolios in Nigeria's banking sector. International Journal of Multidisciplinary Research and Growth Evaluation, 2(1), 495-507.
[28] Otokiti, B. O. (2012). Mode of Entry of Multinational Corporation and their Performance in the Nigeria Market. Covenant University,
[29] Otokiti, B. O., Igwe, A. N., Ewim, C. P.-M., & Ibeh, A. I. (2021). Developing a framework for leveraging social media as a strategic tool for growth in Nigerian women entrepreneurs. Int J Multidiscip Res Growth Eval, 2(1), 597-607.
[30] Paul, P. O., Abbey, A. B. N., Onukwulu, E. C., Agho, M. O., & Louis, N. (2021). Integrating procurement strategies for infectious disease control: Best practices from global programs. prevention, 7, 9.
[31] Russom, P., Stodder, D., & Halper, F. (2014). Real-time data, BI, and analytics. Accelerating Business to Leverage Customer Relations, Competitiveness, and Insights. TDWI best practices report, fourth quarter, 5-25.
[32] Sahay, B., & Ranjan, J. (2008). Real time business intelligence in supply chain analytics. Information Management & Computer Security, 16(1), 28-48.
[33] Sakr, S., Liu, A., Batista, D. M., & Alomari, M. (2011). A survey of large scale data management approaches in cloud environments. IEEE communications surveys & tutorials, 13(3), 311-336.
[34] Seethala, S. C. (2019). Scaling Financial Data Warehouses with AI: Towards a Future-Proof Cloud-Based Ecosystem. Available at SSRN 5112189.
[35] Sent, E.-M. (2000). Herbert A. Simon as a cyborg scientist. Perspectives on Science, 8(4), 380-406.
[36] Seufert, A., & Schiefer, J. (2005). Enhanced business intelligence-supporting business processes with real-time business analytics. Paper presented at the 16th International Workshop on Database and Expert Systems Applications (DEXA'05).
[37] Sharma, P. K., Kaushik, P. S., Agarwal, P., Jain, P., Agarwal, S., & Dixit, K. (2017). Issues and challenges of data security in a cloud computing environment. Paper presented at the 2017 IEEE 8th Annual Ubiquitous Computing, Electronics and Mobile Communication Conference (UEMCON).
[38] Shorfuzzaman, M. (2017). Leveraging cloud based big data analytics in knowledge management for enhanced decision making in organizations. arXiv preprint arXiv:1702.04474.
[39] Winig, L. (2016). GE’s big bet on data and analytics. MIT Sloan Management Review, 57(3), 1-22.
[40] Yang, C., Huang, Q., Li, Z., Liu, K., & Hu, F. (2017). Big Data and cloud computing: innovation opportunities and challenges. International Journal of Digital Earth, 10(1), 13-53.
[41] Yang, C., Lan, S., Wang, L., Shen, W., & Huang, G. G. (2020). Big data driven edge-cloud collaboration architecture for cloud manufacturing: a software defined perspective. Ieee Access, 8, 45938-45950.
[42] Zhu, Y.-Q., & Kindarto, A. (2016). A garbage can model of government IT project failures in developing countries: The effects of leadership, decision structure and team competence. Government Information Quarterly, 33(4), 629-637.
How to cite this paper
@article{1702898,
author = {Emmanuel Damilare Balogun, Kolade Olusola Ogunsola, Adebanji Samuel Ogunmokun},
title = {A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization},
journal = {Iconic Research And Engineering Journals},
year = {2021},
volume = {5},
number = {2},
pages = {165-174},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1702898.pdf},
abstract = {This paper explores the transformative potential of cloud-based data warehousing frameworks in enhancing real-time business intelligence (BI) and optimizing decision-making processes within modern organizations. As businesses increasingly rely on data to drive operational efficiency and competitive advantage, traditional on-premises data warehousing systems have proven inadequate in addressing the demand for real-time analytics. Cloud-based data warehousing provides scalable, flexible, and cost-effective solutions that enable businesses to integrate vast amounts of data, access it in real time, and leverage advanced analytics tools for informed decision-making. This study reviews the theoretical models supporting cloud computing and data warehousing, analyzes applications across various industries, and discusses the challenges and solutions related to the implementation of cloud-based systems. Key findings highlight the significant benefits of real-time access to integrated data, including faster decision-making, improved accuracy, and enhanced competitive advantage. The paper concludes with practical recommendations for businesses considering the adoption of cloud-based data warehousing solutions and outlines future research directions, particularly in the areas of AI integration, data governance, and adoption in industries with slower BI uptake.},
keywords = {Cloud-Based Data Warehousing, Real-Time Business Intelligence, Decision-Making Optimization, Data Integration, Competitive Advantage, Cloud Computing},
month = {August},
}