Project for R-Pharm

Data warehouse and BI implementation

Integrate several internal and external data sources in order to provide the commercial and financial departments with consolidated reporting
9 months

Project goals

The analysis of the pharmaceutical sales' efficiency
Consolidated reports for the commercial, accounting, economics, and financial departments
The comparison of the internal and external data sources
The analysis of the company performance in the market

Project features

Turnkey connector/data warehouse structure for pharmaceutical companies
The integration of more than 7 different data sources (MS Axapta, MS Access, CRM, Excel files, TXT files)
The combined use of Microsoft BI and QlikView technologies according to a specific task


Consolidated reporting, convenient tools to analyse the company's sales efficiency and market performance, rapid strategic adjustability
Results in figures


times faster reporting
Results in figures




«The BI implementation project continued R-Pharm cooperation with Navicon, the systems integrator that deeply understands the pharmaceutical specificity, knows the internal processes or our company, and offers a number of industry-specific solutions. All of this was of huge importance to us. The implementation of data warehouse and BI systems provided our company with the rapid reporting for different departments, real-time information on the main performance figures, faster and better decision-making. It's already possible to say that the new system saves R-Pharm a lot of effort and significantly increases our competitive ability. We are grateful to Navicon for the successful cooperation, and we hope to develop it further».
Fedor Karpov, Head of Sales Effectiveness Department at R-Pharm

Other sector projects

Sotex «PharmFirm»
Data import automation, secondary sales analysis
Navicon Pharma TDC: automated management of secondary sales
Advanced budgeting capabilities for the pharmaceutical industry
CRM-based automation of pharmaceutical field force
Petrovax Pharm
Implementation of Navicon Pharma CRM: the industry-specific CRM solution
Implementation of a secondary sales processing system in 14 days
CRM-based management of medical representatives
Merz Pharma
The consolidation and analysis of the Russian branch's distribution network data by Navicon TDC
BI-based comprehensive analysis of the company activities
Field sales monitoring
Full-scale automation of corporate activities
EVER Pharma
An ERP solution rollout based on Microsoft Dynamics AX