International Peer-Reviewed JournalOpen AccessISSN 2456-8880
irejournals@gmail.com+91-7433024337

Home / Current Issue / Paper 1702898

1702898 Vol 5 · Issue 2 Download Paper

A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization

Emmanuel Damilare Balogun Kolade Olusola Ogunsola Adebanji Samuel Ogunmokun

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

Emmanuel Damilare Balogun, Kolade Olusola Ogunsola, Adebanji Samuel Ogunmokun "A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization" Iconic Research And Engineering Journals Volume 5 Issue 2 2021 Page 165-174
Emmanuel Damilare Balogun, Kolade Olusola Ogunsola, Adebanji Samuel Ogunmokun "A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization" Iconic Research And Engineering Journals, vol. 5, no. 2, Aug. 2021
Emmanuel Damilare Balogun, Kolade Olusola Ogunsola, Adebanji Samuel Ogunmokun (2021). A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization. Iconic Research And Engineering Journals, 5(2).
Emmanuel Damilare Balogun, Kolade Olusola Ogunsola, Adebanji Samuel Ogunmokun "A Cloud-Based Data Warehousing Framework for Real-Time Business Intelligence and Decision-Making Optimization" Iconic Research And Engineering Journals, vol. 5, no. 2, Aug. 2021.
@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},
  }