Cloud-Native Business Intelligence Transformation: Migrating Legacy Systems to Modern Analytics Stacks for Scalable Decision-Making
DOI:
https://doi.org/10.32628/IJSRSSH242763Keywords:
Cloud-native, Business intelligence, Transformation, Migrating, Legacy systems, Modern analytics stacks, Scalable decision-makingAbstract
The shift from legacy business intelligence (BI) systems to cloud-native analytics stacks marks a critical juncture in the evolution of data-driven decision-making. Traditional BI architectures—rooted in on-premise data warehouses, rigid ETL pipelines, and siloed reporting tools—are increasingly unable to meet the demands of modern enterprises that require real-time insights, horizontal scalability, and cost-efficiency. As organizations contend with rapidly growing data volumes and the need for operational agility, the transformation toward cloud-native BI has emerged as both a technological necessity and a strategic enabler. Cloud-native BI leverages distributed computing, elastic storage, and modular orchestration frameworks to deliver scalable, flexible, and resilient data pipelines. Platforms such as Amazon Redshift, Google BigQuery, and Snowflake—coupled with modern tools like dbt, Apache Airflow, and Looker—facilitate a decoupled, event-driven architecture that supports both batch and streaming analytics. This enables teams to automate transformations, improve observability, and deliver faster insights to business stakeholders, thereby enhancing data usability across the organization. This explores the architectural principles, migration strategies, and implementation best practices required to modernize legacy BI environments. It examines key challenges such as data migration, pipeline refactoring, cost management, and change enablement. Furthermore, it presents real-world case studies that illustrate performance improvements, reduced latency, and total cost of ownership (TCO) benefits achieved through cloud-native modernization. By synthesizing practical insights with technical depth, this paper offers a comprehensive framework for enterprise architects, data engineers, and analytics leaders seeking to future-proof their BI infrastructure. It argues that cloud-native transformation is not simply a matter of lifting and shifting legacy systems but requires a holistic reengineering of data culture, tooling, and governance. Ultimately, the transition enables scalable, data-driven decision-making aligned with the speed and complexity of the digital age.
Downloads
References
Abatan, A., Jacks, B.S., Ugwuanyi, E.D., Nwokediegwu, Z.Q.S., Obaigbena, A., Daraojimba, A.I. and Lottu, O.A., 2024. The role of environmental health and safety practices in the automotive manufacturing industry. Engineering Science & Technology Journal, 5(2), pp.531-542. DOI: https://doi.org/10.51594/estj.v5i2.830
Adefemi, A., Daudu, C.D., Okoli, C.E., Ayorinde, O.B., Adekoya, O.O. and Ibeh, C.V., 2024. Reviewing the development of floating LNG facilities and their global impact. World Journal of Advanced Research and Reviews, 21(2), pp.371-381. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0463
Adekugbe, A.P. and Ibeh, C.V., 2024. Harnessing data insights for crisis management in US public health: lessons learned and future directions. International Medical Science Research Journal, 4(4), pp.391-405. DOI: https://doi.org/10.51594/imsrj.v4i4.998
Adekugbe, A.P. and Ibeh, C.V., 2024. Innovating service delivery for underserved communities: leveraging data analytics and program management in the US context. International Journal of Applied Research in Social Sciences, 6(4), pp.472-487. DOI: https://doi.org/10.51594/ijarss.v6i4.986
Adekunle, B.I., Chukwuma-Eke, E.C., Balogun, E.D. and Ogunsola, K.O., 2024. Optimizing internal control systems through blockchain-based financial reporting: Opportunities and risks. International Journal of Management and Organizational Research, 3(1), pp.213-222. DOI: https://doi.org/10.54660/IJMOR.2024.3.1.213-222
Adewumi, A., Ibeh, C.V., Asuzu, O.F., Adelekan, O.A., Awonnuga, K.F. and Daraojimba, O.D., 2024. Data analytics in retail banking: A review of customer insights and financial services innovation. Business, Organizations and Society (BOSOC), 2(1), pp.16-21. DOI: https://doi.org/10.26480/bosoc.01.2024.16.21
Adeyemo, K.S., Mbata, A.O. and Balogun, O.D., 2024. Combating Counterfeit Drugs in the US Pharmaceutical Supply Chain: The Potential of Blockchain and IoT for Public Health Safety.
Adeyemo, K.S., Mbata, A.O. and Balogun, O.D., 2024. Pharmaceutical Waste Management and Reverse Logistics in the US Enhancing Sustainability and Reducing Public Health Risks. Significance, 11.
Adeyemo, K.S., Mbata, A.O. and Balogun, O.D., A Conceptual Framework for Addressing Vaccine Hesitancy: Integrating Behavioral Science, Public Health Policy, and Community Engagement to Enhance Immunization Uptake.
Ajala, O.A., Arinze, C.A., Ofodile, O.C., Okoye, C.C. and Daraojimba, A.I., 2024. Exploring and reviewing the potential of quantum computing in enhancing cybersecurity encryption methods. Magna Scientia Advanced Research and Reviews, 10(01), pp.321-329. DOI: https://doi.org/10.30574/msarr.2024.10.1.0038
Ajayi-Nifise, A.O., Odeyemi, O., Mhlongo, N.Z., Ibeh, C.V., Elufioye, O.A. and Falaiye, T., 2024. Digital transformation in banking: The HR perspective on managing change and cultivating digital talent. International Journal of Science and Research Archive, 11(1), pp.1452-1459. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0237
Ajayi-Nifise, A.O., Odeyemi, O., Mhlongo, N.Z., Ibeh, C.V., Elufioye, O.A. and Awonuga, K.F., 2024. The future of accounting: Predictions on automation and AI integration. World journal of advanced research and reviews, 21(2), pp.399-407. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0466
Ajayi-Nifise, A.O., Tula, S.T., Asuzu, O.F., Mhlongo, N.Z., Olatoye, F.O. and Ibeh, C.V., 2024. The role of government policy in fostering entrepreneurship: a USA and Africa review. International Journal of Management & Entrepreneurship Research, 6(2), pp.352-367. DOI: https://doi.org/10.51594/ijmer.v6i2.775
Alab, O.A., Ajayi, F.A., Udeh, C.A. and Efunniyi, C.P., 2024. Leveraging data analytics to enhance workforce efficiency and customer service in HR-driven organizations. International Journal of Research and Scientific Innovation, 11(9), pp.92-101. DOI: https://doi.org/10.51244/IJRSI.2024.1109009
Alabi, O.A., 2024. Influence of green human resource management practices on employee retention amongst outsourced companies in Nigeria [Master’s thesis, Teesside University]. Teesside University.
Alabi, O.A., Ajayi, F.A., Udeh, C.A. and Efunniyi, C.P., 2024. Optimizing customer service through workforce analytics: The role of HR in data-driven decision-making. International Journal of Research and Scientific Innovation, 11(8), pp.1628-1639. DOI: https://doi.org/10.51244/IJRSI.2024.1108125
Alahira, J., Mhlongo, N.Z., Falaiye, T., Olubusola, O., Daraojimba, A.I. and Oguejiofor, B.B., 2024. The role of artificial intelligence in enhancing tax compliance and financial regulation. Finance & Accounting Research Journal, 10, pp.241-251. DOI: https://doi.org/10.51594/farj.v6i2.822
Anyanwu, E.C., Maduka, C.P., Ayo-Farai, O., Okongwu, C.C. and Daraojimba, A.I., 2024. Maternal and child health policy: A global review of current practices and future directions. World Journal of Advanced Research and Reviews, 21(2), pp.1770-1781. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0306
Appoh, M., Gobile, S., Alabi, O.A. and Oboyi, N., Strategic Human Resource Management in Global Organizations: Cultivating a Competitive Edge through Diversity and Inclusion.
Appoh, M., Oboyi, N., Sobowale, A., Ogunwale, B., Gobile, S. and Alabi, O.A., Organizational Culture and its Impact on Knowledge Transfer: A Literature Review in the Context of Developmental Disabilities Administration Organizations.
Arinze, C.A., Ajala, O.A., Okoye, C.C., Ofodile, O.C. and Daraojimba, A.I., 2024. Evaluating the integration of advanced IT solutions for emission reduction in the oil and gas sector. Engineering Science & Technology Journal, 5(3), pp.639-652. DOI: https://doi.org/10.51594/estj.v5i3.862
Atadoga, A., Awonuga, K.F., Ibeh, C.V., Ike, C.U., Olu-Lawal, K.A. and Usman, F.O., 2024. Harnessing data analytics for sustainable business growth in the us renewable energy sector. Engineering Science & Technology Journal, 5(2), pp.460-470. DOI: https://doi.org/10.51594/estj.v5i2.806
Awonuga, K.F., Mhlongo, N.Z., Olatoye, F.O., Ibeh, C.V., Elufioye, O.A. and Asuzu, O.F., 2024. Business incubators and their impact on startup success: A review in the USA. International Journal of Science and Research Archive, 11(1), pp.1418-1432. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0234
Ayorinde, O.B., Daudu, C.D., Okoli, C.E., Adefemi, A., Adekoya, O.O. and Ibeh, C.V., 2024. Reviewing the impact of LNG technology advancements on global energy markets. Eng Sci Technol J, 5(2), pp.402-411.
Ebirim, G.U., Asuzu, O.F., Ndubuisi, N.L., Adelekan, O.A., Ibeh, C.V. and Unigwe, I.F., 2024. Women in accounting and auditing: a review of progress, challenges, and the path forward. Finance & Accounting Research Journal, 6(2), pp.98-111. DOI: https://doi.org/10.51594/farj.v6i2.782
Elugbaju, W.K., Okeke, N.I. and Alabi, O.A., 2024. SaaS-based reporting systems in higher education: A digital transition framework for operational resilience. International Journal of Applied Research in Social Sciences, 6(10), pp.2512-2532. DOI: https://doi.org/10.51594/ijarss.v6i10.1663
Enahoro, Q.E., Ogugua, J.O., Anyanwu, E.C., Akomolafe, O., Odilibe, I.P. and Daraojimba, A.I., 2024. The impact of electronic health records on healthcare delivery and patient outcomes: A review. World Journal of Advanced Research and Reviews, 21(2), pp.451-460. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0478
Evans-Uzosike, I.O., Okatta, C.G., Otokiti, B.O., Ejike, O.G. and Kufile, O.T., 2024. Modeling the Impact of Project Manager Emotional Intelligence on Conflict Resolution Efficiency Using Agent-Based Simulation in Agile Teams. International Journal of Scientific Research in Civil Engineering, 8(5), pp.154-167.
Ewim, C., Okeke, N., Alabi, O., Igwe, A. and Ofodile, O., 2024. Customer-Centric digital transformation framework: Enhancing service delivery in SMES for underserved populations. Int. J. Manag. Entrep. Res, 6, pp.3493-3516. DOI: https://doi.org/10.51594/ijmer.v6i10.1658
Ewim, C.P.M., Alabi, O.A., Okeke, N.I., Igwe, A.N. and Ofodile, O.C., 2024. Omni-channel customer experience framework: Enhancing service delivery in SMEs. World Journal of Advanced Research and Reviews, 24(2), pp.655-670. DOI: https://doi.org/10.30574/wjarr.2024.24.2.3335
Falaiye, T., Elufioye, O.A., Awonuga, K.F., Ibeh, C.V., Olatoye, F.O. and Mhlongo, N.Z., 2024. Financial inclusion through technology: a review of trends in emerging markets. International Journal of Management & Entrepreneurship Research, 6(2), pp.368-379. DOI: https://doi.org/10.51594/ijmer.v6i2.776
Ibeh, C.V., Asuzu, O.F., Olorunsogo, T., Elufioye, O.A., Nduubuisi, N.L. and Daraojimba, A.I., 2024. Business analytics and decision science: A review of techniques in strategic business decision making. World Journal of Advanced Research and Reviews, 21(2), pp.1761-1769. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0247
Ibeh, C.V., Awonuga, K.F., Okoli, U.I., Ike, C.U., Ndubuisi, N.L. and Obaigbena, A., 2024. A review of agile methodologies in product lifecycle management: bridging theory and practice for enhanced digital technology integration. Engineering Science & Technology Journal, 5(2), pp.448-459. DOI: https://doi.org/10.51594/estj.v5i2.805
Ibeh, C.V., Elufioye, O.A., Olorunsogo, T., Asuzu, O.F., Nduubuisi, N.L. and Daraojimba, A.I., 2024. Data analytics in healthcare: A review of patient-centric approaches and healthcare delivery. World Journal of Advanced Research and Reviews, 21(02), pp.1750-1760. DOI: https://doi.org/10.30574/wjarr.2024.21.2.0246
Ilori, O., Nwosu, N.T. and Naiho, H.N.N., 2024. A comprehensive review of it governance: effective implementation of COBIT and ITIL frameworks in financial institutions. Computer science & it research journal, 5(6), pp.1391-1407. DOI: https://doi.org/10.51594/csitrj.v5i6.1224
Ilori, O., Nwosu, N.T. and Naiho, H.N.N., 2024. Advanced data analytics in internal audits: A conceptual framework for comprehensive risk assessment and fraud detection. Finance & Accounting Research Journal, 6(6), pp.931-952. DOI: https://doi.org/10.51594/farj.v6i6.1213
Ilori, O., Nwosu, N.T. and Naiho, H.N.N., 2024. Enhancing IT audit effectiveness with agile methodologies: A conceptual exploration. Engineering Science & Technology Journal, 5(6), pp.1969-1994. DOI: https://doi.org/10.51594/estj.v5i6.1217
Ilori, O., Nwosu, N.T. and Naiho, H.N.N., 2024. Optimizing Sarbanes-Oxley (SOX) compliance: strategic approaches and best practices for financial integrity: A review. World Journal of Advanced Research and Reviews, 22(3), pp.225-235. DOI: https://doi.org/10.30574/wjarr.2024.22.3.1728
Ilori, O., Nwosu, N.T. and Naiho, H.N.N., 2024. Third-party vendor risks in IT security: A comprehensive audit review and mitigation strategies. World Journal of Advanced Research and Reviews, 22(3), pp.213-224. DOI: https://doi.org/10.30574/wjarr.2024.22.3.1727
Kaggwa, S., Onunka, T., Uwaoma, P.U., Onunka, O., Daraojimba, A.I. and Eyo-Udo, N.L., 2024. Evaluating the efficacy of technology incubation centres in fostering entrepreneurship: case studies from the global sout. International Journal of Management & Entrepreneurship Research, 6(1), pp.46-68. DOI: https://doi.org/10.51594/ijmer.v6i1.695
Kess-Momoh, A.J., Tula, S.T., Bello, B.G., Omotoye, G.B. and Daraojimba, A.I., 2024. Strategic human resource management in the 21st century: A review of trends and innovations. World Journal of Advanced Research and Reviews, 21(1), pp.746-757. DOI: https://doi.org/10.30574/wjarr.2024.21.1.0105
Kufile, O.T., Otokiti, B.O., Onifade, A.Y., Ogunwale, B. and Okolo, C.H., 2024. Building Executive Dashboards for Real-Time Cross-Channel Performance Monitoring. International Journal of Scientific Research in Humanities and Social Sciences, 1(2), pp.143-160.
Kufile, O.T., Otokiti, B.O., Onifade, A.Y., Ogunwale, B. and Okolo, C.H., 2024. Designing Ethics-Governed AI Personalization Frameworks in Programmatic Advertising. International Journal of Scientific Research in Civil Engineering, 8(3), pp.115-133.
Kufile, O.T., Otokiti, B.O., Onifade, A.Y., Ogunwale, B. and Okolo, C.H., 2024. Developing Ad Impact Assessment Models Using Pre/Post-Survey Data Analytics. International Journal of Scientific Research in Humanities and Social Sciences, 1(2), pp.161-178.
Nwosu, N.T. and Ilori, O., 2024. Behavioral finance and financial inclusion: A conceptual review and framework development. World Journal of Advanced Research and Reviews, 22(3), pp.204-212. DOI: https://doi.org/10.30574/wjarr.2024.22.3.1726
Odeyemi, O., Ibeh, C.V., Mhlongo, N.Z., Asuzu, O.F., Awonuga, K.F. and Olatoye, F.O., 2024. Forensic accounting and fraud detection: a review of techniques in the digital age. Finance & Accounting Research Journal, 6(2), pp.202-214. DOI: https://doi.org/10.51594/farj.v6i2.788
Ogunwale, B., Appoh, M., Oboyi, N., Afrihyia, E., Gobile, S. and Alabi, O.A., 2024. Cross-Cultural Leadership Styles in Multinational Corporations: A Comparative. DOI: https://doi.org/10.54660/.IJMRGE.2024.5.1.1720-1724
Ojukwu, P.U., Cadet, E., Osundare, O.S., Fakeyede, O.G., Ige, A.B. and Uzoka, A., 2024. The crucial role of education in fostering sustainability awareness and promoting cybersecurity measures. International Journal of Frontline Research in Science and Technology, 4(01), pp.018-034. DOI: https://doi.org/10.56355/ijfrst.2024.4.1.0050
Ojukwu, P.U., Cadet, E., Osundare, O.S., Fakeyede, O.G., Ige, A.B. and Uzoka, A., 2024. Exploring theoretical constructs of blockchain technology in banking: Applications in African and US financial institutions. International Journal of Frontline Research in Science and Technology, 4(01), pp.035-042. DOI: https://doi.org/10.56355/ijfrst.2024.4.1.0051
Ojukwu, P.U., Cadet, E., Osundare, O.S., Fakeyede, O.G., Ige, A.B. and Uzoka, A., 2024. Advancing green bonds through FinTech innovations: A conceptual insight into opportunities and challenges. International Journal of Engineering Research and Development, 20(11), pp.565-576.
Okeke, N., Alabi, O., Igwe, A., Ofodile, O. and Ewim, C., 2024. Customer-centric quality management: A framework for organizational excellence in SMEs. International Journal of Management & Entrepreneurship Research, 6, pp.3517-3540. DOI: https://doi.org/10.51594/ijmer.v6i10.1659
Okeke, N.I., Alabi, O.A., Igwe, A.N., Ofodile, O.C. and Ewim, C.P.M., 2024. Personalized customer journeys for underserved communities: Tailoring solutions to address unique needs. World Journal of Advanced Research and Reviews, 24(1), pp.1988-2003. DOI: https://doi.org/10.30574/wjarr.2024.24.1.3205
Okoli, I., Appoh, M., Alabi, O.A., Ogunwale, B., Gobile, S. and Oboyi, N., 2024. Remote Work Dynamics and Its Influence on US Urbanization Patterns: A Review. DOI: https://doi.org/10.54660/.IJMRGE.2024.5.2.1035-1045
Olatoye, F.O., Awonuga, K.F., Mhlongo, N.Z., Ibeh, C.V., Elufioye, O.A. and Ndubuisi, N.L., 2024. AI and ethics in business: A comprehensive review of responsible AI practices and corporate responsibility. International Journal of Science and Research Archive, 11(1), pp.1433-1443. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0235
Oriekhoe, O.I., Oyeyemi, O.P., Bello, B.G., Omotoye, G.B., Daraojimba, A.I. and Adefemi, A., 2024. Blockchain in supply chain management: A review of efficiency, transparency, and innovation. International Journal of Science and Research Archive, 11(1), pp.173-181. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0028
Sodiya, E.O., Umoga, U.J., Obaigbena, A., Jacks, B.S., Ugwuanyi, E.D., Daraojimba, A.I. and Lottu, O.A., 2024. Current state and prospects of edge computing within the Internet of Things (IoT) ecosystem. International Journal of Science and Research Archive, 11(1), pp.1863-1873. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0287
Usman, F.O., Eyo-Udo, N.L., Etukudoh, E.A., Odonkor, B., Ibeh, C.V. and Adegbola, A., 2024. A critical review of ai-driven strategies for entrepreneurial success. International Journal of Management & Entrepreneurship Research, 6(1), pp.200-215. DOI: https://doi.org/10.51594/ijmer.v6i1.748
Usman, F.O., Kess-Momoh, A.J., Ibeh, C.V., Elufioye, A.E., Ilojianya, V.I. and Oyeyemi, O.P., 2024. Entrepreneurial innovations and trends: A global review: Examining emerging trends, challenges, and opportunities in the field of entrepreneurship, with a focus on how technology and globalization are shaping new business ventures. International Journal of Science and Research Archive, 11(1), pp.552-569. DOI: https://doi.org/10.30574/ijsra.2024.11.1.0079
Zouo, S.J.C. and Olamijuwon, J., 2024. Financial data analytics in healthcare: A review of approaches to improve efficiency and reduce costs. Open Access Research Journal of Science and Technology, 12(2), pp.10-19. DOI: https://doi.org/10.53022/oarjst.2024.12.2.0129
Zouo, S.J.C. and Olamijuwon, J., 2024. The intersection of financial modeling and public health: A conceptual exploration of cost-effective healthcare delivery. Finance & Accounting Research Journal, 6(11), pp.2108-2119. DOI: https://doi.org/10.51594/farj.v6i11.1699
Downloads
Published
Issue
Section
License
Copyright (c) 2024 International Journal of Scientific Research in Humanities and Social Sciences
This work is licensed under a Creative Commons Attribution 4.0 International License.
