Business Intelligence

Year
1
Academic year
2023-2024
Code
02000124
Subject Area
Optional
Language of Instruction
English
Other Languages of Instruction
Portuguese
Mode of Delivery
Face-to-face
Duration
SEMESTRIAL
ECTS Credits
6.0
Type
Elective
Level
2nd Cycle Studies - Mestrado

Recommended Prerequisites

Programming, Introduction to Artificial Intelligence, Databases, Techniques for Pattern Recognition.

Teaching Methods

Theoretical classes with detailed exposition, using visual aids, of the concepts, principles and fundamental theories of Data Warehousing, OLAP and Data Mining.

Practical-laboratory practices, in which students are required to acquire knowledge about tools and techniques for developing practical applications involving OLAP and Data Mining and that, under the guidance of the teachers, develop a work (project).

Learning Outcomes

The objectives of this course are to study the main methodologies for developing business intelligence solutions and show how the techniques of Data Warehouses (DW), OLAP and Data Mining (DM) can be combined in building software solutions for decision support.

This course aims to boost the development of the following skills:

- Apply knowledge in practice: applying knowledge in the development of decision support systems in real environments

- Autonomous learning, problem solving and decision-making: ability to identify sources of knowledge, finding solutions to the development of applications for data analysis taking into account the organizational needs, using the methodologies of DW, OLAP and DM

- Oral and written communication, understanding the language of experts and non experts in the field: to communicate and justify the technical options in understandable language either for specialists or non specialists

Work Placement(s)

No

Syllabus

Business Study

Data warehousing and OLAP

- Introduction to Data Warehouses

- Multidimensional Analysis and Star Schemas

- Data Warehouse Project

- Data Extraction, Transformation and Loading

- Optimization and Administration of Data Warehouses

- Multidimensional Databases and OLAP

- Advanced topics and new paradigms for data processing problems

 

Data Mining

- Data Selection

- Data Pre-processing

- Selection and Application of Data Mining Algorithms

- Evaluation of Generated Data Models

- Visualization and Selection of Data Models

- Application of Data Models.

Head Lecturer(s)

Catarina Helena Branco Simões da Silva

Assessment Methods

Assessment
Exam: 40.0%
Project: 60.0%

Bibliography

“The Data WarehouseLifecycleToolkit”, Ralph Kimbal et.al, J. Wiley& Sons, Inc, 2nd Edition, 2008.

“Data Mining“, Witten Frank. Morgan Kaufman, 3rd Edition, 2011.