IPT Logotipo do IPT

Ano Letivo: 2017/18

Bachelor's Degree in Gestão de Empresas

Decision-Making Support Systems

<< back to Curriculum Plan

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

- Vasco Renato Marques Gestosa da Silva

Not applicable.

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.

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.

(0). From big data to better decisions. Acedido em 15 de fevereiro de 2016 em https://www.domo.com/learn/ebook/biguide
- 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). SQL. Acedido em 6 de março de 2016 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

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.




<< back to Curriculum Plan