Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Data Warehouse Systems (17.E2502)

Native organizations units: Sub-department for Applied Computer Science and Informatics

Type of studies	Title
Master Academic Studies	Information and Analytics Engineering (Godina: 1, Winter)
Master Academic Studies	Computing and Control Engineering (Godina: 1, Winter)
Master Academic Studies	Information Engineering (Godina: 1, Winter)
Master Academic Studies	Computing and Control Engineering (Godina: 1, Winter)
Master Academic Studies	Computing and Control Engineering (Godina: 1, Winter)
Master Academic Studies	Software Engineering and Information Technologies (Godina: 1, Winter)
Master Academic Studies	Measurement-Information Technologies and Control Engineering (Godina: 1, Winter)

General information:

Category	Academic-general educative
Scientific or art field	Applied Computer Science and Informatics
Interdisciplinary	No
ECTS	6

Educational goal:

Advanced students' education in the Data Warehouse (DW) system development and its application in Business Intelligence, i.e. software support of strategic and tactic management in organization systems.

Educational outcome:

To gain necessary skills and knowledge for the design and implementation of business intelligence and data warehouse systems in industry practice, as well as coupling these systems with decision support systems.

Course content:

Characteristics, tasks and application domains of DW systems. Strategic system analysis as a prerequisite for the development of DW and business intelligence systems. Planning the DW system development process. A common methodology of the DW system development. A common DW system architecture. Enterprise DW systems and Data Mart systems. A common structure and the design of database schemas for DW systems. Methods and techniques of the initial load and subsequent refreshing of a DW database. Extraction, transforming and loading data into a DW database – ETL process. Computation of aggregated data in DW databases. Database Management Systems' mechanisms aimed at providing various DW system implementations. Preserving operational performances of DW systems. Decision support systems. OLAP tools and data analyses. Reporting techniques and tools. Data Mining techniques and tools in DW systems.

Teaching methods:

Teaching is performed through lessons, oral and computer exercises (in the computer classroom), as well as consultations. Through the teaching process, students are constantly motivated to an intensive discussion, problem oriented reasoning, independent study work and active participation in the whole lecturing process. The prerequisite to enter final exam is to complete all the pre-exam assignments by earning at least 30 points.

Literature:

Authors	Title	Year	Publisher	Language
Golfarelli Matteo, Rizzi, Stefano	Data Warehouse Design: Modern Principles and Methodologies	2009	McGraw-Hill	English
Ramakrishnan R., Gehrke J.	Database Management Systems	2000	Mc Graw Hill	English
Kimball R., Ross M.	The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2nd Edition)	2002	John Wiley and Sons, Inc.	English
Grupa autora	Priručnici za obezbeđenje upotrebe izabranog softverskog alata za razvoj DW sistema.	2005		English
Inmon W. H.	Building The Data Warehouse (3rd Edition)	2002	John Wiley & Sons, Inc, USA	English