Inovação e Transformação Digital nas Organizações

Multidimensional Modelling and Business Intelligence

<< back to Curriculum Plan

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

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
Compete 2030
co-financiado