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

Edit This Case Study Record

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

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

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Healthcare & Hospitals Pharmaceuticals
Applicable Functions	Product Research & Development Sales & Marketing
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Healthcare & Hospitals

Pharmaceuticals

Applicable Functions

Product Research & Development

Sales & Marketing

Services

Data Science Services

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.

About 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.

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.

Impact #1	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.
Impact #2	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.
Impact #3	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.

Impact #1

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.

Impact #2

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.

Impact #3

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.

Benefit #1	Inside Info delivered an end-to-end solution in just 12 days.
Benefit #2	Saved customers days to weeks of work in drawing insight from the research.

Benefit #1

Inside Info delivered an end-to-end solution in just 12 days.

Benefit #2

Saved customers days to weeks of work in drawing insight from the research.

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit