Jardim, João Bruno Morais de SousaAires, Vitor André Jóia2025-11-072025-11-072025-10-27http://hdl.handle.net/10362/190265Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceThe accelerating digital transformation of the energy sector presents new opportunities and challenges in achieving sustainable, efficient, and resilient energy systems. This thesis addresses the integration of consumption analytics, grid infrastructure, and electric mobility by designing a scalable data architecture rooted in dimensional modelling and implemented using Microsoft Fabric. Drawing on large-scale datasets from the Portuguese electricity distribution operator E-REDES, the study adopts a Medallion architecture framework— structuring data flows through Bronze, Silver, and Gold layers—to deliver actionable insights via Power BI dashboards. Key analytical domains include hourly and regional energy consumption, electric vehicle infrastructure impacts, service continuity (measured via SAIDI and SAIFI indices), and renewable energy adoption. By applying the Kimball Data Warehouse Lifecycle, the work ensures that the dimensional star schema reflects both technical robustness and stakeholder relevance, leveraging conformed dimensions and surrogate keys for analytical consistency. The thesis demonstrates how integrated data models can support demand forecasting, service reliability benchmarking, and policy alignment. Moreover, it highlights the potential of unified data platforms in operationalizing real-time energy management while exposing gaps in data granularity, public infrastructure availability, and behavioural modelling. Ultimately, this research contributes to the field of data-driven energy systems by offering a reusable architectural blueprint that is both technically scalable and policy-relevant.engEnergy AnalyticsDimensional ModellingData WarehouseMicrosoft FabricElectric MobilitySmart GridsRenewable EnergyService ContinuityBusiness IntelligenceData ArchitecturePower BISAIDISAIFIMedallion ArchitectureKimball MethodologyData IntegrationGeographic Energy AnalysisElectric Vehicle InfrastructureLoad ForecastingGrid ResilienceSDG 7 - Affordable and clean energySDG 9 - Industry, innovation and infrastructureSDG 11 - Sustainable cities and communitiesSDG 12 - Responsible production and consumptionSDG 13 - Climate actionmaster thesis204075319