Business Analysis in Pharmaceutical Companies

NaviCon Group Company has developed a solution for the automation of business-analysis and preparation of management reports for pharmaceutical companies. This solution is based on Microsoft SQL Server and Microsoft Office SharePoint Server platforms. This solution takes into account the specific of pharmaceutical companies operating on the Russian market:

• wide geographical distribution;
• foreign head-office or departments abroad;
• large number of remote users, such as regional sales managers and medical representatives;
• complex organizational structure;
• specifics in operating with CRM-system, with doctor databases.

This solution can be used by any user group in a pharmaceutical company. The top-managers get the aggregated reports about the key business indicators (e.g. efficiency, profitability, production and sales volume, etc.). For business analytics this solution creates multidimensional cubes and provides the technology to create reports upon request. Line managers use the predefined reports that provide details of the departments’ performance.

The NaviCon Group solution is oriented to work with the large amounts of data sources, to use web-technologies and to serve the large amount of users with various access rights (1 – 1.5 thousands of users). This is a scalable and easy to maintain solution. It solves the frequent tasks of business analysis in the pharmaceutical area:

• sales analysis per medical products, medical specialization and regions;
• cost analysis per business divisions, regional structure, medical products;
• efficiency analysis of medical representatives includes visit reports, and the reports of visit expenses per medical products and specializations; as well as the analysis of the working time structure for a medical representative;
• financial analysis including income, efficiency, and deviations of actual values and the company budget, etc.

Those pharmaceutical companies that implement the NaviCon Group solutions for business analysis get the following benefits:

• single data storage to aggregate the key data from various external sources;
• quick access to the needed data independently on the user location;
• user-friendly analysis and reporting interface;
• short implementation time;
• wide possibilities for future system development.

The end users get a convenient basic form to start the necessary reports. The user role and his access rights to various data and analytical dimensions are accounted for as well.