Decision Support Systems

Presentation

The Decision Support Systems course (UC) is part of the core course of the Information Systems course. It promotes students' first contact with data storage models dedicated to information exploration.

Programme

IT Engineering

Level of Qualification|Semesters|ECTS

| Semestral | 5

Year | Type of course unit | Language

3 |Mandatory |Português

Code

ULP452-7303

Recommended complementary curricular units

Databases

Professional Internship

Não

Syllabus

1 Decision Support Systems. Introduction.
Analytical Systems vs. Operational systems
Data Warehouse Utility
Analytical Reporting .Examples
Data Mining Examples
SSD architecture

02 .Data Warehouse
DW Project Lifecycle
DW Key Elements
Dimensional model
Extract / Transform / Load (ETL) Process
DW Maintenance
Common Mistakes

03 - Analytical Reporting
Recipient Identification
Requirements Management
Development
Testing and Validation

04 Knowledge Extraction from Databases
Data Mining Introduction
Decision trees
Bayesian Learning
Clustering
Instance-based learning
Support Vector Machines
Neuronal networks
Genetic Algorithms
Experimental Evaluation of Algorithms
Association Rules Extraction

05 The SSD in the Company
The impact of SSD on the organization
Data quality
Success Factors

Objectives

Create in students the ability to develop Decision Support Systems (SSD) and apply analysis and inference algorithms to large data sets, particularly in the design, development and maintenance of Data Warehouse Systems. Develop students' sensitivity to the problems of classification rule inference and the applicability of various inference paradigms. Familiarize students with academic and business tools that use learning techniques, data analysis problems and know how to apply them to concrete problems.

Design, develop and maintain Data Warehouse Systems and Analytical Reporting Systems.

Identification of the need for data mining solutions, and ability to select the appropriate algorithms for this purpose.

Teaching methodologies and assessment

Students should develop a Group Project (maximum 2 students) throughout the semester: develop a Decision Support System for a National ERP Database or other Database.
The Project will be organized in 2 Modules (phases) that will be presented in class, in 2 different moments. These presentations, as well as the written report, will focus on the assessment of this course. There will also be a written test and a Case Study to be presented in class.
Each evaluation component will have the following weights:
First assignment and presentation: 30%
Second paper submission and presentation: 30%
Frequency: 30%
Case Study: 10%

References

• Kimball, R., Reeves, L., Ross, M., Thornthwait, W., The Data Warehouse Lifecycle Toolkit - Expert Methods for Designing, Developing, and Deploying Data Warehouses, John Wiley & Sons,1998.

Office Hours