IPT Logotipo do IPT

Ano Letivo: 2020/21

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 , 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.

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado