Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

Enterprise Data Warehouse Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
NI-EDW Z,ZK 5 1P+1C Czech
Garant předmětu:
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:
Time-table for winter semester 2023/2024:
Time-table is not available yet
Time-table for summer semester 2023/2024:
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
roomT9:350
Kotlář R.
Krejčí J.

12:45–14:15
EVEN WEEK

(lecture parallel1)
Dejvice
NBFIT PC ucebna
roomT9:350
Kotlář R.
Krejčí J.

14:30–16:00
EVEN WEEK

(lecture parallel1
parallel nr.101)

Dejvice
NBFIT PC ucebna
Fri
The course is a part of the following study plans:
Data valid to 2024-05-22
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet6445506.html