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

Edit This Case Study Record

	Lilly's Transformation: Collaborative Engineering with Designer Cloud Alteryx

Lilly's Transformation: Collaborative Engineering with Designer Cloud

Alteryx

Applicable Industries	Pharmaceuticals
Use Cases	Time Sensitive Networking Track & Trace of Assets
Services	Cloud Planning, Design & Implementation Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Applicable Industries

Pharmaceuticals

Use Cases

Time Sensitive Networking

Track & Trace of Assets

Services

Cloud Planning, Design & Implementation Services

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.

About 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.

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Saved 6 months in delivering insights
Benefit #2	Reduced annual cost by $700,000
Benefit #3	Delivers clinical trial insights in near real time, previously it took up to six months

Benefit #1

Saved 6 months in delivering insights

Benefit #2

Reduced annual cost by $700,000

Benefit #3

Delivers clinical trial insights in near real time, previously it took up to six months

Download PDF Version

Overview

Lilly's Transformation: Collaborative Engineering with Designer Cloud

Operational Impact

Quantitative Benefit