Description
Presented May 31, 2017.
Eric Bakota will go over the results from the survey and then I’ll show a report that we generate at HHD using RMarkdown, SQL, and RODBC. This report uses RODBC to connect to our Electronic Disease Surveillance System (MAVEN) to query data needed for the report. The data are imported to R, where they are processed into the various tables, graphs, charts that are used to generate the report. Automating this report has saved 8-10 hours each month.