Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
 

Prepares Clinical Trial Data at Record Pace for Faster Healthcare Breakthroughs with Trifacta

 

$ 1.2 Million

In overhead costs will be saved each year

92 %

Reduction in turnaround time for clinical studies

4 X

Increase in prediction accuracy
 

Core Challenges

On any given day, IQVIA manages patient data for up to 70 different clinical studies run by government agencies, pharmaceutical companies and academic institutions. Under legacy tools and processes like SAS, copying this data into a single system from 250 unique vendor warehouses took days, while standardizing the data into FDA-compliant formats required 1 to 2 months. As the data generated from clinical trials came in at a faster rate and became increasingly non-identified and unstructured, IQVIA risked more significant delays, which would stall their clients’ progress.

 

How Trifacta Solved this Problem:

IQVIA now operates upon a centralized data platform that includes Streamsets for data integration and Trifacta for data engineering. This new analytic stack has allowed IQVIA to drastically reduce its delivery times from 1 to 2 months down to 1 to 2 days. Instead of relying on in-house developers, Trifacta’s intuitive approach to data transformation has allowed IQVIA to scale its efforts through domain experts who are adept at spotting patterns and data quality issues. And even though patient data has grown larger and more complex, IQVIA has seen a 4X increase in prediction accuracy. As patient data continues to take on new forms, IQVIA can make simple adjustments to its Trifacta recipes while maintaining the same delivery speed.

 

Benefits

Faster Time to Value

With Trifacta, IQVIA reduced the turnaround time of executing analysis for their clients by 92%

Cost Savings

Once this process is adopted across all new and existing clinical trials, IQVIA will save $1.2 million a year by automating these analytics.

Improved Accuracy

IQVIA has seen an increase in prediction accuracy by four times. This has helped IQVIA better match patients to trials and accelerate the pace of discovery.

 

Company Background

IQVIA is a world leader in using data, technology, advanced analytics and expertise to help customers drive healthcare – and human health – forward.