Lilly technical consultants were tasked with operationalizing data insights on clinical trials and setting up web-based dashboards to the chart progress. The team needed to accurately monitor, plan, and forecast patient status across all phases of clinical trials. In order to do so it was critical to understand how patients were enrolled in trials and track their status over a period of time. Lilly had complex manual processes in place using SQL, MS Access and XLS to integrate 20 different data sets in S3 for a single study. They were manually executing SQL queries 8 times a day to update reports and dashboards with minimal collaboration due to siloed processes. The call to action was to streamline and automate data flows downstream to enable business analysts, all while controlling costs and efficiencies across all clinical sites.
How Designer Cloud Solved this Problem
Leveraging EMR, Amazon S3, and Amazon Redshift for storage and processing, Lilly has been able to collect and transform the data with reference data libraries eliminating redundant data cleansing efforts. The improved data accuracy eliminates manual data edits and has accelerated development. As a result Designer Cloud has enabled business analysts to perform their own aggregations, pivots, max date and window functions. This has eliminated dependency on IT to curate data. Lilly now can track drug efficacy milestones throughout studies to ensure therapeutics are successful.