Print Page | Contact Us | Report Abuse | Sign In | Register
R Group for Biosurveillance Meeting
View Registrations Tell a Friend About This EventTell a Friend
 

May 2017 R Group Meeting - "Using RMarkdown, SQL, and RODBC to generate reports," by Eric Bakota

 Export to Your Calendar 5/31/2017
When: May 31, 2017
From 12 pm - 1 pm ET
Where: https://attendee.gotowebinar.com/register/3365327298910745858
United States
Presenter: Eric Bakota
Contact: Catherine Tong
« Go to Upcoming Event List  

Registration

https://attendee.gotowebinar.com/register/3365327298910745858

Presenter 

Eric Bakota, MS

Informatics-Training in Place Program Fellow

Staff Analyst

Office of Surveillance and Public Health Preparedness

Description

In this month’s webinar, I 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.

Contact Us

INTERNATIONAL SOCIETY FOR
DISEASE SURVEILLANCE

288 Grove St, Box 203
Braintree, MA 02184
(617) 779 - 0880
Email: syndromic@syndromic.org