Alteryx web forms will be unavailable from 1:00 AM – 4:00 AM UTC on Wednesday, July 22. Have questions? Chat with Annie, our AI Chat Bot. Chat Now
Talk with Annie, Alteryx’s AI agent that answers data questions, explores use cases, and helps teams solve analytics faster. Talk to Annie Now
Alteryx and Google Cloud expand partnership, bringing Live Query in-place analytics to BigQuery, with more coming soon Learn More
hero background shape
CUSTOMER STORY

IQVIA Prepares Clinical Trial Data at Record Pace for Faster Healthcare Breakthroughs

hero background gradient

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.

BENEFITS OF USING ALTERYX
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.

 

Recommended Resources

 
Starter Kit / Template
Tax PDF Data Extraction and Normalization

This Starter Kit helps tax teams extract data from tax PDFs by reconstructing tables, normalizing fields, and flagging low-confidence outputs.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More
 
Starter Kit / Template
Unstructured Invoice Intake and Structuring Starter Kit

This starter kit helps AP teams handle invoices from emails, PDFs, and scans by parsing fields and producing structured records.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More
 
Starter Kit / Template
Transfer Pricing Documentation Support Starter Kit

This Starter Kit helps tax teams produce transfer pricing documentation by linking intercompany transactions, comparables, and evidence.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More
 
Starter Kit / Template
Trial Balance Mapping and Disclosure Preparation Starter Kit

This Starter Kit helps finance teams produce disclosure-ready financial data by mapping trial balances, applying materiality thresholds, and flagging exceptions with traceable controls.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More
 
Starter Kit / Template
Regulatory Filing Data Preparation Starter Kit

This Starter Kit helps compliance and finance teams prepare regulatory filings by standardizing datasets, validating rules, and assembling submission-ready outputs.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More
 
Starter Kit / Template
Accounting Close Exception Resolution Starter Kit

This Starter Kit helps accounting close teams detect and resolve close breaks earlier using validation rules, materiality thresholds, and exception workflows that produce audit-ready evidence.

  • Analytics Leader
  • Business Leader
  • Finance Leader
Learn More