Databases II
Code
100014
Academic unit
NOVA Information Management School
Credits
6.0
Teacher in charge
Jorge Nelson Gouveia de Sousa Neves
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Objectives
- Understand the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP).
- Introduce the concepts of business intelligence and data warehousing.
- Provide students with a design methodology adequate to multidimensional databases.
- Provide competence in multidimensional analysis and design assuring that students have the necessary skills to embrace the task of designing data warehouses and data marts that are efficcient and adapted to the business needs.
- Introduce ETL(Extract Transform and Load) tools to allow the data migration between OLTP and OLAP systems.
- Introduce tools to analyse, visualize and report existing data.
Prerequisites
Knowledge acquired in the Databases I namely data modeling and SQL
Subject matter
- Revision of database modelling and SQL language concepts.
- ETL using the SQL Server Import and Export Wizard.
- Dimensional modelling. Logical and Physical Design for a Data Warehouse.
- Data warehouse architectures.
- The four step dimensional design process.
- Introduction to ETL with SQL Server Integration Services (SSIS).
- Advanced dimensional modelling concepts.
- Designing and Implementing Control and Data Flow in SSIS.
- Introduction to Data Analysis, Visualization and Report using Powerpivot and Power View.
- Data exploration with Excel PowerPivot and Excel PowerView using Data Analysis Expressions (DAX).
Bibliography
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling,Third Edition, 2013 by Ralph Kimball, Margy Ross; Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server, 2012 by Dejan Sarka, Matija Lah, Grega Jerkic; Microsoft Excel 2013: Building Data Models with PowerPivot, 2013 by Alberto Ferrari, Marc Russo; 0; 0
Teaching method
Theoretical classes with the presentation of models from different functional contexts (e.g. Retail Sales, Procurement, Telecommunications, Education, Web Commerce) and practical classes with tutorials and exercises.
Evaluation method
Option 1:
- 2 quizzes (20%), minimum grade 8.
- Group project with discussion and presentation (40%), minimum grade 8.
- First call exam (40%), minimum grade 8.
- Group project with discussion and presentation (30%), minimum grade 8.
- Second call exam (70%), minimum grade 8.