Loading...
Publication
Sustainability and Social Purpose: A Business Intelligence System Case Study
Authors
Advisor(s)
Abstract(s)
Esta dissertação insere-se no domínio da Engenharia Informática e visa desenvolver um sistema de apoio à decisão para o reporte de indicadores sociais de sustentabilidade, com base nos referenciais ESG (Environmental, Social and Governance) e nos GRI Standards.
O projeto foi realizado na empresa Continental Mabor, S.A., no âmbito de um estágio curricular, respondendo à necessidade de conformidade com a Diretiva (UE) 2022/2464,
que impõe o reporte não-financeiro a grandes organizações.
A sustentabilidade social tornou-se uma prioridade estratégica perante desafios globais como as alterações climáticas e as desigualdades sociais. Neste contexto, indicadores
como igualdade de género, contratação, formação e bem-estar laboral são cruciais para avaliar o desempenho organizacional. A solução proposta recorre a Business Intelligence
(BI) para monitorizar e reportar estes dados de forma estruturada, auditável e em tempo real.
O sistema baseia-se em modelação dimensional (arquitetura em estrela), suportado por um data warehouse criado com ferramentas Microsoft (SSIS, SSMS e Power BI). Incluiu
análise de requisitos, mapeamento de fontes, desenvolvimento de processos ETL e construção de dashboards interativos para visualização dos indicadores sociais.
O principal resultado é o índice “Sustainability Social – GRI Content Index”, baseado em dados reais da organização e alinhado com os Objetivos de Desenvolvimento Sustentável
(ODS 2030). Este índice, integrado em dashboards, promove transparência, rastreabilidade e conformidade normativa.
Conclui-se que a aplicação de BI à sustentabilidade social é uma mais-valia organizacional,
replicável noutras unidades, e reforça a integração entre tecnologia, responsabilidade social e cultura organizacional centrada no propósito – Lives with Purpose.
This dissertation falls within the field of Computer Engineering and aims to develop a decision-support system for reporting social sustainability indicators, based on international ESG (Environmental, Social and Governance) frameworks and the GRI Standards. The project was conducted at Continental Mabor, S.A., as part of a curricular internship, addressing the need for compliance with Directive (EU) 2022/2464, which mandates nonfinancial reporting for large organisations. Social sustainability has become a strategic priority in the face of global challenges such as climate change and social inequalities. In this context, indicators such as gender equality, recruitment, training, and workplace well-being are essential to assess organisational performance. The proposed solution adopts a Business Intelligence (BI) approach to monitor and report these indicators in a structured, auditable, and real-time manner. The system is based on dimensional modelling (star schema architecture), supported by a data warehouse built using Microsoft tools (SSIS, SSMS and Power BI). The project included requirements analysis, data source mapping, development of ETL processes (Extract, Transform, Load), and the creation of interactive dashboards for the visualisation of social indicators. The main outcome is the “Sustainability Social – GRI Content Index”, based on real organisational data and aligned with the Sustainable Development Goals (SDGs 2030). This index, integrated into dashboards, promotes transparency, traceability, and regulatory compliance. It is concluded that the use of BI for social sustainability provides significant organisational value, with strong potential for replication across other units. It reinforces the integration between technology, social responsibility, and a purpose-driven organisational culture – Lives with Purpose.
This dissertation falls within the field of Computer Engineering and aims to develop a decision-support system for reporting social sustainability indicators, based on international ESG (Environmental, Social and Governance) frameworks and the GRI Standards. The project was conducted at Continental Mabor, S.A., as part of a curricular internship, addressing the need for compliance with Directive (EU) 2022/2464, which mandates nonfinancial reporting for large organisations. Social sustainability has become a strategic priority in the face of global challenges such as climate change and social inequalities. In this context, indicators such as gender equality, recruitment, training, and workplace well-being are essential to assess organisational performance. The proposed solution adopts a Business Intelligence (BI) approach to monitor and report these indicators in a structured, auditable, and real-time manner. The system is based on dimensional modelling (star schema architecture), supported by a data warehouse built using Microsoft tools (SSIS, SSMS and Power BI). The project included requirements analysis, data source mapping, development of ETL processes (Extract, Transform, Load), and the creation of interactive dashboards for the visualisation of social indicators. The main outcome is the “Sustainability Social – GRI Content Index”, based on real organisational data and aligned with the Sustainable Development Goals (SDGs 2030). This index, integrated into dashboards, promotes transparency, traceability, and regulatory compliance. It is concluded that the use of BI for social sustainability provides significant organisational value, with strong potential for replication across other units. It reinforces the integration between technology, social responsibility, and a purpose-driven organisational culture – Lives with Purpose.
Description
Keywords
Sustentabilidade ESG GRI Standards ODS 2030 Business Intelligence Data Warehouse Reporting Não-Power Financeiro Power BI