Introduction

The client requested a dynamically updated app with dashboards, event flow overviews, adjudication details and metrics. The app required multiple source input, from both SAS data files and Excel files, across several studies. In addition, the client needed specific metrics endpoints for selected studies.

S-Cubed

Project Duration

5.5 weeks

S-Cubed

Consultants involved

2

S-Cubed

Products Used

Qlik Sense

The Challenge

Event Adjudication is a vital part of Clinical Trials to provide an objective medical assessment for occurring events of interest. Data is sent by the Sponsor to external adjudicators that in turn provides the assessments and transfer the data back. In this scenario, the customer needed to intuitively visualize the flow and status of adjudicated events across several Clinical Trials. Since the event data came from different sources, a completely dynamic, easily controlled setup was necessary to allow for individual differences in the Trials. In addition, reports with single event details were required for continued monitoring.

The Solution

The dynamic solution created allowed the client to fully control the ETL process so that new vendor files could easily be incorporated. It also enabled control of study-specific endpoints and metrics so that the app could be used across multiple different studies. In the end, the implementation saved a lot of time and manual labour and greatly simplified the governance and reporting of the Event Adjudication workflow.

The Benefit

The customer desperately needed a graphical overview and collation of adjudication data from their existing solution. Using Qlik Sense they were able to both establish a greater level of oversight as well as export detailed lists for additional use. The client was very satisfied with the result. 

Company Profile

Client Location

Client Location

Denmark

Client Size

Client Size

40K employees

Client Type

Client Type

Pharmaceutical

Get in Touch

Lautrupsgade 7, 1. tv.,
2100 Copenhagen Ø, Denmark

+45 31 45 29 16

info@s-cubed-global.com

    Selected Case Studies

    Medical Monitoring

    Medical Monitoring

    Our solution enabled the client to fully automate their data extraction from source systems and reduce the manual interactions required.

    read more