ATK QlikView for Pharma

The solution of ATC QlikView for Pharma is developed by ATK consulting group for the business analysis and creation of the managerial reporting in the pharmaceutical companies and completely considers specifics of pharmaceutical business:

• Work in the highly competitive environment;
• Large number of remote users (for example, medical representatives, area sales managers, etc.);
• Organization effective works with CRM/SFA, databases of doctors;
• Need of carrying out multiple factor analysis of versatile data, including:
  • Data of shipments of medicines to distributors;
  • Multilevel data on sales of distributors;
  • Data of retail audit;
  • Data on work of medical representatives;
  • Data of poll of doctors and pharmacists;
  • Data of financial accounting;
  • Data on attendance of the websites.

The solution of ATC QlikView for Pharma is intended for all core groups of users of the pharmaceutical company:

• Company management and business divisions;
• Department of sales;
• Department of marketing;
• Department of a business intelligence;
• Finance department.

The solution of ATC QlikView for Pharma – the innovation, web oriyentikrovan-naya the platform intended for the analysis of the consolidated business information from a large number of sources. Effective scaling and a podkderzhka of the solution, differentiation of access rights up to a table field.

Analysis of sales

• The combined analysis of trends of shipments to distributors, sales of distributors and a remaining balance in warehouses of distributors;
• The analysis of accomplishment of the plan of shipments and the sales plan in money and the number of packagings;
• The ratings of distribution of sales by distributors, regions, medicines, divisions;
• Turnover analysis and average speed of sales of medicines;
• Absolute and relative measures of sales growth for each region, medicine, the distributor, division;
• The analysis of sales pattern on a brand by a dosage form, a dosage, etc.

Retail Audit

• The preconfigured reports on comparison of competitive medicines, with a possibility of flexible change of parameters of determination of the konkurentkny environment;
• Dynamics of ratings concerning pharmaceutical market on this competitive environment (the ratings of producers in the region; the ratings of regions on medicine or group of medicines; the ratings of medicines in the region);
• Market share by medicines, pharmacological group, regions;
• Evolution Index: growth in relation to the market.

CRM/SFA

• Quantity, frequency and multiplicity of visit of doctors and pharmacists by focal group;
• Scope of doctors of focal group;
• Coefficient of accomplishment of the plan of visits;
• Calculation of complex KPI of representatives on the basis of these visits of a focal grupkkpa, dynamics of sales, accomplishment of the sales plan a podrazkdeleniye, dynamics and market shares in the specific region by medicine;
• Efficiency analysis of activity of representatives together with polls of doctors and pharmacists about quality of work of representatives (MEDI-Q™, PHARMA-Q™, Prescription Index™)
• Cost efficiency on visits by medicines, regions, pharmacological groups

Finance

• Balance;
• Profit and loss statement;
• Cash flow;
• Debt of partners;
• Dynamics of assets and liabilities;
• Expense dynamics on marketing activities by medicines, divisions, the plan and the fact on the budget.

The wide geography of distribution, the need for the effective organization of work with CRM/SFA, databases of doctors, need of regular multiple factor analysis of activity of the company, need of access to analytical data of a large number of remote users – all these features are considered in the solution ATK QlikView for Pharma which helps already tens of the companies to strengthen and expand the positions in the highly competitive pharmaceutical market of Russia.

The solution of ATC QlikView for Pharma is intended for all core groups of users of the pharmaceutical company. As a rule, the application is used by company management and business divisions and also deparament of sales, marketing, a business intelligence and finance.

ATK QlikView for Pharma helps to solve problems, critical for pharmaceutical business, – the analysis of sales, retail audit, management of finance, increase in efficiency with CRM/SFA, tracking of attendance of the websites.

So, for example, the consolidated data on sales to the company can be analyzed together with the data of retail audit delivered by the research agencies IMS, Pharmexpert, DSM, etc. The solution ATK QlikView for Pharma allows to receive the preconfigured reports on comparison of competitive medicines, with a possibility of flexible change of parameters of determination of competitive environment; to the loudspeaker of ratings concerning pharmaceutical market on this competitive environment (the ratings of producers in the region; the ratings of regions on medicine or group of medicines; the ratings of medicines in the region).