Customer Story

Lilly Attains Collaborative Engineering with Designer Cloud


Lilly Key Stats

Industry: Biotechnology

Data Stack: AWS, Designer Cloud, PowerBI, Microsoft Excel

Region: Global

6 Months

Saved in delivering insights


Reduced annual cost


Core Challenges

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.



Reduced Cycle Time

Today Lilly can deliver clinical trial insights in near real time, previously it took up to six months to complete integrating data sets for clinical trials. This reduced cycle time in turn has reduced spend by $700,000 a year.

Improved Collaboration

The use of one tool across both data stewards and BI/Analysts has improved collaboration across teams and reduced the manual execution of flows created a culture of self service.

Reduced Risk

Through improved governance and end-to-end transformation lineage tracking in human readable form this has reduced the risk of regulatory claims.


Company Background

Lilly is a global healthcare leader that unites caring with discovery to create medicines that make life better for people around the world. Founded in 1876 by a man committed to creating high-quality medicines that met real needs. Across the globe, Lilly employees work 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.



Using Designer Cloud makes your developers a lot more valuable and powerful because they’re able to operate within this community of other people.

Eli Lilly

Randy Santiano, Associate Technical Consultant 

Eli Lilly


Assess Your Analytics Maturity

Get a better understanding of where you stand on the analytics maturity scale – and where you want to be.

Get Started

Recommended Resources

Customer Story
Health Care Program Advisors Builds Actionable Models with Snowflake, Alteryx, and Tableau
A boutique healthcare consulting firm uses modern analytics tools to provide advisory services to its clients.
  • Designer
  • Server
  • Healthcare and Insurance
Read Now
Customer Story
IQVIA Prepares Clinical Trial Data at Record Pace for Faster Healthcare Breakthroughs
IQVIA now operates upon a centralized data platform that includes Streamsets for data integration and Designer Cloud for data engineering.
  • Cloud Customer Spotlight
  • IT Professional
  • IT
Read Now
Customer Story
Washington State Department of Health Analyzes Data for a Healthier World
Program analysts can access usable data sets and rapidly explore, clean, standardize, and transform data in the cloud for analytics.
  • Cloud Customer Spotlight
  • Professional
  • IT
Read Now