Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Data Warehouse Design (17.IZOI41)

Type of studies	Title
Undergraduate Academic Studies	Information Systems Engineering (Year: 4, Semester: Summer)

General information:

Category	Scientific-professional
Scientific or art field	Inženjerstvo informacionih sistema Information-Communication Systems
ECTS	5

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 and individual work (assignments, complex exercises and project). Students are encouraged to communicate, to reason critically, to work independently and in the team, and to contribute actively to teaching process.

Authors	Title	Year	Publisher	Language
Kimball R., Ross	The Data Warehouse	2013	Wiley	English
Sharda, R., Delen, D., Turban, E.	Business Intelligence, Analytics and Data Science - A Managed Perspective	2017	Pearson, New York	English
Elmasri R, Navathe S.	Fundamentals of Database Systems, 7/E	2015	Pearson Education Ltd.	English
Sadalage J. P., Fowler M.	NoSQL Distilled A Brief Guide to the Emerging World of Polyglot Persistence	2013	Pearson Education, Inc.	English