This webinar will showcase the work that the Oregon EMS & Trauma Systems program has done to build workflows using metadata to drive data extraction, cleaning, analysis and visualization from our ImageTrend DataMart database. This approach allows us to get upstream of the many projects that we develop and/or update every year/quarter/month, to make changes in only one place; our data dictionary. Using a modular approach, building functions and scripts to support these projects, will allow us to produce more consistent, validated data products more quickly.

The presentation is designed to be accessible to a general audience regardless of programming/coding experience. All examples given will be using the ImageTrend DataMart database, the open source R programming language (https://www.r-project.org/) and R Studio IDE (https://posit.co/products/open-source/rstudio/), but a similar approach may be implemented for use with any other database, or other languages such as Python, SAS, etc.