The Customer
One of the world’s leading bio-pharmaceutical companies grounded in commitment to advance medical care, improve patient outcome and provide access to medicines that are safe, effective, and affordable.
Challenges
- Fragmented, disparate and non-standardized data sets
- Lack of synergies in repurposing workflows applicable to similar question across different brands and markets leading to inefficiencies
- Long process of integrating data sets, ETL, aggregation, analytics resulted in long Turnaround Time (TAT) of approx. 6 weeks to answer a business questions from brand teams
The Solution
- We set up patient data capability by integrating data sets into common data model and created standardized data flows for 80-85% of common business questions.
- We then built a comprehensive repository of reusable-code for easy repeatability of analyses which can be deployed across multiple markets and KPIs.
- We also developed dynamic self-service visual tools across multiple data sets, brands and, markets which can be accessed by stakeholder across the enterprise for better decision making.
Outcomes
The client was able to bring efficiencies in patient analytics with 60-80% reduction in time to insights, from Common Data Model to Dashboard (from 4-6 weeks to 2 days).
They standardized 9 industry data sets into Common Data Model framework, and delivered 10+ advanced patient analytics projects.
They scaled from from 2 data sets, 2 markets to 12 data sets, 9 markets in less than a year across 6 therapy areas, enabling organizations be future ready.
4,000,000,000+
Patient records handled
30+
Analytics ready data sets created
80%
Reduction in time to insights