Transforming R&D Data (Tables, Listings, and Figures) for a Biotech Company
Clarkston Consulting recently partnered with a biotech client on a R&D data transformation. Read a synopsis of the project below or download the full case study.
Download the Transforming R&D Data TLF Case Study Here
An emerging and rapidly expanding rare disease biotech company saw an opportunity to create a better and more efficient way to empower its R&D teams during exploratory research. R&D teams depend on quick, reliable access to clinical and study data to drive more holistic perspectives across overall patient population results.
Yet, this client faced significant challenges in extracting and interpreting key insights from Tables, Figures, and Listings (TLFs), a process burdened by manual workflows, inefficient document handling, and increased risk of human error. Researchers were forced to manually sift through individual .rtf files, painstakingly combining data points, as they sought to understand “the big picture” within trial data.
Through close collaboration with R&D stakeholders, our team identified key pain points and designed an intuitive application that transforms the way teams interacted with TLF data. Together, we designed and developed a solution that allowed users to efficiently visualize critical data from TLFs, providing a more holistic view of relevant patient information and key biomarkers.
Through stakeholder workshops and collaborative discovery sessions, the team gathered detailed functional and user experience requirements. This informed the development of a modular, assay-aware application with secure architecture. The resulting Streamlit-based tool enables users to quickly search and filter key data points across TLFs, generate customized patient-centric views, and explore integrated outputs across multiple assays through fixed tabs representing Blind ID, Block ID, and Subject ID levels. Users can also create charts within a dedicated “Explore Data” tab, facilitating insight generation and cross-assay comparison.
The scalable solution that the team built can quickly ingest new studies and be expanded to serve different user groups, helping to evolve with the needs of the growing organization.
As a result of this tailored application, the Clarkston team saved significant time for R&D teams by enabling seamless access to key TLF data, eliminating the need to manually parse .rtf files, and empowering further exploratory research.
