200 likes | 343 Views
The eHARS Dashboard. A tool for monitoring HIV surveillance activities. Michael Eberhart, MPH Philadelphia, PA. HIV Surveillance. Requires complete and accurate data Multiple sources Various report mechanisms Changing procedures/requirements Passive and active surveillance
E N D
The eHARS Dashboard A tool for monitoring HIV surveillance activities Michael Eberhart, MPH Philadelphia, PA
HIV Surveillance • Requires complete and accurate data • Multiple sources • Various report mechanisms • Changing procedures/requirements • Passive and active surveillance • Electronic data • Parsing/cleaning/importing
HIV Surveillance • Frequent evaluation and review • Respond to subtle changes • Identify gaps • Compare with historical trends • Not just cases • Facilities • Labs • Physicians • Completeness • Workflow
eHARS Data • Person dataset • New cases and demographic trends • Document dataset • Report sources and methods • Laboratory tests • Death reports • TTH (for incidence surveillance)
eHARS Dashboard • Data “at a glance” • Succinct presentation • Actionable data • Trends • Comparisons • Identify new issues • Modified from sample code • “Information Dashboard Design” by Stephen Few
eHARS Dashboard • Produced monthly • HTML-based • Graphical presentation • Drill-down to more detailed information • Overview of all activities • User-specific information in the background
eHARS Dashboard - Components • Documents • Entered manually • Total docs • By user • By type • Completeness • Missing Surveillance Method • Missing Report Source • Missing Report Medium
eHARS Dashboard - Components • Documents • Imported electronically • Total docs • By user • By type
eHARS Dashboard - Components • New HIV/AIDS Cases • Past 12 months • Compared to previous 12 months
eHARS Dashboard - Components • Cumulative Data • Total reported AIDS • Total reported HIV • Total reported perinatal exposures • Median time to data entry • This period/Last period
eHARS Dashboard - Components • Top 10 Diagnosing Facilities • Past 90 days • Drill down to complete list • Exclude private • Drill-down to list of cases with missing data • Lab import issue
eHARS Dashboard - Components • Median Initial CD4 • Boxplot w/ confidence intervals • Cases dx’d in previous 6 months • Comparison by gender • Race • Mode of Exposure • Public/private
eHARS Dashboard - Components • Open Cases by Investigator • Uses local fields • Compare staff • Monitor workload • Drill-down to lists
eHARS Dashboard - Components • Completed cases by Investigator • Compare staff • Compare to unit average • Monitor workload • Drill-down to summary data
eHARS Dashboard - Components • Electronic Lab Reporting • Past 12 months • Compared to previous 12 months • Drill-down to lab-specific trends • Listing by month and lab • Graphs of 2-year trends
eHARS Dashboard - Components • Reported Labs by Type • CD4 • Western Blot • Viral Load • Other • Last complete month compared to monthly average
eHARS Dashboard - Components • Process indicators – Past 90 days • % NIR • % Missing Race/ethnicity • % No CD4 (Count or percent) • % Missing Vital Status • % Invalid address • Local interest…
eHARS Dashboard – SAS Code • Intermediate level • Working with macro variables • Proc SQL • SAS/GRAPH • Templates, GREPLAY, Device options • ODS • HTML (drill-down and tool tips)
eHARS Dashboard • Demo • Questions?
Thank You! • Contact Information • michael.eberhart@phila.gov