Navicon BI FMCG

The Navicon system integrator developed industry analytical model for the companies which are engaged in production and distribution of products and convenience goods (FMCG). The model represents the ready-made solution on the basis of Best practices and indicators for analytics, and can be quickly implemented in any company of the Russian segment of FMCG.

Creation of BI model is caused by promptly changing requirements of the FMCG companies around the world. The behavior of buyers is transformed: more and more sales are performed on online channels that requires new approaches to marketing and communication with the consumer. The model developed by Navicon allows to analyze all channels of involvement of buyers and their influence on sales and also to quickly estimate results of work of distributors and retail chain stores.

The industry model is intended for adoption of the weighed solutions at all levels of management of the company: from top managers to a field command. Moreover, to analytical data it is possible to provide access to distributors of the organization – thus, increasing transparency of the relations of the producer with partners.

The BI model is created based on hybrid Microsoft SQL Server platform 2016. It allows to involve the mechanisms of the tabulyarny SQL Server model accelerating unloading of the management decisions given for scratchpad acceptance. A set of means Microsoft Power BI allowing to create interactive reports and to carry out information analysis which is updated daily became an analytical core and means of visualization of model. The Navicon command developed the analytical dashborda displaying analysis results of FMCG of indicators, important for sector, online.

The solution can be deployed both in the customer's infrastructure, and in Microsoft Azure cloud. Thus, FMCG manufacturing can optimize the cost of ownership of the solution and save themselves from essential investments in purchase and support of the equipment of IT infrastructure.