Enterprise Data Warehouse Systems
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| NI-EDW | Z,ZK | 5 | 1P+1C | Czech |
- Course guarantor:
- Magda Friedjungová
- Lecturer:
- Robert Kotlář, Jakub Krejčí
- Tutor:
- Robert Kotlář, Jakub Krejčí
- 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. Introduction and motivation for BI and DWH
2. Data modeling, data quality, metadata, DLM
3. ETL processes and data integration
4. ETL processes
5. Datamarts
6. Visualization and reporting (BI Analytics)
- Syllabus of tutorials:
-
1. Introduction and motivation for BI and DWH
2. Data modeling, data integration
3. ETL processes
4. ETL processes
5. Datamarts
6. Visualization and reporting (BI Analytics)
- 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/NI-EDW
- Time-table for winter semester 2024/2025:
- Time-table is not available yet
- Time-table for summer semester 2024/2025:
-
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon Tue Wed Thu Fri - The course is a part of the following study plans:
-
- Master specialization Computer Security, in Czech, 2020 (elective course)
- Master specialization Design and Programming of Embedded Systems, in Czech, 2020 (elective course)
- Master specialization Computer Systems and Networks, in Czech, 202 (elective course)
- Master specialization Management Informatics, in Czech, 2020 (elective course)
- Master specialization Software Engineering, in Czech, 2020 (elective course)
- Master specialization System Programming, in Czech, version from 2020 (elective course)
- Master specialization Web Engineering, in Czech, 2020 (elective course)
- Master specialization Knowledge Engineering, in Czech, 2020 (elective course)
- Master specialization Computer Science, in Czech, 2020 (elective course)
- Mgr. programme, for the phase of study without specialisation, ver. for 2020 and higher (elective course)
- Study plan for Ukrainian refugees (elective course)
- Master specialization System Programming, in Czech, version from 2023 (elective course)
- Master specialization Computer Science, in Czech, 2023 (elective course)
- Quantum Informatics (elective course)