This module focuses on importing, transforming, and visualizing clinical trial data. Participants learn to build interactive, ‘live’ dashboards that turn raw data into actionable insights, supporting better decision-making and stakeholder engagement.

Teaching approaches

• Guided Step-by-Step Modules: Delivered through our Virtual Learning Environment, each lesson walks participants through key tasks with clear, structured instructions.
• Hands-On Practical Exercises: Learners apply concepts directly by working with real data and building functional dashboards.
• Self-Paced Learning: Participants can complete exercises at their own pace, allowing flexibility while reinforcing understanding.
• Golden File Comparison: A completed ‘Gold Standard’ dashboard is provided for learners to compare their work and self-assess progress.
• File Submission for Review: A method is provided for participants to return their completed dashboards for feedback and review.

Course Content

1.       Introduction

2.       SQL Server Setup and SMSS Installation

3.       Power BI Gateway

4.       Power BI Basics Training

5.       Single Table Auto Filtering

6.       Table Display

7.       Patient Details

8.       Publication

9.       Summary

Course tutors

Jim Read - Liverpool School of Tropical Medicine

Jim Read leads a team of data management professionals at the Liverpool School of Tropical Medicine, specializing in clinical trials data, software development, and system administration. With over a decade of experience, Jim has implemented data warehousing, reporting tools, and document management software. They have a strong background in full stack development and big data, enhancing efficiency in clinical research.

Debby Choudhury - Liverpool School of Tropical Medicine 

Debarpita Choudhury is a Data Manager at the Liverpool School of Tropical Medicine, specializing in clinical trial data integrity and compliance. She has a background in clinical research, public health, and dentistry.