Start Wrangling

Speed up your data preparation with Trifacta

Free Sign Up
Trifacta Ranked #1 in Data Preparation Market Study

Dresner Advisory Services study reviews and ranks 24 vendors

Get the Report
Schedule a Demo

Getting Clinical Trial Data Ready for Analysis: How IQVIA Wrangled its Way to Success

September 25, 2019

The following is a guest post from Trifacta customer, Yogesh Prasad is an Associate Director of IT at IQVIA, who will be presenting on his case study at Strata Data Conference in NYC this week.

As a part of the global healthcare community, IQVIA continuously invests and is committed to advancing healthcare. For IQVIA, it’s bigger than clinical trials. As medicine gets more precise, it has become difficult to make accurate assumptions. I’m very excited to take the stage at the Strata Data Conference in New York this Thursday, September 26th, and share how IQVIA has overcome these challenges with our Clean Patient Tracker project for clinical trial data. By leveraging modern data, we have been able to reduce analytics turnaround time by 50% and continue to make improvements to our processes.

With over 70 different teams and more than 1,500 – 2,000 people accessing data across 250 different vendor warehouses, it took analysts days to copy data from its fragmented structure into a single system. These processes created unnecessary bottlenecks when turning around reports to our customers. As the increase of non-identified and unstructured patient data continued to enter IQVIA’s warehouses, we needed to integrate new techniques and technology to help our analysts explore and replicate data sets faster and reduce project turnaround time. Government agencies, pharmaceutical companies and academic institutions rely on this clinical trial data to find insights and improve healthcare outcomes for patients around the world.

Prior to working with Trifacta, Cloudera and Streamsets, manual processes to standardize clinical study data in a format that was compliant with FDA standards would take about 4-6 weeks. Note that on average, IQVIA is doing 50-70 studies as any given point. By implementing these new platforms in our analytical architecture, we are now able to generate a report in 15 minutes – cutting this process down to 1-2 days. In total, the overall turnaround time has been reduced by 92 percent for every new clinical studies data our team receives.

Additionally, we’ve seen an increase in prediction accuracy by four times its original rate. This has not only helped the company achieve its mission of finding the right patient for the ideal clinical trial, but has increasingly accelerated the pace of discovery.

I’m looking forward to sharing more about our journey at IQVIA during our session this week at the Strata Data Conference. If you’re attending the conference I hope you’re able to join our session and feel free to connect afterwards.

Event Details
2:05pm–2:45pm Thursday, September 26, 2019
Strata Data Conference
Javits Center
655 W 34th Street
New York, NY 10001
Location: 1A 04/05

Register

Related Posts

Interactive Data Visualization

Interactive data visualization tools that deliver your data in a graphically compelling, easy-to-understand... more

  |  July 27, 2016

Data Preparation Best Practices for Snowflake’s Cloud Data Warehouse

Snowflake is known for their separation of storage and compute, which makes scaling data more efficient.... more

  |  October 1, 2019

Pushing the Boundaries of Performance:
On-the-Fly Data Wrangling at Scale in v4

At Trifacta, we’ve always strived to deliver the most immersive, interactive data wrangling experience.... more

  |  September 27, 2016