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.
Порядок та критерії виставляння балів та оцінок: 100-88 points - certified with an “excellent” grade - High level: the student demonstrates an in-depth mastery of the conceptual and categorical apparatus of the discipline, systematic knowledge, skills and abilities of their practical application. The mastered knowledge, skills and abilities provide the ability to independently formulate goals and organize learning activities, search and find solutions in non-standard, atypical educational and professional situations. The applicant demonstrates the ability to make generalizations based on critical analysis of factual material, ideas, theories and concepts, to formulate conclusions based on them. His/her activity is based on interest and motivation for self-development, continuous professional development, independent research activities, implemented with the support and guidance of the teacher. 87-71 points - certified with a grade of “good” - Sufficient level: involves mastery of the conceptual and categorical apparatus of the discipline at an advanced level, conscious use of knowledge, skills and abilities to reveal the essence of the issue. Possession of a partially structured set of knowledge provides the ability to apply it in familiar educational and professional situations. Aware of the specifics of tasks and learning situations, the student demonstrates the ability to search for and choose their solution according to the given sample, to argue for the use of a particular method of solving the problem. Their activities are based on interest and motivation for self-development and continuous professional development. 70-50 points - certified with a grade of “satisfactory” - Satisfactory level: outlines the mastery of the conceptual and categorical apparatus of the discipline at the average level, partial awareness of educational and professional tasks, problems and situations, knowledge of ways to solve typical problems and tasks. The applicant demonstrates an average level of skills and abilities to apply knowledge in practice, and solving problems requires assistance, support from a model. The basis of learning activities is situational and heuristic, dominated by motives of duty, unconscious use of opportunities for self-development. 49-00 points - certified with a grade of “unsatisfactory” - Unsatisfactory level: indicates an elementary mastery of the conceptual and categorical apparatus of the discipline, a general understanding of the content of the educational material, partial use of knowledge, skills and abilities. The basis of learning activities is situational and pragmatic interest.
Recommended books: 1. Шаховська Н. Б. Сховища та простори даних. Книга 2 : Простори даних: підручник / Н. Б. Шаховська, Н. Е. Кунанець. – Львів: "Новий Світ - 2000", 2017. – 363 c. 2. Верес О.М.. Системи баз даних та знань. Книга 1. Організація баз даних та знань: підручник [для студ. вищ. навч. закл.] / Берко А. Ю., Верес О. М., Пасічник В.В. – Львів : „Магнолія 2006”, 2022. – 440 с. — (Серія «Комп’ютинґ»). 3. Верес О.М. Системи баз даних та знань. Книга 2. Системи управління базами даних та знань: підручник / Берко А.Ю., Верес О.М., Пасічник В.В. – Львів : „Магнолія 2006”, 2022. – 470 с.