Subject aims expressed by acquired skills and competences

A student is able to orient in the domain of Business Intelligence and Data Warehousing (DWH), in particular practical knowledge of DWH data modeling methodology, ETL processes and data integration to data warehouses. Moreover, the student knows the methodology and he/she is able to create a reporting layer - data marts for analytics and reporting over data. The student is capable to describe the core basis of necessary data processing and operations with data in DWH database.

Teaching methods

Lectures
Tutorials

Summary

The course is a follow-up to the Database and Information Systems 2 course with focus on applying the knowledge to the domain of Business Intelligence and Data Warehouse. The content of lectures is based on getting familiar with principles of Data Warehousing, data modelling specifics, design of respective layers of a data warehouse, data integration using SQL scripts and ETL tools, data transformations within respective layers of a data warehouse including final aggregations of data in order to be presented as business information in a graphical form and layout, or in a form of data extracts for further processing, where the second part of the course carries on in the next term. Another part of the course is the methodology for the solution design of a DWH and data integration projects. During practical sessions students will make use of the methodology in a practical example of data warehouse design and development in an SQL database environment within scope of their final work.