Speed pipeline creation to ensure better healthcare outcomes

Unlocking real-world evidence through
visual transformation

500M

health records
processed in 2 months

50%

faster data source
onboarding

Company Size

200+ employees

Industry

Healthcare and Lifesciences

Department

Data Science

Operations

Databricks

Challenge

Legacy data architecture and manual processes slow real-world data exploration

Workflow complexities impact product launch

Aetion's team was eager to release their rapid insights application, Discover. But getting this to market posed a significant engineering and development challenge. Their existing system was optimized for specific workflows, limiting customer flexibility. To enable the ability for users to perform ad-hoc discovery queries – a critical requirement, Aetion needed to transform their data into a generic schema, which was time consuming and delayed the launch of Discover.

Manual data transformations a data operations bottleneck

Manual coding and Notebooks for processing real world data created bottlenecks and slowed access to data. Managing and maintaining custom code increased the complexity of these processes and limited Aetion's ability to scale their data operations, compromising the quality and reliability of Aetion's real-world data exploration product.

Solution

Streamlining data pipeline development with reusable components fuels faster product delivery

Faster data processing for an on-time product launch

Prophecy’s efficient data processing capabilities let Aetion accelerate the launch of their Discover product by enabling the team to process over 500 million records within 2 months. This significant improvement allowed them to not only meet the Discover launch deadline, but to onboard their first 3 customers ahead of schedule.

Accelerated pipeline development with visual, no-code tooling

Prophecy’s visual development interface eliminated the reliance on Notebooks and manual coding of SQL data transformations. Aetion’s team could leverage Prophecy’s drag-and-drop functionality to quickly build high quality pipelines without the need for complex, custom code. Additionally, Prophecy’s library of pre-built and reusable components for common tasks further streamlined the development process

“Prophecy’s visual development experience and reusable components have transformed our data pipeline delivery workflows. This has allowed us to deliver real-world data exploration faster and expedited the launch of our Discover product. By improving our engineering productivity we’ve been able to deliver faster insights for our customers.”

Dan Rohtbart, Vice President of Engineering, Aetion

Results

Streamlined development, reduced manual work

By automating pipeline creation, Aetion eliminated the need for manual development. This streamlined process accelerates the development of new SQL Data pipelines, allowing Aetion to respond quickly to evolving data needs and deliver real-world data analytics solutions faster.

Efficiency drives product delivery

Streamlined data processing enabled Aetion to handle a massive 500 million records within just two months. This improvement in efficiency ensured the timely delivery of their Discover application, allowing Aetion to meet customer needs and capitalize on new opportunities.

Faster onboarding, scalable growth

Aetion reduced data source onboarding time by over 50%, enabling users to easily integrate new sources and rapidly expand their offerings. This unlocked scalability, allowing Aetion to handle growing data volumes efficiently and ensure faster delivery of new products to their user base.