Alteryx > Case Studies > Lilly's Transformation: Collaborative Engineering with Designer Cloud

Lilly's Transformation: Collaborative Engineering with Designer Cloud

Alteryx Logo
Applicable Industries
  • Pharmaceuticals
Use Cases
  • Time Sensitive Networking
  • Track & Trace of Assets
Services
  • Cloud Planning, Design & Implementation Services
About The Customer
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.
The Challenge
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.
The Solution
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.
Operational Impact
  • 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.
Quantitative Benefit
  • 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

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.