Qlik > 实例探究 > 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
地区
  • Pacific
国家
  • Australia
产品
  • QlikView
  • AsteRx
技术栈
  • SQL Database
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Customer Satisfaction
技术
  • 分析与建模 - 实时分析
适用行业
  • 医疗保健和医院
  • 药品
适用功能
  • 产品研发
  • 销售与市场营销
服务
  • 数据科学服务
关于客户
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.
挑战
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.
解决方案
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.
  • With QlikView AsteRx can now merge data sources traditionally viewed in isolation. Data volume, format and structure restrictions are irrelevant in QlikView.
数量效益
  • 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

相关案例.

联系我们

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

感谢您的信息!
我们会很快与你取得联系。