Skip to main content

Recent advances in technology have simplified the creation, collection, storage, and analysis of health care data. However, researchers and clinicians are still working to realize the potential of this data.

The PPMH Precision Analytics group is collaborating with the NC Translational and Clinical Sciences Institute (NC TraCS) to offer a virtual workshop that will provide an introduction to working with patient or clinical data. During the workshop, participants will work with a deidentified Electronic Health Record (EHR) data set based on actual patient records. This workshop is designed for UNC researchers and clinicians with prior database experience.

Topics included:

  • Introduction to the PCORnet data model and Carolina Data Warehouse
  • SQL techniques for working with databases
  • Working with EHR data in Python
  • Building EHR queries – methods and best practices
  • Building phenotypes
  • Research at UNC with patient and clinical data


Monday June 7, 2021 • 9:00am-12:00pm 
Wednesday June 9, 2021 • 9:00am-12:00pm 
Friday June 11, 2021 • 9:00am-12:00pm

The workshop will be virtual and taught via Zoom. This workshop is open to researchers affiliated with UNC who have an ONYEN. There is no charge to attend. The application will be available in early May, and applications will be due at 9:00am May 12, 2021.

The workshop is being organized by the PPMH Precision Analytics group, the UNC Clinical Research Support Office, and the NC Translational and Clinical Sciences Institute.

For more information, contact