Case study: Pharmaceutical Industry

Data-Driven Management: How Qlik Supports Decision-Making Processes for Managers at Aurovitas Pharma Polska

Employees at Aurovitas Pharma Polska relied on several disparate data collection applications, making cyclical reporting a tedious, multi-hour process. This raised a critical question: how to integrate scattered data, process it, and leverage it for analyzing company phenomena?
The solution proved to be the Qlik business intelligence system, which precisely met the company’s business needs.

The Beginning of Collaboration with Hogart and Project Development

Collaboration with Aurovitas Pharma Polska began with the creation of the Qlik application architecture. The tool was designed to fulfill several specific functions:

  • Collect, organize, and merge data from various sources.
  • Clearly present key data and serve as a source of insight into ongoing sales processes within the company.
  • Support managers in the ongoing analysis of sales activities and employee performance evaluations.
  • The project marked the beginning of fundamental changes in data analysis and company management. Over time, a dedicated team of BI experts was formed, which independently implemented and further developed the initial Qlik tool project.

Benefits of Implementing the Qlik Platform

“"From the perspective of someone responsible for preparing applications, analyses, and overseeing database architecture, the biggest change after implementing the Qlik platform is the increased awareness of the power inherent in data. The tool's users – Sales Department Managers – utilize it in all aspects of their work, which significantly streamlines the process of drawing conclusions and making decisions. Convincing Managers that with Qlik, 'the sky is the limit' is the greatest progress compared to the era of static and scattered reports."”

— Marta Jasiewicz-Badowska,,

Commercial Analyses Manager at Aurovitas Pharma Polska

“"The continuous collaboration between our BI department and Managers is also very important; by submitting their ideas, they have a significant impact on the continuous improvement of the tool. It should be emphasized that rapid changes in existing applications, or the construction of new, user-tailored dashboards, would not be possible without the properties of the Qlik platform itself, based on the concept of associative databases."”

— Bartosz Staniów,,

Commercial Analyst

“"Before Qlik Sense, analyzing results was superficial. Previously, I conducted certain analyses my own way. It was a very time-consuming process because I had to search for data in scattered files. Now, everything I need is in one place. I now make my decisions according to the principle of data-driven decision-making. Of course, I also consider other factors, but I believe that numbers never lie and are, in fact, the most crucial element in the decision-making process. Thanks to Qlik, I can make optimal decisions."”

— Magdalena Czekalska,,

Sales Area Manager at Aurovitas Pharma Polska

“"The Qlik Sense program is intuitive and helpful; it 'does the work for us.' For example, when I previously wanted to use certain data and present it in a chart, I had to perform more operations, thus dedicating more time to that task. Thanks to Qlik technology, I can use the generated data to see exactly what is happening in my group in a given area. (…) Data helps me answer key questions, such as: How to improve customer satisfaction and relationships? How to increase sales? Data also leads to insights that I can transform into decisions and actions to improve the group's operations."”

— Dorota Mikołajczak,,

Sales Area Manager at Aurovitas Pharma Polska

Benefits of Implementing the Qlik Tool

Benefits of implementing the Qlik tool – statements from Sales Department Managers at Aurovitas Pharma Polska:

Data-Driven Company

  • Reduced time for preparing cyclical reports, e.g., sales target achievement reports, from 3 days to 5 hours.
  • Transition from exploration to prediction – we can forecast and simulate the future.
  • Competitive advantage – faster and more effective utilization of information transformed into knowledge.
  • Dynamic adaptation.
  • Transparency in decision-making.
  • Integration of dispersed data into one central application and several satellite applications.
  • Faster acquisition of insights from data, thanks to clear and transparent visualizations.

Data-Driven Management

  • Data access on “Qlik.”
  • Fact-based communication.
  • A tool in the process of motivating and rewarding employees.
  • Reduced reaction time to business events.
  • Ability to analyze multiple paths, discovering new cause-and-effect relationships.
  • Precise vision for future actions.

Data-Driven Medical Representative

  • Thoughtful strategy preparation.
  • Development through knowledge management.
  • Precise and realistic goals.
  • Deeper understanding of the territory.