title: ÐÐ²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ ÑÐ°ÑÑÐµÑÐ° Ð±Ð¸Ð·Ð½ÐµÑ - Ð¿Ð¾ÐºÐ°Ð·Ð°ÑÐµÐ»ÐµÐ¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ QlikView
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Automate the calculation of business performance of the company using QlikView
Creators: name: ÐÑÑÐ»ÑÑÐ¾Ð²Ð°, ÐÐ°ÑÐ°Ð»ÑÑ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2019
Subjects: Ð°Ð½Ð°Ð»Ð¸Ð· Ð¾Ð±ÑÐµÐ¼Ð¾Ð² ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸
BI
Ñ ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐµ Ð´Ð°Ð½Ð½ÑÑ
QlikView
Postgresql
fnalysis of sales
data warehouse

description: ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ñ, Ð·Ð°Ð½Ð¸Ð¼Ð°ÑÑÐ°ÑÑÑ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð¾Ð¼ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸ÐµÐ¹ Ð±Ð¸ÑÑÐ¼Ð½Ð¾Ð¹ Ð¿ÑÐ¾Ð´ÑÐºÑÐ¸Ð¸.
Ð¦ÐµÐ»ÑÑ Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ, ÐºÐ¾ÑÐ¾ÑÐ¾Ðµ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸ÑÐµÑÐºÐ¸ Ð²ÑÑÐ¸ÑÐ»ÑÐµÑ Ð¾Ð±ÑÐµÐ¼Ñ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ Ð¼Ð°ÑÐ¶Ñ, Ð° Ð·Ð°ÑÐµÐ¼ ÑÐ¾ÑÐ¼Ð¸ÑÑÐµÑ Ð¾ÑÑÐµÑÑ. 
ÐÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°ÑÐ´Ð¸Ñ Ð±Ð¸Ð·Ð½ÐµÑ-Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸, Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ ÐºÐ¾ÑÐ¾ÑÐ¾Ð³Ð¾ Ð²ÑÑÐ²Ð»ÐµÐ½Ð° Ð¿Ð¾ÑÑÐµÐ±Ð½Ð¾ÑÑÑ Ð²Ð¾ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ð¸ ÑÐ¸ÑÑÐµÐ¼Ñ Ð±Ð¸Ð·Ð½ÐµÑ-Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð¸ ÑÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ñ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½ÑÐµ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ñ Ðº BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ. 
ÐÐ»Ñ Ð²ÑÐ±Ð¾ÑÐ° BI-Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ñ Ð±ÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· Ð»Ð¸Ð´ÐµÑÐ¾Ð² ÑÑÐ½ÐºÐ° BI-Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼ Ð¸ Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½ Ð²ÑÐ±Ð¾Ñ Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ñ QlikView.
ÐÑÐ»Ð° ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° ÑÐµÐ»ÐµÐ²Ð°Ñ IT-Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÐ° Ð´Ð»Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð² ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ñ. 
ÐÑÐ¾Ð¸Ð·Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐµÐ¹ Ð¸Ð¼ÐµÑÑÐµÐ³Ð¾ÑÑ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ, Ð²ÑÑÑÐ¾ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð² QlikView Ð¸ Ð²Ð½ÐµÑÐ½ÐµÐ³Ð¾ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð¡Ð£ÐÐ, Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ ÐºÐ¾ÑÐ¾ÑÐ¾Ð³Ð¾ Ð±ÑÐ» ÑÐ´ÐµÐ»Ð°Ð½ Ð²ÑÐ²Ð¾Ð´ Ð¾ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÐ¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Ð²Ð½ÐµÑÐ½ÐµÐ³Ð¾ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ°.
ÐÑÐ» ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ, ÐºÐ¾ÑÐ¾ÑÑÐ¹ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸Ñ Ð²ÑÑÐ¸ÑÐ»ÐµÐ½Ð¸Ðµ Ð¼Ð°ÑÐ¶Ð¸ Ð¸ Ð¾Ð±ÑÐµÐ¼Ð¾Ð² ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ ÑÐ¾ÑÐ¼Ð¸ÑÑÐµÑ Ð¾ÑÑÐµÑÐ½ÑÐµ ÑÐ¾ÑÐ¼Ñ.
ÐÑÐµÐ½ÐµÐ½Ñ ÑÐºÐ¾Ð½Ð¾Ð¼Ð¸ÑÐµÑÐºÐ¸Ðµ ÑÑÑÐµÐºÑÑ Ð¾Ñ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ñ BI-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹.
description: The object of the research is a company engaged in the production and sale of bitumen products.
The purpose of the final qualifying work is to create a prototype of an analytical application that automatically calculates sales, margins and then generates reports.
An audit of the company's business processes was conducted, which showed the need to implement a business analysis system, after it the functional requirements for a BI application were formed.
For selection a BI platform, an analysis of the BI platform market leaders was conducted and the selection of the QlikView platform was justified.
A target IT architecture was developed for introducing a BI application into the company.
A comparison was made of the capabilities of the existing data warehouse built into QlikView and the external data storage on the DBMS, which showed the need to use external storage.
A prototype of a BI application was developed. It calculates margins and sales and generates reporting forms.
Estimated economic effects from the introduction of BI-applications into the company.