title: Ð£Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸
title: ÑÑÐµÐ±Ð½Ð¾Ðµ Ð¿Ð¾ÑÐ¾Ð±Ð¸Ðµ
titleType: Subtitle
title: Data management
Creators: name: ÐÐ»ÑÐ¸Ð½, ÐÐ³Ð¾ÑÑ
name: ÐÐ»ÑÑÑÐµÐ½ÐºÐ¾, ÐÐºÑÐ°Ð½Ð°
name: ÐÐ»ÑÑÑÐµÐ½ÐºÐ¾, ÐÐ¸ÐºÑÐ¾ÑÐ¸Ñ
name: Ð¡ÑÑÑÑ, ÐÐ»ÑÐ³Ð°
Publisher: name: ÐÐÐÐÐ¢ÐÐ¥-ÐÐ ÐÐ¡Ð¡
Year: 2023

description: Ð£ÑÐµÐ±Ð½Ð¾Ðµ Ð¿Ð¾ÑÐ¾Ð±Ð¸Ðµ ÑÐ¾Ð´ÐµÑÐ¶Ð¸Ñ ÑÐºÐ°Ð·Ð°Ð½Ð¸Ñ Ðº Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¸Ð¼ Ð·Ð°Ð½ÑÑÐ¸ÑÐ¼ Ð¿Ð¾ Ð´Ð¸ÑÑÐ¸Ð¿Ð»Ð¸Ð½Ðµ Â«Ð£Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸Â», Ð±Ð»Ð°Ð³Ð¾Ð´Ð°ÑÑ Ð¾ÑÐ²Ð¾ÐµÐ½Ð¸Ñ ÐºÐ¾ÑÐ¾ÑÐ¾Ð¹ ÑÑÑÐ´ÐµÐ½ÑÑ Ð¿ÑÐ¸Ð¾Ð±ÑÐµÑÐ°ÑÑ Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¸Ðµ Ð½Ð°Ð²ÑÐºÐ¸ Ð¸ ÑÐ¼ÐµÐ½Ð¸Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð¸ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸, Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÑ Ð¼ÐµÑÐ¾Ð´Ð¸Ðº Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐ°Ð¼ÐºÐ°Ñ Ð¾Ð³ÑÐ°Ð½Ð¸ÑÐµÐ½Ð¸Ð¹ Ð¿ÑÐµÐ´Ð¼ÐµÑÐ½Ð¾Ð¹ Ð¾Ð±Ð»Ð°ÑÑÐ¸. Ð ÑÑÐµÐ±Ð½Ð¾Ð¼ Ð¿Ð¾ÑÐ¾Ð±Ð¸Ð¸ ÑÐ°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ Ð²Ð¾Ð¿ÑÐ¾ÑÑ Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¸ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹. ÐÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½Ñ Ð¾ÑÐ½Ð¾Ð²Ñ ÑÐµÐ¾ÑÐ¸Ð¸ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸. Ð Ð°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ Ð²Ð¾Ð¿ÑÐ¾ÑÑ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÑ ÑÐ¸Ð¿Ð¾Ð² Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð¡Ð£ÐÐ SQL Server Management Studio, ÑÑÐ°Ð¿Ñ Ð¶Ð¸Ð·Ð½ÐµÐ½Ð½Ð¾Ð³Ð¾ ÑÐ¸ÐºÐ»Ð° ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ: Ð¾Ñ Ð²Ð¾Ð¿ÑÐ¾ÑÐ¾Ð² ÑÐ±Ð¾ÑÐ°, ÑÑÐ°Ð½ÑÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸ Ð·Ð°Ð³ÑÑÐ·ÐºÐ¸ Ð´Ð°Ð½Ð½ÑÑ, Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð´Ð¾ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ Ð¿ÑÐ¸Ð½ÑÑÐ¸Ñ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ. Ð¢Ð°ÐºÐ¶Ðµ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ð° Ð¸Ð´ÐµÑ Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¥ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ, BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ. Ð ÐºÐ°ÑÐµÑÑÐ²Ðµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑÑÑÑ Ð¡Ð£ÐÐ SQL Server Management Studio, BI-Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ð° QlikView. Ð£ÑÐµÐ±Ð½Ð¾Ðµ Ð¿Ð¾ÑÐ¾Ð±Ð¸Ðµ Ð¿ÑÐµÐ´Ð½Ð°Ð·Ð½Ð°ÑÐµÐ½Ð¾ Ð´Ð»Ñ ÑÑÑÐ´ÐµÐ½ÑÐ¾Ð², Ð¾Ð±ÑÑÐ°ÑÑÐ¸ÑÑÑ Ð¿Ð¾ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð´Ð³Ð¾ÑÐ¾Ð²ÐºÐ¸ 38.03.05 Â«ÐÐ¸Ð·Ð½ÐµÑ-Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸ÐºÐ°Â».
description: The training manual contains instructions for practical exercises for the discipline "Data Management", through mastering which students acquire practical skills and abilities to use methods and technologies of data management, the use of various techniques for designing database applications within the constraints of the subject area. The training manual covers the issues of designing a data warehouse and BI applications. The theoretical part presents the fundamentals of the data management theory. The practical part deals with the issues of forming different types of queries using SQL Server Management Studio, the stages of the data management life cycle: from the issues of data collection, transformation, and loading, data warehouse design to visualization and decision-making based on data analysis. Also, in the practical part, the idea of designing a data warehouse, BI application is implemented. MS Access DBMS, SQL Server Management Studio, QlikView BI platform are used as tools. The training manual is intended for students studying in the major 38.03.05 "Business Informatics".