2025

Data Warehousing

Name: Data Warehousing
Code: INF13272M
6 ECTS
Duration: 15 weeks/156 hours
Scientific Area: Informatics

Teaching languages: Portuguese
Languages of tutoring support: Portuguese

Sustainable Development Goals

Learning Goals

Upon completing the course students will have to show they have acquired knowledge, skills and abilities in the following aspects:

· To provide an in-depth study of data warehouse (DW);
· To identify how a data warehouse can support decision making process;
· To determine when and why an organization needs a data warehouse for decision support systems;
· To understand the critical issues in designing a data warehouse system;
· To learn to identify the resources and the user needs in designing data warehouses;
· Business Intelligence Topics;
Improve team work and oral and writing communications skills.

Contents

1. Systems modeling: fundamental principles.
2. Introduction to Data Warehousing
2.1 Fundamental concepts
2.2 The importance of Information in organizations
2.3 Benefits and Reasons to Create a Data Warehouse System
3. Components of a Data Warehouse
4. The Dimensional Model
4.1 Fact tables
4.2 The dimension tables
4.3 Association between fact tables and dimension tables
5. Case Studies
6. Building the Data Warehouse
6.1 Design steps
6.2 Bus Matrix
6.3 Dimension tables hierarchies
6.4 Bridge tables
7. Data analysis
7.1 Cube
7.2 OLAP tools

Teaching Methods

The teaching of this unit will consist of lectures, tutorials, self-study and group work. The main concepts of the unit will be delivered during lectures or tutorials. Practical exercises on the concepts will be carried out during tutorials. It is expected that students will attempt the tutorial exercises prior to attending the classes.
Assessment:
Examination: 50%; In-semester assessment: 50%

Teaching Staff (2023/2024 )