Students will be able to design data warehouses and implement business intelligence systems.
- define the basic concepts of Business Intelligence and Data WarehousesD
- apply the princples of DW modelling
- employ the basic ETL procedures
- operate the basic OLAP technologies
- employ basic BI tools
- produce a BI tool prototype
Forms of Teaching
Theoretical fundations and paradigms presented during the lectures are illustrated with practical examples and demonstrated using a business intellence platform.Programming Exercises
Application of knowledge acquired in lectures in the form of the homework.
|Type||Threshold||Percent of Grade||Threshold||Percent of Grade|
|Homeworks||30 %||40 %||30 %||40 %|
|Mid Term Exam: Written||0 %||25 %||0 %|
|Final Exam: Written||30 %||35 %|
|Exam: Written||0 %||30 %|
|Exam: Oral||30 %|
Week by Week Schedule
- Introduction to the course. Introduction to Business Intelligence and Data Warehouse. Definitions of the basic concepts.
- Introduction to dimensional modelling. First homework assignment.
- Data Warehouse design approaches. Dimensional modelling (conformed dimensions, dimension roles). Second homework assignment.
- Dimensional modelling(surrogate keys, indexes, NULL values). Third homework assignment.
- Construction of a GUI client for the star join. Fourth homework. Dimensional modelling (dimension types).
- Dimensional modelling (heterogeneous dimensions and fact tables, hierarchies)
- Fifth homework assignment, dimensional modelling (fact table types, aggregates, drill accross)
- Midterm exam
- Dimensional modelling (N:N relationships, late/early arriving records, complicated events). Real-time data warehouses.
- Real-time data warehouses, OLAP.
- OLAP. Sixth homework assignment.
- ETL. Seventh homework assignement,
- Security, metadata, permissions, data quality.
- Final exam.