Publicação
BI Framework to understand Energy Sustainability: An E-Redes case study for Portugal’s Energy Scene
| datacite.subject.fos | Ciências Naturais::Ciências da Computação e da Informação | pt_PT |
| dc.contributor.advisor | Jardim, João Bruno Morais de Sousa | |
| dc.contributor.advisor | Rodrigues, Duarte Nuno Antunes Caracol Barros | |
| dc.contributor.author | Teixeira, David de Amorim | |
| dc.date.accessioned | 2025-11-05T14:59:46Z | |
| dc.date.available | 2025-11-05T14:59:46Z | |
| dc.date.issued | 2025-10-27 | |
| dc.description | Dissertation presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Business Analytics | pt_PT |
| dc.description.abstract | This thesis explores the creation process of a Business Intelligence (BI) framework designed to improve the understanding of Portugal’s energy usage and sustainability, using open-source data from the electricity operator, E-Redes. This project work leverages Kimball’s Lifecycle methodology to develop a scalable data architecture that includes data ingestion, transformation, and visualization using Microsoft Fabric tools and Power BI. This framework consists of many elements such as a dimensional model with fact and dimension tables, calculated KPIs to monitor different scopes such as energy production, consumption, efficiency and sustainability. The interactive nature of the dashboard allows stakeholders to conduct impactful analyses across different temporal, geographic, and voltage-level granularities. Among the key findings were seasonal trends in consumption, the predominance of low-voltage usage, and regional disparities in energy use which are aligned with the literature found. In addition of addressing a significant gap in the literature by delivering a complete and replicable Business Intelligence (BI) framework for national-level energy monitoring this work also offers a decision-support tool for policy makers, energy providers, and sustainability researchers. | pt_PT |
| dc.identifier.tid | 204071976 | |
| dc.identifier.uri | http://hdl.handle.net/10362/190136 | |
| dc.language.iso | eng | pt_PT |
| dc.rights.uri | http://creativecommons.org/licenses/by/4.0/ | pt_PT |
| dc.subject | Business Intelligence | pt_PT |
| dc.subject | Energy Consumption | pt_PT |
| dc.subject | Energy Production | pt_PT |
| dc.subject | Energy Sustainability | pt_PT |
| dc.subject | ERedes; Energy Systems | pt_PT |
| dc.subject | Key Performance Indicators | pt_PT |
| dc.subject | Kimball Lifecycle | pt_PT |
| dc.subject | SDG 7 - Affordable and clean energy | pt_PT |
| dc.subject | SDG 8 - Decent work and economic growth | pt_PT |
| dc.subject | SDG 9 - Industry, innovation and infrastructure | pt_PT |
| dc.subject | SDG 11 - Sustainable cities and communities | pt_PT |
| dc.subject | SDG 12 - Responsible production and consumption | pt_PT |
| dc.subject | SDG 13 - Climate action | pt_PT |
| dc.title | BI Framework to understand Energy Sustainability: An E-Redes case study for Portugal’s Energy Scene | pt_PT |
| dc.type | master thesis | |
| dspace.entity.type | Publication | |
| rcaap.rights | openAccess | pt_PT |
| rcaap.type | masterThesis | pt_PT |
| thesis.degree.name | Mestrado em Ciência de Dados e Métodos Analíticos Avançados, especialização em Business Analytics | pt_PT |