Decision-Making Support Systems

Business Administration (pós-laboral), 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


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
- Mendes, J. e Marques, C. e Silva, V. e Campos, R. (0). Sistemas de Apoio à Decisão - Conceitos. Acedido em 18 de maio de 2012 em
- Silva, V. (0). MACBETH. Acedido em 25 de março de 2015 em
- Silva, V. (0). SQL. Acedido em 6 de março de 2016 em

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.