
4 ECTS; 1º Ano, Anual, 28,0 TP , Cód. 20379.
Lecturer
- Vasco Renato Marques Gestosa da Silva (1)
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Objectives
Development of Business Intelligence solutions using multidimensional modelling techniques, data exploration and visualisation for analysis and decision-making. Creation of reports and interactive dashboards using BI tools.
Program
1. Introduction to Business Intelligence
-Basic BI concepts
-Data Warehousing architectures
2. Multidimensional Modelling
-Principles and fundamental concepts
-Star schema and snowflake schema models
-Identification of dimensions, measures, and performance metrics
3. ETL (Extract, Transform, Load)
-Data integration processes
4. Business Intelligence and Data Visualisation Tools
-Use of Business Intelligence tool Microsoft Power BI
-Creation of reports and interactive dashboards
Evaluation Methodology
Development of a BI project involving data analysis, and the creation of reports and interactive dashboards 100%
Bibliography
Teaching Method
Software used in class