In 2014, at BSH, performance of the analytics system sharply decreased (this system allows monitoring of sales of production and availability of stocks). In particular, over 4 months, the cycle of preparing daily reports almost doubled – from 8 to 14 hours. A long calculation was beyond the allocated service window, and there was a risk of losing actual administrative information. iCore offered an optimum solution of how to fix this problem.
|Solutions||IT for Business|
Specialists at iCore carried out an audit of the BI system and DBMS. Our experts studied original tables and data provided to users, and also mechanisms to generate and send queries to the storage. The following “bottlenecks” were detected:
The “diagnosis” allowed development of an optimum solution: switching to the “star” scheme and build queries directly on the Microsoft SQL Server. Role based data distribution also allowed performing a logical action: generating an OLAP-cube per user group.
Thanks to optimization of the DBMS and BI system, the time for generating daily reports was reduced from 14 hours to 10 minutes. Analytics information is prepared in less than half an hour. All problems are solved on the basis of previously implemented IT systems. No extra investments in the purchase of new equipment was needed.