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.