Students will be able to design data warehouses and implement business intelligence systems.

1. define the basic concepts of Business Intelligence and Data WarehousesD
2. apply the princples of DW modelling
3. employ the basic ETL procedures
4. operate the basic OLAP technologies
5. employ basic BI tools
6. produce a BI tool prototype

Theoretical fundations and paradigms presented during the lectures are illustrated with practical examples and demonstrated using a business intellence platform.

Application of knowledge acquired in lectures in the form of the homework.

1. Introduction to the course. Introduction to Business Intelligence and Data Warehouse. Definitions of the basic concepts.
2. Introduction to dimensional modelling. First homework assignment.
3. Data Warehouse design approaches. Dimensional modelling (conformed dimensions, dimension roles). Second homework assignment.
4. Dimensional modelling(surrogate keys, indexes, NULL values). Third homework assignment.
5. Construction of a GUI client for the star join. Fourth homework. Dimensional modelling (dimension types).
6. Dimensional modelling (heterogeneous dimensions and fact tables, hierarchies)
7. Fifth homework assignment, dimensional modelling (fact table types, aggregates, drill accross)
8. Midterm exam
9. Dimensional modelling (N:N relationships, late/early arriving records, complicated events). Real-time data warehouses.
10. Real-time data warehouses, OLAP.
11. OLAP. Sixth homework assignment.
12. ETL.
13. ETL. Seventh homework assignement,
14. Security, metadata, permissions, data quality.
15. Final exam.