NOVA Information Management School

Data Warehousing



Academic unit

NOVA Information Management School



Teacher in charge

Miguel de Castro Simões Ferreira Neto

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English


This course provides students with the knowledge and skills necessary to design and implement a data warehouse. Students are expected to become familiar with (1) requirements gathering for data warehousing, (2) data warehouse architecture, (3) dimensional model design for data warehousing, (4) physical database design for data warehousing, (4) extracting, transforming, and loading strategies, (5) introduction to business intelligence, and (6) design and development of business intelligence applications, expansion and support of a data warehouse.



Subject matter

What is Data Warehousing, Inmon vs. Kimball, dimensional modelling, slowly changing dimensions, fact tables, OLAP objects, business intelligence, and extract, transform, and load technologies


¿The Data Warehouse Lifecycle Toolkit, 2008 by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker; ¿Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit), 2012 by Dejan Sarka, Matija Lah, Grega Jerkic; ¿Building a Data Warehouse: With Examples in SQL Server, 2007 by Vincent Rainardi; 0; 0

Teaching method


Evaluation method