Navicon FMCG TDC (Trade Data Consolidation)

Navicon FMCG TDC (Trade Data Consolidation) will accelerate loading and data scrubbing on secondary sales, purchases and stock balance.

2020

Availability from Microsoft Azure

The system integrator and Navicon developer transferred the analytical solution for the FMCG companies to a cloud platform of Microsoft Azure. It became known on June 3, 2020. Now clients of the company will be able to reduce costs for local IT infrastructure and also to use by preparation of analytical reports of a possibility of Azure Data Platform services, including tools for work with AI and Big Data.

The solution Navicon FMCG BI is designed to help the companies to simplify efficiency evaluation of the work including directed to promotion of products. A system allows to analyze all chain of sales, activity and efficiency of field personnel, to control accomplishment by partners of contractual terms and provision of products in a competitive environment and also to calculate its cost value to the level of specific SKU. Clients of Navicon use FMCG BI including for bonus calculation trade of representatives, control of receivables, building P&L structures and for many other tasks. The solution can work with data from CRM ERP, CLM and other systems which are earlier implemented in the company and also with different databases.

Thanks to transfer of Navicon FMCG BI in Microsoft Azure cloud clients of the system integrator had additional opportunities:

• use the services of advanced analytics including allowing to work with Big Data;
• reduce costs for local infrastructure;
• receive reports and insights worldwide from any device;
• if necessary quickly to scale resources of the cloud storage and, respectively, computing opportunities of Azure Data Platform.

Now the companies can select the solution deployment option which is most suitable for them from offered by the system integrator:

1. Deployment of Navicon FMCG BI on local servers of the FMCG companies. Those at whom enough own computing powers or whose security policy does not provide placement of data in a cloud can select such method.

2. Hybrid scenario. It will suit those who would like to store the data in local infrastructure and at the same time to use the innovation tools for their analysis, available in Microsoft Azure cloud.

3. Cloud scenario. Will be suitable for a broad spectrum of the companies for which possibilities of the additional Azure Data Platform tools – services of analytics of Big Data and AI are necessary. Besides, the companies who only begins to develop own BI competences will be able to reduce the experiment price, having begun with small capacities without capital costs.

During the increased uncertainty for the FMCG companies it is important to make quickly the management decisions based on the checked facts. However information necessary for the analysis is often stored in the different systems, and manual monitoring becomes almost impossible. Technologies of Microsoft based on which our solution Navicon FMCG BI is constructed allow to work with data from different sources, different degree of readiness and structure. Experience of Navicon regarding FMCG analytics allows to offer clients ready analytical mechanisms, structures and sets of reports. And thanks to integration of a system with Microsoft Azure cloud our clients can use tools of advanced analytics now: they, for example, easily cope with the analysis of large volumes of unstructured data,

Microsoft stimulates creation of the partner solutions giving competitive advantages to the companies of the different industries. Now the analytical solution for FMCG can be deployed, using cloud and hybrid scenarios that will give the chance to clients of Navicon to take all advantage of a cloud consumption pattern of IT, for example, availability of the solution worldwide from any device. Placement of Navicon FMCG BI in Azure cloud – extremely important step for integrator: it will simplify the companies an exit to international markets, emphasized Alexander Belenky, the director of the department of work with the average and small organizations and Microsoft partners in Russia.

Availability in Yandex. Cloud

On May 19, 2020 it became known that Navicon developer and Yandex company. A cloud signed the partnership agreement. Based on the Yandex platform. The cloud of Navicon will offer clients infrastructure and platform services for storage and data processing, technology for speech recognition and the analysis of images using machine learning and also own solutions for pharmaceutical and the FMCG industries. Read more here.

Possibilities of Navicon FMCG TDC

As of May, 2020 Navicon FMCG TDC provides such opportunities as:

• Consolidation of all data on secondary sales, purchases and stock balance: Navicon FMCG TDC provides automatic loading of information on secondary sales, purchases and stock balance and also sorting and correlation of the addresses of outlets with an accuracy of 95%.
• Data analysis about sales, purchases and stock balance: Navicon FMCG TDC provides the analysis of all information on sales, purchases and stock balance.
• Forecasting and creation of the production plan: Data retrieveds about sales will allow the FMCG company to make the realistic output plan "from below-up".
• Integration with TPM and CRM: Thanks to integration with CRM and TPM, the field personnel receive online and offline - data access about accomplishment trade marketing of agreements by networks in real time.

2014

The large supplier of pharmaceutical medicines, as well as most drug manufacturers, sells products mainly through distributor network. And distributors work with different types of buyers: pharmacy chains, medical institutions, small wholesale partners. Each distributor sends sales statements in own format therefore information processing takes away a lot of time and forces. The company management decided to automate consolidation given from the account sent by distributors. The company addressed Navicon IT integrator which suggested to use the solution SalesOut.

2013

Navicon Sales-Out в Windows Azure

The Navicon company placed in the spring of 2013 the solution developed for the pharmaceutical industry in Windows Azure — a cloud platform of Microsoft. It will make it available to clients worldwide (irrespective of geographic location of the company) and significantly optimizes expenses of clients on use of a system. The Windows platform of Azure will provide flexibility in use and high degree of protection of corporate data.

The solution Navicon Sales-Out helps to solve one of the most relevant tasks of the pharmaceutical companies – formation of the summary report on sales. The summary report forms based on reports of certain distributors which are provided in different formats, have different structure, etc. The solution allows to lead these data to a uniform format, to consolidate them and to analyze. Navicon Sales-Out is successfully approved and works in such large companies as Novartis and "Soteks".

Windows Azure is a public cloud platform of Microsoft. It helps to cut down significantly expenses on IT services, to look in a new way at all process of automation of activity of the companies and creation of the software, to refuse high initial costs on infrastructure and its subsequent maintenance and also to solve problems of fast deployment of applications, entry into the new markets, expansions of the customer base, the number of customers, etc.

Among advantages which are got by the customer the main are:

• availability of the solution for the companies, irrespective of a geographical location;
• cost optimization on acquisition and support of servers;
• cost reduction on personnel which perform support of IT infrastructure;
• cost optimization on scaling of the solution which if necessary will perform Microsoft;
• cutting of costs for purchase and development of the software product as all updates which are entered to the solution become available to all customers at once. At the same time the companies can order separate completions personally for the needs.

The cloud service supports double-sided export of data: if the customer made the decision to refuse use of SaaS model, its data can be easily transferred to own servers.

Features of Navicon Sales-Out

Direction of use Navicon Sales-Out

• Large trade or, the trade production company selling products through distributor network
• The FMCG producer with a wide branch network delivering products to wholesalers and large retail networks

Features of work of the customer

• The analysis of dynamics and demand pattern on products at end consumers
• Efficiency analysis of advertizing campaigns
• Sales planning and purchases
• Customer service quality improvement
• Optimization of logistics (prevention of overstocking of warehouses)
• Assortment management
• Efficiency analysis of sales channels (by distributors or branches)

Advantages

• Possibility of import/export of data in any format.
• Automation of internal routing (mepping) of data.
• Automatic reduction of data to a uniform format.
• Functionality of support of master data.
• Risk minimization of an error when importing data.

For sales department

The plan fact for sales by:

• sellers
• distributors and financial structure
• commodity nomenclature and regional structure

For marketing department

Actual data on sales by:

• time frames,
• separate goods and commodity groups,
• regions

Specific Features

• Reliable industrial Microsoft platform
• Possibility of rapid implementation (1-2 months)
• Simplicity and convenience of administration
• The flexible configured functionality of import / export of data
• Functionality of automatic comparison of data
• Functionality of rollback of data
• The flexible tool for comparison of data manually.
• Automatic archiving of initial data and protocol of transactions.

In Navicon Sales-Out the functionality of three modules Microsoft SQL Server is used:

• Master Data Services – for storage and management of the normative reference information,
• Integration Services – for data loading from reports of distributors,
• Server Reporting Services - for preparation of interactive and printing reports.

The unique system module of SalesOut "ties" the addresses of outlets to the all-Russian qualifier of the addresses (KLADR). It is the unified official register, the tax inspection uses it, for example. The "dirty" data which arrived from the distributor automatically are compared to the register and codified according to reference base.