4 ECTS; 1º Ano, Anual, 28,0 TP , Cód. 20379.
Lecturer
- Vasco Renato Marques Gestosa da Silva (1)(2)
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Not applicable
Objectives
Students must learn concepts related to Business Intelligence, multidimensional data modeling and the steps of a BI process, use the Microsoft Power BI platform, manipulate and analyze data, and create reports and dashboards.
Program
1. Introduction to Business Intelligence
- Basic BI Concepts
- Data Warehousing Architectures
2. Multidimensional Modeling
- Fundamental Principles and Concepts
- Star Schema and Snowflake Schema Models
- Identifying Dimensions, Measures, and Performance Metrics
3. ETL (Extract, Transform, Load)
- Data Integration Processes
4. Business Intelligence and Data Visualization Tools
- Using Business Intelligence Tools - Microsoft Power BI
5. Data Manipulation and Analysis - Table Transformation
6. Creating Interactive Reports and Dashboards and Publishing Them Online
Evaluation Methodology
Development of a BI project involving data analysis, and the creation of reports and interactive dashboards 100%
Bibliography
- Gonçalves, C. e Gonçalves, M. e Maçães, M. (2024). O Futuro da Gestão com Business Intelligence. (Vol. 1). Lisboa: Atual Editora
- Melo, P. e Machado, C. (2021). Business Intelligence and Analytics in Small and Medium Enterprises. (Vol. 1). England: Taylor & Francis
- Santos, M. e Ramos, I. (2017). Business Intelligence - da Informação ao Conhecimento. (Vol. 1). Lisboa: FCA
Teaching Method
The course is organized into practical laboratory sessions in which the planned program content is taught, supported by presentations, as well as practical exercises applying the acquired concepts.
Software used in class
Microsoft Windows, Microsoft Excel, Microsoft Power BI, online productivity tools
