title: ÐÐ²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ ÑÐ¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð¾ÑÑÑÑÐ½Ð¾ÑÑÐ¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ Ð¸ ÑÐ¾Ð²ÐµÑÑÐµÐ½ÑÑÐ²Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾ÑÐµÑÑÐ° Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÐºÐ¸ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ÑÑÐµÐ´ÑÑÐ²Ð¾Ð¼ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Automation of company reporting and improvement of the process of data analysis through the implementation of a BI-system
Creators: name: ÐÐ°ÑÐºÐµÐ²Ð¸Ñ, Ð¡Ð¾ÑÑÑ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: BI-ÑÐ¸ÑÑÐµÐ¼Ð°
Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð¾ÑÑÑÑÐ½Ð¾ÑÑÐ¸
Ð²ÑÑÑÑÐºÐ°
ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐºÑÐ¸Ð¿ÑÐ¾Ð²
Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ
Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð²
BI-system
reporting automation
revenue
development of scripts
implementation
optimization of processes

description: Ð¦ÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ- ÐÐ²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð¾ÑÑÐµÑÐ½Ð¾ÑÑÐ¸ Ð·Ð° ÑÑÑÑ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ IT Finance. ÐÑÐ»Ð¸ ÑÐµÑÐµÐ½Ñ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð·Ð°Ð´Ð°ÑÐ¸: -Â  ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼ Ð¿ÑÐ¸ ÑÐ¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ð¸ Ð¾ÑÑÑÑÐ¾Ð² Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. -Â  Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿Ð»Ð°Ð½Ð° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ ÐÐ¡. -Â  Ð¡Ð±Ð¾Ñ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð² Tableau. -Â  ÐÐ¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¾ÑÑÐµÑÐ¾Ð² Ð² Tableau. -Â  ÐÐ¾ÑÑÑÐ¾ÐµÐ½Ð¸Ðµ Ð³Ð¸Ð¿Ð¾ÑÐµÐ·, Ð°Ð½Ð°Ð»Ð¸Ð· ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð¾Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ°Ñ Ð·Ð½Ð°ÑÐ¸Ð¼Ð¾ÑÑÑ ÑÐ°Ð±Ð¾ÑÑ Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÑÐµÑÑÑ ÑÐ½Ð¸Ð¶ÐµÐ½Ð¸ÐµÐ¼ Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ Ð·Ð°ÑÑÐ°Ñ Ð½Ð° Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð¸Ðµ Ð¾ÑÑÑÑÐ¾Ð², Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸ÐµÐ¹ Ð½Ð¾Ð²ÑÑ Ð³Ð¸Ð¿Ð¾ÑÐµÐ· Ð¿Ð¾ ÑÐ²ÐµÐ»Ð¸ÑÐµÐ½Ð¸Ñ Ð²ÑÑÑÑÐºÐ¸. Ð¡Ð¸ÑÑÐµÐ¼Ð° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð° Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÑÑÑ Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. ÐÐ¾ Ð´Ð°Ð½Ð½Ð¾Ð¼Ñ Ð¿ÑÐ¾ÐµÐºÑÑ Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð° ÑÑÐ°ÑÑÑ. Ð Ð°Ð±Ð¾ÑÐ° Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð° Ð½Ð° Ð±Ð°Ð·Ðµ Ð¿ÑÐ¾ÐµÐºÑÐ° ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ IT Finance Ð¿Ð¾ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ Ð²ÑÐ¿Ð»Ð°Ñ ÑÐ¸Ð·Ð¸ÑÐµÑÐºÐ¸Ð¼ Ð»Ð¸ÑÐ°Ð¼ Ð¸ ÑÐ°Ð¼Ð¾Ð·Ð°Ð½ÑÑÑÐ¼. ÐÐµÑÐ¾Ð´Ñ: ÑÐ±Ð¾Ñ Ð¸ Ð°Ð½Ð°Ð»Ð¸Ð· Ð´Ð°Ð½Ð½ÑÑ, Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð±Ð¸Ð·Ð½ÐµÑ-Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð², Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¸Ðµ Ð¼ÑÐ»ÑÑÐ¸ÐºÑÐ¸ÑÐµÑÐ¸Ð°Ð»ÑÐ½Ð¾Ð³Ð¾ Ð²Ð·Ð²ÐµÑÐµÐ½Ð½Ð¾Ð³Ð¾ Ð°Ð½Ð°Ð»Ð¸Ð·Ð°, ÑÐ±Ð¾Ñ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹, Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð¸Ðµ ÑÐºÑÐ¸Ð¿ÑÐ¾Ð² Ð½Ð° ÑÐ·ÑÐºÐ°Ñ SQL Ð¸ Python, Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¾ÑÑÑÑÐ¾Ð², Ð¾ÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸. ÐÑÐ½Ð¾Ð²Ð½ÑÐµ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ ÑÐ°Ð±Ð¾ÑÑ: - ÑÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½ Ð¿Ð»Ð°Ð½ Ð¸ ÐºÐ¾Ð¼Ð°Ð½Ð´Ð° Ð¿ÑÐ¾ÐµÐºÑÐ°, ÑÐ¾Ð±ÑÐ°Ð½Ñ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ñ; - Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ñ Ð¸ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ñ ÑÐºÑÐ¸Ð¿ÑÑ Ð¿Ð¾ ÑÐ±Ð¾ÑÑ Ð´Ð°Ð½Ð½ÑÑ;Â  - Ð¿ÑÐ¾Ð¸Ð·Ð²ÐµÐ´ÐµÐ½Ð° Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² Tableau; - ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð²Ð¸Ð·ÑÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¾ÑÑÑÑÐ¾Ð² Ð² Tableau; - Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð° Ð¾ÑÐµÐ½ÐºÐ° ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ Ð¿ÑÐ¾ÐµÐºÑÐ° Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÑÐ²Ð¾Ð´Ñ. ÐÐ°Ð´Ð°ÑÐ¸ ÐÐÐ  ÑÐµÑÐµÐ½Ñ, ÑÐµÐ»Ñ Ð´Ð¾ÑÑÐ¸Ð³Ð½ÑÑÐ°, Ð¾Ð¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð° Ð¾Ð±Ð»Ð°ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð².
description: The purpose of the work is to automate reporting by introducing a BI system in the company IT Finance. Tasks of the work:Â  -Â  Investigation of problems in the preparation of reports in the company. -Â  Development of a plan for the implementation of IS. -Â  Collecting the necessary data and migrating to Tableau. -Â  Visualization of reports in Tableau. -Â  Building hypotheses, analyzing the results from the implementation of the BI system. The practical significance of the work is determined by the reduction in the time of generating reports, the generation of new hypotheses to increase revenue. The work was carried out on the basis of the IT Finance companys project to automate payments to individuals and self-emloyed. Methods: data collection and analysis, business process modeling, multi-criteria weighted analysis, requirements collection, scripting in SQL and Python, report visualization, performance evaluation. The main results of the work: - a plan and a project team have been formed, requirements are drawn up; - written and automated data collection scripts;Â  - data was migrated to Tableau; - visualization of reports in Tableau was developed; - the effectiveness of the BI-system implementation project was assessed. Conclusions. The tasks of the WRC have been solved, the goal has been achieved, the scope of the results has been determined.