Enterprise Data Warehouse Systems

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Applied Mathematics

Synopsis:

The Enterprise Data Warehouses course focuses on the area of business intelligence. Students will be introduced to business intelligence methods and will gain practical knowledge not only in designing warehouses and various architectures, but also their deployment and maintenance. This course also includes an introduction to the area of reporting and data visualization.

Requirements:

Basic knowledge of data modeling and SQL.

Syllabus of lectures:

1. Context of Analytics in an Enterprise

2. Basic functions of BI

3. Access to data architecture and data modeling in the BI domain

4. Data Integration

5. BI Analytics

6. BI Analytics

7. BI and big data appliance systems

8. BI Governance

9. Business Metadata

10. Data Quality and service

11. BI Operations

12. MPP databases, Hadoop

13. Methodology of BI solution design

Syllabus of tutorials:

1. Introduction and motivation for DW

2. Data modeling, historisation and logical map of data

3. ETL processes

4. ETL processes

5. Datamarts

6. Visualization and reporting

Study Objective:

The goal of this course is to offer students compact information about the design, architecture and building of data warehouses. The lectures will be enhanced with practical experience from the area of designing and deploying large data warehouse solutions in Czech Republic.

Study materials:

W. H. Inmon - Building the Data Warehouse (Third Edition)

Note:

Further information:

https://courses.fit.cvut.cz/MI-EDW/

No time-table has been prepared for this course

The course is a part of the following study plans:

• Master branch Knowledge Engineering, in Czech, 2016-2017 (compulsory course of the specialization)
• Master branch Computer Security, in Czech, 2016-2019 (elective course)
• Master branch Computer Systems and Networks, in Czech, 2016-2019 (elective course)
• Master branch Design and Programming of Embedded Systems, in Czech, 2016-2019 (elective course)
• Master branch Web and Software Engineering, spec. Info. Systems and Management, in Czech, 2016-2019 (elective course)
• Master branch Web and Software Engineering, spec. Software Engineering, in Czech, 2016-2019 (elective course)
• Master branch Web and Software Engineering, spec. Web Engineering, in Czech, 2016-2019 (elective course)
• Master program Informatics, unspecified branch, in Czech, version 2016-2019 (VO)
• Master branch System Programming, spec. System Programming, in Czech, 2016-2019 (elective course)
• Master branch System Programming, spec. Computer Science, in Czech, 2016-2017 (elective course)
• Master specialization Computer Science, in Czech, 2018-2019 (elective course)
• Master branch Knowledge Engineering, in Czech, 2018-2019 (compulsory course of the specialization)