Project for Bayer
Implementation of a secondary sales processing system in 14 days
Task
An easy and convenient system to process secondary sales data
Solution
Timing
2 weeks
Project goals
Reduce the time spent on consolidating, processing and cleansing the data coming from distributors and pharmacy chains
Check the accuracy of the data provided by pharmacy chains
Analyse the secondary sales point-by-point
Assess medical representatives' efficiency
Track the stock balance at distributors' warehouses
Analyse the data by regional branches
Compare regional plans with actual sales
Keep obtaining up-to-date information on secondary sales
Project features
The use of Microsoft SQL Server MDS (Master Data Services) to manage reference data
Consolidating the data from distributors' reports with the CRM data
The use of Pyramid Analytics system for data visualisation
Record timing (2 weeks)
Flexible possibilities for solution scaling