Using R Markdown, SQL, and RODBC to Generate Reports

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.

Author: 
Primary Topic Areas: 
Original Publication Year: 
2017
Event/Publication Date: 
May, 2017

September 20, 2017

Contact Us

NSSP Community of Practice

Email: syndromic@cste.org

 

This website is supported by Cooperative Agreement # 6NU38OT000297-02-01 Strengthening Public Health Systems and Services through National Partnerships to Improve and Protect the Nation's Health between the Centers for Disease Control and Prevention (CDC) and the Council of State and Territorial Epidemiologists. Its contents are solely the responsibility of the authors and do not necessarily represent the official views of CDC. CDC is not responsible for Section 508 compliance (accessibility) on private websites.

Site created by Fusani Applications