Better physician & patient profiling allows AsteRx & QlikView to break new ground in identifying health trends
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
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Case Study: Pfizer
Pfizer’s high-performance computing software and systems for worldwide research and development support large-scale data analysis, research projects, clinical analytics, and modeling. Pfizer’s computing services are used across the spectrum of research and development efforts, from the deep biological understanding of disease to the design of safe, efficacious therapeutic agents.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Fusion Middleware Integration on Cloud for Pharma Major
Customer wanted a real-time, seamless, cloud based integration between the existing on premise and cloud based application using SOA technology on Oracle Fusion Middleware Platform, a Contingent Worker Solution to collect, track, manage and report information for on-boarding, maintenance and off-boarding of contingent workers using a streamlined and Integrated business process, and streamlining of integration to the back-end systems and multiple SaaS applications.
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.