Start Free

Speed up your data preparation with Designer Cloud powered by Trifacta

Free Sign Up

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


$ 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 Designer Cloud Solved this Problem:

IQVIA now operates upon a centralized data platform that includes Streamsets for data integration and Designer Cloud 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, Designer Cloud 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 Designer Cloud recipes while maintaining the same delivery speed.



Faster Time to Value

With Designer Cloud, 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.