Qlik > Case Studies > Better physician & patient profiling allows AsteRx & QlikView to break new ground in identifying health trends

Better physician & patient profiling allows AsteRx & QlikView to break new ground in identifying health trends

Qlik Logo
Region
  • Pacific
Country
  • Australia
Product
  • QlikView
  • AsteRx
Tech Stack
  • SQL Database
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Healthcare & Hospitals
  • Pharmaceuticals
Applicable Functions
  • Product Research & Development
  • Sales & Marketing
Services
  • Data Science Services
About The Customer
AsteRx is a leading provider of data research services to the Australian healthcare and pharmaceutical industry. Looking to expand its customer reach beyond research and analytical teams, AsteRx teamed with Inside Info to create a new online clinical market research value proposition to help the company target new users. AsteRx collects anonymous prescribing statistics from a representative national sample of GPs with an enabling direct link to scriptwriting software. While maintaining anonymity and complying with privacy principles, AsteRx with QlikView can now make use of this information in a more meaningful way, providing extremely useful prescribing statistical information to pharmaceutical companies, refreshed daily.
The Challenge
Pharmaceutical companies are under increasing pressure to stand out from the crowd in an industry facing pricing pressures, promotional saturation, regulatory scrutiny, reduced product differentiation and increased customer and channel complexity. The healthcare market faces the dual paradox of being awash in data but often lacking in insight. Some of these companies are finding the means to pull ahead of the pack through leveraging analytics in broader and dramatically more effective ways. They are creating the organisational capability to develop and execute against differentiated insights. AsteRx was dealing with large data volumes, comprising millions of scripts from a national sample of hundreds of physicians to be analysed in a myriad of ways that would take weeks to manipulate for a single result. Customers were provided with raw research data, usually in Access or CSV format, making it difficult from which to draw insight. Furthermore, data contained lots of hierarchies, continually changing data frequency with varying levels of data aggregation. Multiple data sources also needed to be integrated with different formats, languages and data structures.
The Solution
Inside Info worked with AsteRx, using QlikView to create a zero footprint web –based application where customers can easily access and interactively analyse a personalised view of market research data. With this, AsteRx now provides the missing link between Australian physicians, products being prescribed, to what segment and the pharmaceutical companies that own the products, who will use this information in maximising sales growth with resource efficiency. QlikView’s section access controls the data each user sees based on their AsteRx subscription. Upgrading a user’s subscription level is as simple as changing their section access. One online data model was built to extract, transform and load AsteRx’s large data volumes from an SQL database transferring into QlikView’s in-memory, patented analytical engine for sub second point and click response times to analysis selections.
Operational Impact
  • Through the launch of a new online market research subscription service based on QlikView, Inside Info has helped AsteRx open up new target markets outside of traditional insight and analytical teams, while also turning a cumbersome process into a new value proposition for its clients.
  • This includes an expanded breadth of analysis by adding contextual data to study results, while also delivering self-serve, actionable insight over the web with intuitive free-form drill down of large data sets, simple enough for anyone to use.
  • AsteRx has a stringent process around data collection and privacy, and using QlikView any data gaps are easily identified and addressed based on their level of importance.
  • With QlikView AsteRx can now merge data sources traditionally viewed in isolation. Data volume, format and structure restrictions are irrelevant in QlikView.
Quantitative Benefit
  • Inside Info delivered an end-to-end solution in just 12 days.
  • Saved customers days to weeks of work in drawing insight from the research.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.