EY & Nova SBE PBL project - data-driven strategic analysis tool for higher education institutions: defining the KPI framework and developing data collection protocols

Xufre, PatríciaCunha, Afonso2026-05-272026-05-272026-01-142026-01-14http://hdl.handle.net/10362/203493This project reports on the development of a business intelligence dashboard, supported by a data pipeline that integrates heterogeneous data from multiple institutional sources. Using only the data that is already available, a set of feasible KPIs was defined. Data from Excel files, PDFs and a Python-generated source were extracted with ChatGPT assistance, cleaned and standardized in Power Query, organized into entity and fact tables, stored in Access and visualized in Power BI, enabling more consistent, data-driven monitoring and decision-making.engBusiness analyticsDashboardPower queryPower BiEntity tablesEYEY & Nova SBE PBL project - data-driven strategic analysis tool for higher education institutions: defining the KPI framework and developing data collection protocolsmaster thesis204242320