title: ÐÐ±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð½ÐµÐ¾Ð±Ñ Ð¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ Ð² Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Rationale for implementation of a Business Intelligence system in a manufacturing company
Creators: name: ÐÐ°ÑÑÑÐ¾Ð², ÐÐ»ÑÑ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: BI-ÑÐ¸ÑÑÐµÐ¼Ð°
Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½Ð°Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ñ
Ð°Ð½Ð°Ð»Ð¸Ð· Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð²
ETL-Ð¿ÑÐ¾ÑÐµÑÑ
ÐÐ¥Ð
Ð²Ð¸ÑÑÐ¸Ð½Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð¾ÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ
BI-system
manufacturing company
process analysis
ETL-process
DWH
data marts
performance evaluation

description: Ð¦ÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ Ð² Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. ÐÐ°Ð´Ð°ÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ: 1. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ ÑÐµÐ¾ÑÐµÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð°ÑÐ¿ÐµÐºÑÐ¾Ð² Ð±Ð¸Ð·Ð½ÐµÑ-Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸ Ð´Ð»Ñ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¿ÑÐ¾ÐµÐºÑÐ° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ. 2. ÐÐ½Ð°Ð»Ð¸Ð· Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸, Ð²ÑÑÐ²Ð»ÐµÐ½Ð¸Ðµ Ð½ÐµÐ´Ð¾ÑÑÐ°ÑÐºÐ¾Ð² ÑÐµÐºÑÑÐµÐ³Ð¾ Ð¿Ð¾Ð´ÑÐ¾Ð´Ð° Ð¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ. 3. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¾Ð³ÑÐ°Ð½Ð¸ÑÐµÐ½Ð¸Ð¹ Ð¸ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹ Ðº ÑÐ¸ÑÑÐµÐ¼Ðµ. ÐÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ ÑÐµÑÐµÐ½Ð¸Ñ Ð² Ð²Ð¸Ð´Ðµ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÐ¾ÑÑÑÐ¾ÐµÐ½Ð¸Ðµ ÑÐµÐ»ÐµÐ²Ð¾Ð¹ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÑ Ð±Ð¸Ð·Ð½ÐµÑ- Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. 4. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿Ð»Ð°Ð½Ð° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¸ Ð¾ÑÐµÐ½ÐºÐ° ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð². Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ ÑÐ°Ð±Ð¾ÑÑ: 1. Ð Ð°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ ÑÐµÐ¾ÑÐµÑÐ¸ÑÐµÑÐºÐ¸Ðµ Ð°ÑÐ¿ÐµÐºÑÑ Ð±Ð¸Ð·Ð½ÐµÑ-Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸, Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼ÑÐµ Ð´Ð»Ñ Ð¾ÑÑÑÐµÑÑÐ²Ð»ÐµÐ½Ð¸Ñ Ð¿ÑÐ¾ÐµÐºÑÐ° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ. 2. ÐÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²ÐµÐ½Ð½Ð¾Ð¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸, Ð²ÑÑÐ²Ð»ÐµÐ½Ñ ÑÐ·ÐºÐ¸Ðµ Ð¼ÐµÑÑÐ° Ð¸ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ñ ÑÐµÐºÐ¾Ð¼ÐµÐ½Ð´Ð°ÑÐ¸Ð¸ Ð¿Ð¾ ÑÑÑÑÐ°Ð½ÐµÐ½Ð¸Ñ. 3. ÐÑÐ¾Ð²ÐµÐ´ÐµÐ½ ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½ÑÐ¾Ð² BI-ÑÐ¸ÑÑÐµÐ¼Ñ, Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð° Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÐ° ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÑÐ»Ð° Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð° ÑÐµÐ»ÐµÐ²Ð°Ñ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÐ° Ð±Ð¸Ð·Ð½ÐµÑ-Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. 4. Ð¡Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½ Ð¿ÑÐ¾ÐµÐºÑ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð½Ð¾Ð³Ð¾ ÑÐµÑÐµÐ½Ð¸Ñ. 5. ÐÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð° Ð¾ÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÑÐ»Ð¸ Ð²ÑÐ´ÐµÐ»ÐµÐ½Ñ ÐºÐ°ÑÐµÑÑÐ²ÐµÐ½Ð½ÑÐµ Ð¸ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²ÐµÐ½Ð½ÑÐµ Ð¿Ð¾Ð»ÐµÐ·Ð½ÑÐµ ÑÑÑÐµÐºÑÑ Ð¾Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ°Ñ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾ÑÑÑ ÑÐ°Ð±Ð¾ÑÑ Ð·Ð°ÐºÐ»ÑÑÐ°ÐµÑÑÑ Ð² Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð½Ð° Ð¿ÑÐ°ÐºÑÐ¸ÐºÐµ Ð² Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ ÐÐÐ Â«ÐÐ°Ð²Ð¾Ð´ ÐÑÐ¾Ð´Ð¼Ð°ÑÂ». ÐÑÐ»Ð° Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð° Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÑ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ Ð´Ð»Ñ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸, ÑÐ°ÐºÐ¶Ðµ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ñ ÑÐºÐ¾Ð½Ð¾Ð¼Ð¸ÑÐµÑÐºÐ¸Ðµ Ð¿ÐµÑÑÐ¿ÐµÐºÑÐ¸Ð²Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ. ÐÑÐ²Ð¾Ð´Ñ. ÐÐ°Ð´Ð°ÑÐ¸ ÐÐÐ  ÑÐµÑÐµÐ½Ñ, ÑÐµÐ»Ñ Ð´Ð¾ÑÑÐ¸Ð³Ð½ÑÑÐ°, Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð° Ð¾Ð±Ð»Ð°ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð².
description: The purpose of the research is the rationale for implementation of BI-system in a manufacturing company. Tasks of work: 1. Study of the theoretical aspects of business analytics for the implementation of the BI-system implementation project. 2. Analysis of the manufacturing companys activities, identification of shortcomings of the current approach and justification of the need for implementation. 3. Development of restrictions and requirements for the system. Offering a solution in the form of a BI-system implementation. Building the target architecture of the companys business processes. 4. Development of a system implementation plan and evaluation of the results. Results of work: 1.The theoretical aspects of business intelligence necessary for the implementation of the implementation project are considered. 2. The analysis of the production companys activities was carried out, bottlenecks were identified and recommendations for elimination were proposed. 3. A comparative analysis of the components of the BI system was carried out, and a system architecture was proposed. The target architecture of the companys business processes was built. 4. A project for implementing the proposed solution has been drawn up. 5. The effectiveness of the BI system implementation was assessed. Qualitative and quantitative beneficial effects from the implementation of the system were highlighted. The practical significance of the work lies in the possibility of using the results of the research in practice in the activities of JSC "Plant Prodmash". The necessity of implementing a BI-system to improve the efficiency of the companys activities was justified, and the economic prospects for implementation were also determined. Conclusions. The tasks of the thesis have been solved, the goal has been achieved, the scope of the results has been determined.