Shatura, furniture company (Microsoft Business Intelligence)

Problem

Large volumes of information on sales did not give the chance to see what really happens in the company.

• control and information analysis was labor-consuming and required time costs;
• there was a need for new instruments of monitoring and the analysis that would help to improve sales processes;
• the companies were necessary modern visualization tools of data;
• because of the inefficient mechanism of drawing up reports workers of the IT sphere had to be engaged in this work instead of accomplishment of more important administration tasks;
• insufficient automation of accounting and information processing led to untimely decision making and, as a result, decrease in profitability.

Task

• carrying out methodical accounting and control of movements and remaining balance of materials;
• introduction of modern powerful tools of data visualization (diagrams, charts, etc.);
• automation of drawing up report forms.

Choosing a Solution

For comprehensive accounting and information processing the decision on system implementation of the analysis and monitoring by means of basic technologies of Microsoft Business Intelligence was made on sales of BI-Expert by IT specialists. This model helped to be focused on the major indicators, to predict different situations of business development, to keep track of results of acceptance of management decisions that in general increased efficiency of sales and gave advantage over competitors.

Result

• The model of monitoring and the analysis in the field of sales using basic technologies of MSBI is constructed;
• interactive forms for work of end users in Excel MS are made;
• monitoring panels are developed for sharing on the website of the organization;
• the data integration mechanism is developed.

As a result all data are provided in an available visual form (using diagrams, tables, charts) in different cuts of analytics. The company had an opportunity in real time to trace necessary information that made its activity more effective. Final information became possible to be analyzed and detailed on the corporate website of the company. Information chaos was as a result liquidated and the search mechanism of the necessary information in the system of reports is simplified.