A carregar...
Publicação
EY & Nova SBE PBL project - data-driven strategic analysis tool for higher education institutions: defining the KPI framework and developing data collection protocols
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 4.03 MB | Adobe PDF |
Autores
Orientador(es)
Resumo(s)
This 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.
Descrição
Palavras-chave
Business analytics Dashboard Power query Power Bi Entity tables EY