Alteryx Case Studies Lilly's Transformation: Collaborative Engineering with Designer Cloud
Edit This Case Study Record
Alteryx Logo

Lilly's Transformation: Collaborative Engineering with Designer Cloud

Alteryx
Pharmaceuticals
Time Sensitive Networking
Track & Trace of Assets
Cloud Planning, Design & Implementation Services
Lilly, a global healthcare leader, faced significant challenges in operationalizing data insights on clinical trials and setting up web-based dashboards to track progress. The team needed to accurately monitor, plan, and forecast patient status across all phases of clinical trials. This required understanding how patients were enrolled in trials and tracking their status over 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 eight times a day to update reports and dashboards. However, these processes were siloed, leading to minimal collaboration. The challenge was to streamline and automate data flows downstream to enable business analysts, while controlling costs and efficiencies across all clinical sites.
Read More
Lilly is a global healthcare leader that combines caring with discovery to create medicines that improve people's lives worldwide. The company was founded in 1876 by a man committed to creating high-quality medicines that met real needs. Lilly employees work globally to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to communities through philanthropy and volunteerism.
Read More
Lilly leveraged EMR, Amazon S3, and Amazon Redshift for storage and processing to solve this problem. They were able to collect and transform the data with reference data libraries, eliminating redundant data cleansing efforts. This improved data accuracy, eliminated manual data edits, and accelerated development. Designer Cloud enabled business analysts to perform their own aggregations, pivots, max date, and window functions, eliminating dependency on IT to curate data. As a result, Lilly can now track drug efficacy milestones throughout studies to ensure therapeutics are successful.
Read More
The implementation of Designer Cloud has significantly improved Lilly's operations. The use of one tool across both data stewards and BI/Analysts has improved collaboration across teams and reduced the manual execution of flows, creating a culture of self-service. Through improved governance and end-to-end transformation lineage tracking in human readable form, the risk of regulatory claims has been reduced. The improved data accuracy has eliminated manual data edits and accelerated development, enabling Lilly to track drug efficacy milestones throughout studies to ensure therapeutics are successful.
Saved 6 months in delivering insights
Reduced annual cost by $700,000
Delivers clinical trial insights in near real time, previously it took up to six months
Download PDF Version
test test