The Fluid and Tissue sample labs at Genentech, a subsidiary of Roche regularly receive manifest files from external labs that need to be properly standardized and structured for onboarding into Genentech’s proprietary sample management system, SAMi. Onboarding these files was a significant undertaking—not only did Genentech receive huge volumes of manifest files, but its vendors provided these files in many different formats. Under manual, code-based processes, there was always a looming possibility of data quality errors and an inability for Genentech to scale. Many of Genentech’s business users, who knew the contents of these files quite well, were unable to review or upload files simply because they didn’t know how to code.
How Trifacta Solved this Problem
Upon implementing Trifacta edition on AWS, Genentech was able to automate the ingestion of manifest files into SAMi. In doing so, Genentech reduced time spent onboarding files from four hours down to just one hour. That means that sample data from new vendors is quickly available for tracking and downstream business analysis, leading to swifter insights. Perhaps most exciting for the Genentech team is that the intuitive Trifacta experience allows business users to be hands on with the onboarding process. Not only has this allowed the process to scale more quickly, but business users can now enrich and extend data from multiple sources while Trifacta automatically tracks where each source originated and how it has been transformed.
Genentech can onboard new data 75% faster by leveraging Trifacta’s automation and scheduling capabilities.
Genentech business users that have the best context of the data use Trifacta’s intuitive interface to enrich and extend data.
Automation allows for exponential growth, plus Genentech can now involve more non-technical more users in the onboarding process.
Roche is a global pioneer in pharmaceuticals and diagnostics focused on advancing science to improve people’s lives. The combined strengths of pharmaceuticals and diagnostics under one roof have made Roche the leader in personalised healthcare – a strategy that aims to fit the right treatment to each patient in the best way possible.