Clair Blacketer: CDM 5.4 Workshop Part 1

This is good overview of CDM with some practical hints.

 

 

https://www.youtube.com/watch?v=wVtEH7QXyvk&t=2135s

 

 

 

 

Clair Blacketer OMOP ETL tips and tricks

 

Clair Blacketer gives a great overview of practical aspects of the OHDSI ETL process here:

 

https://www.youtube.com/watch?v=wVtEH7QXyvk&t=3670s

 

Clair Blacketer, Manager, Epidemiology Analytics, Janssen Research & Development\

 

 

The University of Queensland OMOP Dataset

The University of Melbourne and The University of Queensland have signed an agreement to work on the conversion Queensland Health Cerner data to the OMOP common data model. Analysts are currently working on establishing a pilot extract load transform process (ETL) with synthetic Cerner data.

A community of practice is also being established to share expertise and support EMR conversions in other states.

 

Steering committee

We had our first steering committee meeting on the 14^th July. Industry representation was high on the agenda. A co-chair was proposed and we had nominations of Nicole Pratt and David Bunker.  A decision will be confirmed at the next steering committee meeting.

 

 

 

Technical Meetings

We had our first EMR's to OMOP technical meeting today with colleagues from Queensland and NSW. 

We had demonstration of the OMOP ETL tool https://www.omop.link and a demonstration of Atlas. 

Extract, Transform, Load Framework for the Conversion of Health Databases to OMOP

Congratulations to our colleagues in UNSW on the publication of their paper on conversion methods for OMOP.

"Extract, Transform, Load Framework for the Conversion of Health Databases to OMOP"

Link:

https://www.medrxiv.org/content/10.1101/2021.04.08.21255178v2

EMR's to OMOP Progress

We are advancing work with two centres in Victoria and Queensland. Atlas is being set up in each centre with Synthetic CDM data to get researchers familiar with the structure of OMOP. All those R skills are going to come in handy!

https://www.ohdsi.org/atlas-a-unified-interface-for-the-ohdsi-tools/