Innovations in Data Modeling and Transformation for Scalable Business Intelligence on Modern Cloud Platforms

• Author(s): Jeffrey Chidera Ogeawuchi ; Abel Chukwuemeke Uzoka ; Abraham Ayodeji Abayomi ; Oluwademilade Aderemi Agboola ; Toluwase Peter Gbenle; Olanrewaju Oluwaseun Ajayi
• Paper ID: 1708319
• Page: 406-415
• Published Date: 30-11-2021
• Published In: Iconic Research And Engineering Journals
• Publisher: IRE Journals
• e-ISSN: 2456-8880
• Volume/Issue: Volume 5 Issue 5 November-2021

Abstract

This paper explores innovations in data modeling and transformation frameworks that enable scalable Business Intelligence (BI) on modern cloud platforms. As organizations increasingly rely on cloud environments to process and analyze large datasets, the limitations of traditional on-premises BI systems have become evident. The paper examines key advances in cloud-based BI, including semantic and logical data modeling, decentralized approaches such as data mesh and domain-oriented design, and real-time streaming data models. Additionally, the role of modern ELT pipelines, serverless computing, and DataOps in automating and optimizing data transformation workflows is discussed. The paper also highlights the integration of artificial intelligence (AI) in enhancing data quality through anomaly detection and auto-mapping. These innovations collectively empower organizations to scale their BI capabilities, streamline data governance, and achieve faster, more agile decision-making. Finally, the paper identifies key directions for future research, including unified metadata layers, AI-augmented BI, and adaptive cloud cost modeling. These advancements are pivotal in shaping the future of BI on cloud platforms, offering unprecedented flexibility, scalability, and operational efficiency.

Keywords

Cloud-based Business Intelligence (BI), Data Modeling, Data Mesh, ELT Pipelines, Serverless Computing, AI-enhanced Data Transformation

Citations

IRE Journals:
Jeffrey Chidera Ogeawuchi , Abel Chukwuemeke Uzoka , Abraham Ayodeji Abayomi , Oluwademilade Aderemi Agboola , Toluwase Peter Gbenle; Olanrewaju Oluwaseun Ajayi "Innovations in Data Modeling and Transformation for Scalable Business Intelligence on Modern Cloud Platforms" Iconic Research And Engineering Journals Volume 5 Issue 5 2021 Page 406-415

IEEE:
Jeffrey Chidera Ogeawuchi , Abel Chukwuemeke Uzoka , Abraham Ayodeji Abayomi , Oluwademilade Aderemi Agboola , Toluwase Peter Gbenle; Olanrewaju Oluwaseun Ajayi "Innovations in Data Modeling and Transformation for Scalable Business Intelligence on Modern Cloud Platforms" Iconic Research And Engineering Journals, 5(5)