The course provides students with the knowledge about the principles of design and appliance of data warehouse (DW), emphasizing the significance of strategic analysis of organization for the development of DW system. Through mastering general design methodology and general architecture of DW, students should be able to plan the project of DW development, choose the appropriate architecture components and build DW that will be good basement for quality business intelligence system. Given the extremely dynamic development of commercial tools in this area, an important goal is to enable students to a systematic approach to the study of new tools that will enable them to quickly and easily master their use.

Upon completing this course successfully, students will be able to: formulate problem from Universe of Discourse, design and implement database, model and build the system to carry out analytical data from transactional data, using several methods and techniques, and to build a data warehouse. Student will be introduced with the mechanisms of database management systems aimed at data warehouse system support, and with the techniques for the performance improvement of data warehouse systems.

Introduction to data warehouse systems and business intelligence. Strategical analysis of the organization, data warehouse system development and decision support systems. The complexity of the construction and use of data warehouse systems. Architecture of data warehouse system. Data warehouse design methodology. Meta-data management. Methods and techniques for initially loading and refreshing of data warehouse. Methods and techniques to derive analytical data from transactional data. Data transformation and loading. Data base management system mechanisms to support data warehouse system. Performance, safety and security of data warehouse systems.

Lectures; laboratory exercises; individual consultations; team work on the design of conceptual data base schema; individual work (assignments). Students are encouraged to communicate, to reason critically, to work independently and to contribute actively to teaching process.