Workshop to Workflow: Automizing Weekly Respiratory Reports with Quarto
Regular talk, 3:15 - 4:15 PM
As influenza and respiratory syncytial virus (RSV) epidemiologists for the Oregon Health Authority (OHA) we are tasked with publishing weekly reports that summarize respiratory virus surveillance trends in Oregon. Our original process for generating these reports utilized SAS Microsoft Excel Microsoft Publisher with manual copying and pasting of graphs. This largely manual workflow was both time-consuming and susceptible to human error. In June 2024 we had the opportunity to take the Quarto workshop offered at the R Cascadia conference. This workshop provided us with the tools and skills to convert our manual reporting process to a fully automated report creation process using Quarto for both influenza and RSV. In the future we plan to convert additional surveillance reports to automated processes using the tools learned in the Cascadia R Quarto training. We are also exploring the use of internal Quarto dashboards to monitor weekly respiratory virus hospitalization rates and implement additional quality improvements projects. Links to RSV and flu report
![]() |
Pronouns: she/her; she/herAlbany, OR, USA; Portland, OR, USAArilene Novak and Andie Hendrick work together at the Oregon Health Authority (OHA) as RSV and influenza epidemiologists. They've been working together since 2022 with the focus of creating streamlined surveillance and reporting practices. Arilene lives in Albany with her husband, corgi, and 2 cats and enjoys gardening and Mexican food. Andie lives in Portland with her partner and spends her free time riding bikes, cheering for the Portland Thorns, and working on home improvement projects. |