Analytical Data Warehouse

Major: Distributed Information Systems and Technologies
Code of subject: 6.126.03.E.056
Credits: 6.00
Department: Information Systems and Networks
Lecturer: Ph.D. Mykich Khrystyna Ihorivna
Semester: 6 семестр
Mode of study: денна
Мета вивчення дисципліни: The purpose of the course is to acquaint students with the concepts and methods of working with analytical data warehouses, available models of data warehouses, study the principles of organization, design and maintenance of data warehouses and data integration in the data warehouse, study methods of data integration, in particular ETL.
Завдання: The study of an educational discipline involves the formation of competencies in students of education: integral: The ability to solve complex specialized tasks and practical problems of system analysis in professional activity or in the learning process, which involve the application of theoretical provisions and methods of system analysis and information technologies and are characterized by complexity and uncertainty of conditions. general competences: K01. Ability to abstract thinking, analysis and synthesis. K02. Ability to apply knowledge in practical situations. K04. Knowledge and understanding of the subject area and understanding of professional activity. K13. Ability to work in an international context. K17. The ability to make decisions and act in accordance with the principle of inadmissibility of corruption and any other manifestations of dishonesty. professional competences: K23. The ability to use modern information technologies for computer implementation of mathematical models and prediction of the behavior of specific systems, namely: object-oriented approach in the design of complex systems of various nature, applied mathematical packages, application of databases and knowledge. K24. Ability to organize work on the analysis and design of complex systems, creation of appropriate information technologies and software. K25. Ability to organize work on the analysis and design of complex systems, creation of appropriate information technologies and software. specialized professional competences: FCS1.2. The ability to effectively conduct system analysis, select a conceptual model of the information system environment based on mathematical models and decision-making methods, parameterize the components of an intelligent decision-making support system, business process modeling, IT project planning, IT project requirements management.
Learning outcomes: As a result of studying the academic discipline, the student must be able to demonstrate the following learning outcomes: PR11. Know and be able to apply database and knowledge management systems and information systems in practice. PR 1.5. To know the basic technologies of development and implementation of conceptual modeling of analytical data warehouses.
Required prior and related subjects: 1. Databases and knowledge bases organization. 2. Big Data Analysis Technologies
Summary of the subject: The course is aimed at acquiring skills in the design and development of analytical data warehouses.
Опис: The student must master the skills of designing and creating analytical data warehouses that meet all the requirements of consistency, security and performance. This, in turn, requires knowledge not only in the field of actual development, but also knowledge of the tools that allow in the process of operating data warehouses to carry out their operational maintenance and support (ETL process).
Assessment methods and criteria: Knowledge diagnostics is carried out by evaluating the completed laboratory work and examination control (written and oral components) in the form of test questions.
Критерії оцінювання результатів навчання: • Current control (45%): written reports on laboratory work, essay, oral examination; • Final control (55% of exam): in written, verbally.
Recommended books: 1. Шаховська Н. Б. Сховища та простори даних. Книга 2 : Простори даних: підручник / Н. Б. Шаховська, Н. Е. Кунанець. – Львів: "Новий Світ - 2000", 2017. – 363 c. 2. Верес О.М.. Системи баз даних та знань. Книга 1. Організація баз даних та знань: підручник [для студ. вищ. навч. закл.] / Берко А. Ю., Верес О. М., Пасічник В.В. – Львів : „Магнолія 2006”, 2022. – 440 с. — (Серія «Комп’ютинґ»). 3. Верес О.М. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: підручник / Берко А.Ю., Верес О.М., Пасічник В.В. – Львів : „Магнолія 2006”, 2022. – 470 с.