QlikView at Pharmstandard: Advanced analytics for 1'000+ users
ATK
QlikView
QlikView in "Pharmstandard"
.png)
Company:
"Pharmstandard"
Industry:
Pharmaceuticals
Functional areas:
Sales analysis
Secondary sales analysis
Product:
QlikView
Analysis of finances
Commodity flow analysis
Marketing analysis
About the client company:
Pharmstandard LLC is a leading pharmaceutical company in Russia engaged in the development and production of modern, high-quality, affordable medicines that meet healthcare requirements and patient expectations.
Pharmstandard Group produces pharmaceuticals of various pharmacotherapeutic groups, including drugs for the treatment of cardiovascular diseases, diabetes, growth hormone deficiency, gastroenterological, neurological, infectious diseases, metabolic disorders, oncological and other diseases.
Project Objective:
-
building a single advanced analytical system
-
Reduction of costs for creating analytical reports
-
Increased efficiency and quality of work with analytics
Solution:
The system is already used by more than 1'000 users - company executives, analysts, marketing specialists, CRM specialists, sales managers, medical representatives and regional managers.
The QlikView implementation project was carried out in 2 stages.
The first stage of QlikView implementation was a pilot, on the basis of which a decision was made to implement QlikView on a company-wide basis. Within the framework of the project ATK Consulting Group developed a basic set of analytical reporting for the pharmaceutical company:
-
Plan-fact analysis on primary and secondary sales and distributor warehouse balances,
-
Dashboard with key sales indicators,
-
Analytical showcase on sales and balances for flexible work of analysts.
The first stage was completed very quickly - the solution development was finished in 10 days, as the only source of data for the project tasks was the ERP system. Then we conducted a trial run and checked the correctness of the data in the new solution.
At the second stage of the project, we created analytics for one of the most mass categories of the company's employees - medical and regional representatives, as well as enhanced the capabilities of advanced analytics:
-
Impact of medical representative activity on retail sales and performance analysis,
-
Assessment of risks and potential of future sales by territory (RFM-analytics),
-
Analysis of sales shares by competitive environment (based on IMS analytical research).
-
Key results of implementation of QlikView BI-system
-
Ability to more quickly analyze activities in rapidly changing market conditions,
-
Ability to analyze new KPIs, the calculation of which was previously technically impossible (for example, smoothed quantitative distribution),
-
Regional employees have prompt access to complete information about the company's activities and the market situation,
-
Increased efficiency and flexibility of planning.
-
Independent development of analytical reports. After the training course, employees started to develop reports independently and took over further support and development of existing QlikView solutions.
Data Sources:
-
ERP-system of own development
-
ETMS - in-house developed system
-
Analytical study of IMS
-
Excel files
Results in numbers:
automated workstations
1016
working day per year - freeing up analysts' time
141
Results in numbers:
-
1016 automated workplaces, including 740 active users who use analytics in Qlik at least once a week (as of the beginning of 2015, the number of active users is growing)
-
Payback period of QlikView implementation project - 8 months
-
At the end of the project, the release of analysts' time - 141 working days per year
-
QlikView combines data on 64,000 retail outlets (pharmacies and healthcare centers) and 340 products. At the same time, an average representative's portfolio for analytics includes 10-30 products and 1,000 retail outlets.
Screenshots of the solution:
Testimonial:
With QlikView, we have changed the concept of providing analytics to our employees - from disparate reports and Excel "webs" we have moved to a flexible system in which you can get any analytics you are interested in and decide on tactics to improve performance. Now our regional managers and medical representatives of the company at any time receive full information about the market situation in terms of pharmacies and hospitals, and can more effectively plan marketing activities for drugs. In addition, after the training course, our employees independently started to develop reports and took over further support and development of existing QlikView solutions"
Head of Analysis and Planning Department, Pharmstandard LLC.
EKATERINA IGNATOVA
Other industry projects
QlikView in "Pharmstandard"
QlikView in "Pharmstandard"
QlikView in "Pharmstandard"
QlikView in "Pharmstandard"
+7 (495) 134-32-92
consult@atkcg.ru
Russia, 121467, Moscow,
Istrinskaya str. 4, Office 1
Company News
subscribe to our newsletter
