Data Analytics Technology

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

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

Assessment Methods

Assessment
Exam: 40.0%
Project: 60.0%

Bibliography

"Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems." Kleppmann, Martin.  2018.

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

“Data Mining“, Witten Frank. Morgan Kaufman, 4th Edition, 2016.