Project for Sotex «PharmFirm»
Data import automation, secondary sales analysis
Task
Consolidate and analyse the data on distributors' sales
Closing date
November 2012
Project goals
Speed up the import and cleansing of secondary sales data
Ensure timely analysis of the gathered data
Analyse the secondary sales up to the final salespoint
Increase the level of detail of the reports
Reduce the time required to process regular reports
Promptly analyse the stocks for various products
Consolidate the sales data from the distributors' reports
Project features
Automated processes of secondary sales data import, cleansing and normalization
The support of reports in any format
The automatic cross-check of postal address lines with KLADR (the official Russian state address database)