下载PDF
Qlik > 实例探究 > Better physician & patient profiling allows AsteRx & QlikView to break new ground in identifying health trends
Qlik Logo

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

技术
  • 分析与建模 - 实时分析
适用行业
  • 医疗保健和医院
  • 药品
适用功能
  • 产品研发
  • 销售与市场营销
服务
  • 数据科学服务
挑战
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.
关于客户
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.
解决方案
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.
运营影响
  • 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.
数量效益
  • 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.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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