Rohan Prakash, Iyer and Dr. Ananya, Mehta (2022) ARCHITECTING MULTI-LAYERED SEMANTIC MODELS IN POWER BI FOR ENTERPRISE-SCALE INSIGHTS. Journal of Engineering, Mechanics and Modern Architecture, 1 (1). pp. 40-47. ISSN 2181-4384

Text ARCHITECTING MULTI-LAYERED SEMANTIC MODELS.pdf Download (192kB)

Abstract

Enterprises increasingly rely on business intelligence (BI) platforms to transform vast, fragmented datasets into actionable insights. However, as organizations scale, traditional dashboard-centric approaches in Power BI struggle to maintain consistency, governance, and performance. This article explores the concept of multi-layered semantic modeling as a foundation for enterprise-scale BI in Power BI. By structuring semantic layers across core, departmental, and consumption tiers, organizations can unify business logic, reduce redundancy, and deliver insights that are both scalable and trustworthy. Key considerations such as security enforcement, row-level access at scale, performance optimization through aggregations and composite models, and metadata governance are examined as critical success factors. The discussion also highlights architectural design patterns, challenges in adoption, and future directions, including AI-driven semantic enrichment and deeper integration with data lakes and cloud-native ecosystems. Ultimately, the article positions multi-layered semantic models not merely as a technical enhancement, but as a strategic enabler of sustainable, enterprise-wide data intelligence.

Item Type:	Article
Subjects:	Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions:	Postgraduate > Master's of Islamic Education
Depositing User:	Journal Editor
Date Deposited:	10 Sep 2025 09:06
Last Modified:	10 Sep 2025 09:06
URI:	http://eprints.umsida.ac.id/id/eprint/16340

Actions (login required)

View Item