Publication in the Diário da República: RCC 01/04/2011 [DR.7678/2011 26.05.2011]
4 ECTS; 3º Ano, 2º Semestre, 15,0 T + 30,0 PL , Cód. 9152228.
Lecturer
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Not applicable.
Objectives
Students should a) acquire knowledge related to the business intelligence process b) know operational and dimensional systems c) implement relational and analytical models d) use BI tools and multicriteria solutions and e) make decisions in an environment of uncertainty.
Program
1-Business Intelligence (BI) and Data Warehouse
BI Systems
BI Capabilities and Benefits
Components of a Business Intelligence Environment
2-Operating and analytical systems
3-From the relational model to the dimensional model
Data Warehouse implementation templates:
Star model (Star Schema)
Snowflake Pattern (Snow Flake)
4-Data Warehouse Systems
Features and Architecture of a Data Warehouse
Process ETL
Data Mart
5-Use of BI platforms:
IBM COGNOS Insight
Microsoft SQL Server
6-SQL Language
Commands for Data Definition - Data Definition Language (DDL)
Commands for data manipulation - Data Manipulation Language (DML)
Manipulating the Data Warehouse Adventure Works with SQL
Production of reports
7- Decision-making tool with multicriteria problems - MACBETH
8- Criteria for decision making in uncertainty environments.
Evaluation Methodology
Written open-book test/exam. A practical assignment and public discussion with minimum mark of 7/20 in each component.
Bibliography
- Mendes, J. e Marques, C. e Silva, V. e Campos, R. (0). Sistemas de Apoio à Decisão. Acedido em 18 de maio de 2014 em http://www.e-learning.ipt.pt
- Silva, V. (0). MACBETH. Acedido em 25 de março de 2015 em http://www.e-learning.ipt.pt
- Silva, V. (0). SQL. Acedido em 6 de março de 2016 em http://www.e-learning.ipt.pt
(0). From big data to better decisions. Acedido em 15 de fevereiro de 2016 em https://www.domo.com/learn/ebook/biguide
Teaching Method
Lectures, tutorials and laboratory classes, for propose and solve pratical cases.
Software used in class
Business Intelligence for support decision software: Microsoft SQL Server Express - Microsoft Management Studio; Microsoft Visual Studio; Report Builder 3.0;
Data analysis: IBM COGNOS Insight. Multicriteria decision support software: MACBETH.
