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.
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 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 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.
Selected Case Studies
How do you create a Central Clinical Monitoring Plan that meets the needs of all stakeholders?
Many trials tend to not make it to the planned Last Patient First Treatment date set by Trial Managers…
Our solution enabled the client to fully automate their data extraction from source systems and reduce the manual interactions required.