| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 4.12 MB | Adobe PDF |
Authors
Abstract(s)
Este projeto visa desenvolver uma solução de business intelligence que permita visualizar os consumos de água e energia dos vários edifícios da EDP, de modo a melhorar a sua eficiência energética. Atualmente, com o aumento da preocupação com a sustentabilidade e a necessidade de reduzir o consumo de energia, tornou-se essencial encontrar ferramentas que ajudem a monitorizar e otimizar o uso energético. O trabalho inicia-se com uma contextualização da eficiência energética, sublinhando a sua importância e os principais indicadores de sustentabilidade e, em seguida, são analisadas as ferramentas de business intelligence existentes no mercado que permitem criar os relatórios pretendidos, destacando as suas funcionalidades e benefícios.
Na fase de diagnóstico, avaliou-se a abordagem utilizada pela EDP, identificando as dificuldades e sugerindo melhorias. Com base nestas análises, utilizou-se o Power Query e as Data Analysis Expressions para tratar e analisar os dados, construindo, posteriormente, um dashboard intuitivo e funcional. Para finalizar, é apresentada uma conclusão onde se realça a eficácia da solução desenvolvida, melhorias para futuras versões da ferramenta e o feedback dos utilizadores. Este trabalho contribui para o avanço do uso das tecnologias de business intelligence aplicadas à eficiência energética, proporcionando uma ferramenta prática e eficaz para a gestão do consumo energético em edifícios.
This project aims to create a business intelligence solution for visualizing water and energy consumption in different EDP buildings to enhance energy efficiency. With a growing focus on sustainability and the imperative to lower energy usage, it's crucial to have tools to monitor and optimize energy consumption. The work thoroughly examines energy efficiency within its broader context, underscoring its significance and key sustainability indicators. It then follows a detailed analysis of the current business intelligence tools available in the market that facilitate the creation of targeted reports, emphasizing their features and advantages. During the diagnostic phase, we evaluated EDP's approach, identified difficulties, and suggested improvements. After analysing the data, we used Power Query and Data Analysis Expressions to process and analyse it. Then, based on our findings, we created an intuitive and functional dashboard. Finally, we present a conclusion that represents the culmination of our combined efforts and collaboration. This section emphasizes the effectiveness of our developed solution, suggests improvements for future tool versions, and integrates valuable user feedback. Our work contributes to advancing business intelligence technologies in the context of energy efficiency, offering a practical and efficient tool for managing energy consumption in buildings.
This project aims to create a business intelligence solution for visualizing water and energy consumption in different EDP buildings to enhance energy efficiency. With a growing focus on sustainability and the imperative to lower energy usage, it's crucial to have tools to monitor and optimize energy consumption. The work thoroughly examines energy efficiency within its broader context, underscoring its significance and key sustainability indicators. It then follows a detailed analysis of the current business intelligence tools available in the market that facilitate the creation of targeted reports, emphasizing their features and advantages. During the diagnostic phase, we evaluated EDP's approach, identified difficulties, and suggested improvements. After analysing the data, we used Power Query and Data Analysis Expressions to process and analyse it. Then, based on our findings, we created an intuitive and functional dashboard. Finally, we present a conclusion that represents the culmination of our combined efforts and collaboration. This section emphasizes the effectiveness of our developed solution, suggests improvements for future tool versions, and integrates valuable user feedback. Our work contributes to advancing business intelligence technologies in the context of energy efficiency, offering a practical and efficient tool for managing energy consumption in buildings.
Description
Keywords
Energy efficiency Water Energy Business intelligence Power BI Eficiência energética Água Energia