A carregar...
Publicação
Optimising Energy Analytics: A Dimensional Modelling Approach for Enhanced Decision-Making
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 1.97 MB | Adobe PDF |
Autores
Orientador(es)
Resumo(s)
The 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.
Descrição
Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
Palavras-chave
Energy Analytics Dimensional Modelling Data Warehouse Microsoft Fabric Electric Mobility Smart Grids Renewable Energy Service Continuity Business Intelligence Data Architecture Power BI SAIDI SAIFI Medallion Architecture Kimball Methodology Data Integration Geographic Energy Analysis Electric Vehicle Infrastructure Load Forecasting Grid Resilience SDG 7 - Affordable and clean energy SDG 9 - Industry, innovation and infrastructure SDG 11 - Sustainable cities and communities SDG 12 - Responsible production and consumption SDG 13 - Climate action