Dimensional Model, Data Warehouse Architecture, Reporting and Visualization Tools from Data Warehouse, Real-Time Data Warehouses, OLAP, ETL.

1. define the basic concepts of Business Intelligence and Data Warehouses
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

Lectures

Students are presented with theoretical foundations of selected topics intertwined with practical examples.

Partial e-learning

Students have access to one online tutorials which serves as a reminder and crash course for required previus knowledge in SQL.

Independent assignments

Students individually work on their project through six homework assignments

Laboratory

Students discuss their own solutions to project tasks with subject teachers.

1. Introduction, definitions, motivation
2. Dimensional model
3. Dimensional model, Data warehouse architecture, project
4. Dimensional model, Data warehouse design, project
5. Dimensional model, Data warehouse design, project
6. Dimensional model, Data warehouse design, project
7. Dimensional model, Data warehouse design
8. Midterm exam
9. Data visualization, project
10. On-Line Analytical Processing, project
11. ETL (Extract, transform and load)
12. ETL (Extract, transform and load), project
13. ETL (Extract, transform and load)
14. Real-time Data Warehouses
15. Final exam