Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Business Intelligence and Data Warehouse Systems in Infrastructural Systems (17.ESI087)

Type of studies	Title
Master Academic Studies	Power Software Engineering (Year: 1, Semester: Winter)

General information:

Category	Professional-applicative
Scientific or art field	Primenjeno softversko inženjerstvo
ECTS	6

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. Mastering data mining algorithms and techniques in the fields of information and decision support systems.

Gaining necessary skills and knowledge for the design and implementation of business intelligence and data warehouse systems in industry and business domain. Utilization of DW systems within information and decision support systems.

Characteristics, tasks and application domains of DW in power 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. The use in infrastructure system software model. Algorithms overview and data model in infrastructure systems. Numeric calculations in infrastructure systems.

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.

Authors	Title	Year	Publisher	Language
Ralph Kimball, Margy Ross	The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition	2002	John Wiley and Sons, Inc.	English
William H. Inmon	Building The Data Warehouse, 3rd Edition	2002	John Wiley & Sons, Inc, USA	English
A.Murray, T.Grubesic	Critical Infrastructure - Reliability and Vulnerability	2007	Springer	English
Matteo Golfarelli, Stefano Rizzi	Data Warehouse Design: Modern Principles and Methodologies	2009	McGraw-Hill, USA	English