title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð²ÐµÐ´ÐµÐ½Ð¸Ñ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸ Ð¿ÑÐ¾Ð´Ð°Ð¶ ÑÐ»ÐµÐºÑÑÐ¾ÑÐ¾Ð²Ð°ÑÐ¾Ð²
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development and implementation of a BI application for conducting analytics of sales of electrical goods
Creators: name: Ð¡ÑÑÐ¸Ð½Ð¸Ð½, ÐÐ»Ð°Ð´Ð¸Ð¼Ð¸Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2021
Subjects: Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¸Ð¹ Ð´Ð°ÑÐ±Ð¾ÑÐ´
Â«Power BIÂ»
ÐºÐ²Ð°Ð´ÑÐ°Ð½Ñ Â«GartnerÂ»
ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ°
Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ
Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ° Ð´Ð°Ð½Ð½ÑÑ
analytical dashboard
data analytics
"Power BI"
quadrant "Gartner"
development
implementation

description: Ð¦ÐµÐ»Ñ ÑÐ°Ð±Ð¾ÑÑ â ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°ÑÑ Ð¸ Ð²Ð½ÐµÐ´ÑÐ¸ÑÑ Ð´Ð°ÑÐ±Ð¾ÑÐ´ Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð¾ Ð¿ÑÐ¾Ð´Ð°Ð¶Ð°Ñ Ð´Ð»Ñ Ð¾ÑÐ´ÐµÐ»Ð° Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸. ÐÐ°Ð´Ð°ÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ: - Ð¸Ð·ÑÑÐµÐ½Ð¸Ðµ Ð¾Ð±ÑÐµÐºÑÐ¾Ð² Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ Ð´Ð°ÑÐ±Ð¾ÑÐ´Ð¾Ð²; - Ð²ÑÑÐ²Ð»ÐµÐ½Ð¸Ðµ ÑÐ»Ð°Ð±ÑÑ Ð¼ÐµÑÑ Ð² ÑÑÑÐµÑÑÐ²ÑÑÑÐµÐ¼ Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð¿ÑÐµÐ´Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð°; - ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð´Ð°ÑÐ±Ð¾ÑÐ´Ð°; - Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÑÐµÐºÑÐ¾Ð² Ð¿Ð¾ÑÐ»Ðµ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ Ð½Ð¾Ð²Ð¾Ð³Ð¾ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ. Ð Ð°Ð±Ð¾ÑÐ° Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð° Ð½Ð° Ð¼Ð°ÑÐµÑÐ¸Ð°Ð»Ð°Ñ Ð¾ Ð´ÐµÑÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ ÐÐÐ Â«Ð Ð¾Ð±ÐµÑÑ ÐÐ¾ÑÂ». ÐÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð½ÑÐµ Ð¼ÐµÑÐ¾Ð´Ñ: ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð·, Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð±Ð¸Ð·Ð½ÐµÑ-Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð², Ð°Ð½Ð°Ð»Ð¸Ð· Ð´Ð°Ð½Ð½ÑÑ, Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÑ Ð¸Ð½ÑÐ¾Ð³ÑÐ°ÑÐ¸ÐºÐ¸. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ ÑÐ°Ð±Ð¾ÑÑ: - Ð¿ÑÐ¸ Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð¸Ð¸ Ð¼Ð¾Ð´ÐµÐ»Ð¸ As Is Ð½Ð°Ð¹Ð´ÐµÐ½Ð¾ ÑÐ»Ð°Ð±Ð¾Ðµ Ð¼ÐµÑÑÐ¾ Ð² Ð±Ð¸Ð·Ð½ÐµÑ-Ð¿ÑÐ¾ÑÐµÑÑÐµ, Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¾ ÑÐµÑÐµÐ½Ð¸Ðµ Ð¿Ð¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸Ð½Ð¾Ð³Ð¾ Ð¼ÐµÑÐ¾Ð´Ð° Ð¾ÑÐ¾Ð±ÑÐ°Ð¶ÐµÐ½Ð¸Ñ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿ÑÐ¸ Ð¿Ð¾Ð¼Ð¾ÑÐ¸ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ; - Ð¸Ð·ÑÑÐµÐ½ ÑÐ°ÐºÐ¾Ð¹ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½Ñ Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸, ÐºÐ°Ðº Ð´Ð°ÑÐ±Ð¾ÑÐ´, Ð° ÑÐ°ÐºÐ¶Ðµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½Ñ Ð´Ð»Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð´Ð°ÑÐ±Ð¾ÑÐ´Ð¾Ð² Microsoft Power BI; - ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¸ Ð²Ð½ÐµÐ´ÑÑÐ½ Ð² Ð¾ÑÐ´ÐµÐ» Ð¿ÑÐ¾Ð´Ð°Ð¶ ÑÐ»ÐµÐºÑÑÐ¾ÑÐ¾Ð²Ð°ÑÐ¾Ð² BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð¾ÑÑÐ»ÐµÐ¶Ð¸Ð²Ð°Ð½Ð¸Ñ Ð¿ÑÐ¾Ð´Ð°Ð¶ ÑÐ»ÐµÐºÑÑÐ¾ÑÐ¾Ð²Ð°ÑÐ¾Ð²; - Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ñ ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÐµ ÑÑÑÐµÐºÑÑ Ð¾Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÐºÐ¾Ð½Ð¾Ð¼Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÑÑÐµÐºÑ. ÐÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ°Ñ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾ÑÑÑ ÑÐ°Ð±Ð¾ÑÑ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÑÐµÑÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ°Ð¼Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð´Ð»Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸: ÑÐ½Ð¸Ð¶Ð°ÐµÑÑÑ Ð²ÑÐµÐ¼Ñ Ð½Ð° ÑÐ°Ð±Ð¾ÑÑ Ñ Ð´Ð°Ð½Ð½ÑÐ¼Ð¸, ÑÑÐ¾ ÑÐ½Ð¸Ð¶Ð°ÐµÑ Ð²ÑÐµÐ¼Ñ Ð½Ð° ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¾ÑÑÑÑÐ°, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÐ²ÐµÐ»Ð¸ÑÐ¸Ð²Ð°ÐµÑÑÑ ÑÐ¸ÑÐ»Ð¾ Ð¾ÑÐ¾ÑÐ¼Ð»ÐµÐ½Ð½ÑÑ Ð¾Ð½Ð»Ð°Ð¹Ð½ Ð»Ð¸Ð½Ð¸Ð¹, ÑÑÐ¾ Ð¿ÑÐ¸Ð²Ð¾Ð´Ð¸Ñ Ðº ÑÐ²ÐµÐ»Ð¸ÑÐµÐ½Ð¸Ñ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð° Ð·Ð°ÐºÐ°Ð·Ð¾Ð² Ð¸ ÑÐ¾Ð¾ÑÐ²ÐµÑÑÑÐ²ÐµÐ½Ð½Ð¾ Ðº ÑÐ²ÐµÐ»Ð¸ÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¸Ð±ÑÐ»Ð¸. ÐÑÐ²Ð¾Ð´Ñ. ÐÐ°Ð´Ð°ÑÐ¸ ÐÐÐ  ÑÐµÑÐµÐ½Ñ, ÑÐµÐ»Ñ Ð´Ð¾ÑÑÐ¸Ð³Ð½ÑÑÐ°, Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð° Ð¾Ð±Ð»Ð°ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð².
description: The purpose of the work is to develop and implement a dashboard for analyzing sales data for the analytics department. Tasks of work: - studying objects of research and dashboard technology; - identifying weaknesses in the existing process of providing data for analysis; - development and implementation of an analytical dashboard; - analysis of the effects after the introduction of a new BI application. Work is performed on the basis of materials about the activities of the company "Robert Bosch" LLC. Methods used: comparative analysis, business process modeling, data analysis, infographic tools. Results of work: - after building the As Is model, a weak point in the business process was found, decision to use a different method of displaying analytical data using a BI application; - studied such a visualization tool as a dashboard, as well as a tool for creating dashboards Microsoft Power BI; - developed and implemented in the sales department electrical goods BI applications for sales tracking electrical goods; - substantiated various effects from implementation, as well as the economic effect. The practical significance of the work is determined by the results of using a BI application for the company: the time for working with data is reduced, which reduces the time for creating a report, and the number of online lines issued is also increasing, which leads to an increase in the number of orders and, accordingly, to an increase in profits. Conclusions. The tasks of the WRC have been solved, the goal has been achieved, the scope of the results has been determined.