Infopaket

Business Analytics

ДВС.1.0.2

Вибіркова дисципліна для ОП

Second

2021/2022

2 Semester

5

To know the basic concepts of multidimensional data models, and data manipulation operations; to know the basic concepts of distributed data models, twelve Objectives for Distributed Database Systems, logical architecture of distributed databases; know the basic principles of ensuring the integrity of distributed data, features of distributed data storage, horizontal, vertical and mixed data fragmentation, data replication, replica management; know the characteristics of distributed transaction processing,ACID requirements, data blocking, reliability of distributed transaction processing; know the concept and model of OLAP data,the architecture of OLAP systems, technical aspects of multidimensional data storage; to know the organization of data fusion processes from disparate data sources, the filling of data warehouses and data showcases,the organization of data cleaning and standardization; be able to deploy Analysis Services, define data source views in an Analysis Services project.

Full-time form

To know the basics of higher mathematics, algorithms and programming, design of information and communication systems, and basic principles of database organization. Be able to work with different data types. Be able to conduct the logical design of relational databases, and describe the "one-to-many" and "many-to-many" relationships. Have basic skills in working with tools for developing and administrating database management systems, and integrated development environments.

The study of the discipline "Business Analytics" is aimed at gaining knowledge of the organization of data warehouses and methods of their processing, formation and analysis; methodologies for extracting new knowledge from large volumes of data to support management decision-making at various levels; mastering the basic capabilities of Analysis Services. The goal of the discipline is for students to acquire theoretical knowledge and practical skills necessary for mastering the basics of OLAP (Online Analytical Processing, real-time analytical processing); familiarization with the theoretical foundations of building data warehouses and their application in collecting and analyzing information; familiarization with the problems of saving and processing analytical information; acquiring practical skills in creating a data warehouse and working with the Microsoft SQL Server Analysis Services tool.

1. Пасічник В.В. Сховища даних: Навчальний посібник. / В.В. Пасічник, Н.Б. Шаховська. — Львів: «Магнолія 2006», 2008. — 496 с. 2. Knight B. Professional Microsoft® SQL Server® 2014 Integration Services / Knight B., Knight D., Moss J., Davis M., Rock C. — Indianapolis: John Wiley & Sons, Inc., 2014. — 878 p. 3. Литвинов О.А. Розподілена обробка інформації : [моногр.] / О.А. Литвинов, В.С. Хандецький. — Д.: ТОВ «Баланс-Клуб», 2013. — 314 с. 4. Thomas LaRock, Enrico van de Laar. Programming Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database. Apress, 2023. — 412 p. 5. Ситник В. Ф. Системи підтримки прийняття рішень: Навч. посіб. — К.: КНЕУ, 2009. — 614 с. 6. Dejan Sarka. Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data. — Ljubjana, Slovenia: Apress., 2021. — 308 p.

Lectures, laboratory classes, individual work

Assessment of students is carried out during the semester for all types of work, including the study of the theoretical material of the course, the performance of laboratory work and individual work. To determine the level of achievement of learning outcomes, students present the results of the developed program during the defence of laboratory reports and tasks for independent work, answer the questions of the teacher, to test the acquired skills, the teacher can give additional tasks that must be implemented by the student during the defence of the work in presence of the teacher. At the end of the semester, a final written test is conducted. The condition for obtaining a positive final grade in the discipline is to achieve at least 60% of the maximum possible number of points, while the grade for the learning outcomes provided for in points 2, and 3 cannot be less than 50% of the maximum level. The maximum number of points during the semester is 60 points on a 100-point scale.

Ukrainian