Sistemas de Apoio à Decisão

Gestão de Empresas (pós-laboral)
4 ECTS; 3º Ano, 2º Semestre, 15,0 T + 30,0 PL

Lecturer
- Vasco Renato Marques Gestosa da Silva

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
- , D. (0). From big data to better decisions.Acedido em15 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 - Conceitos.Acedido em18 de maio de 2012 em http://www.e-learning.ipt.pt
- Silva, V. (0). MACBETH.Acedido em25 de março de 2015 em http://www.e-learning.ipt.pt
- Silva, V. (0). SQL.Acedido em6 de março de 2016 em http://www.e-learning.ipt.pt

Method of interaction
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.