Course Description
Data management and computation training to synthesize insights from health data. The teaching model uses public-use data sources to coach students about how to work with data and to tell quantitative narratives relevant to the public and private health sectors.
Athena Title
Data Fluency and Mgmt in PH
Prerequisite
EPID 2100
Grading System
A - F (Traditional)
Course Objectives
The successful student should be able to: • Locate and download publicly available data sources on the demographics and health of populations • Utilize data dictionaries to understand how data were collected • Restructure data to be suitable to multiple forms of tabular and visual analytic methods • Perform quality assurance and data integrity exercises • Quantify the health of populations using contemporary public health data sources using spreadsheets • Articulate multiple solutions to solve data problems • Produce health data products and reports for private and public sector audiences • Communicate insights for lay audiences using health data visualizations in Tableau • Apply data merges to combine data from multiple sources • Utilize pivot tables and pivot charts to describe data characteristics • Reclassify variables to meet analytic needs
Topical Outline
• Accessing health data in public-use data sources • How to read a data dictionary and data collection methodology • Relational Model for managing data • What is a data generating process and how to check its integrity? • Reshaping data in spreadsheets • Writing formulas to merge data and to reclassify data • Pivot Tables and Pivot Charts for flexible data presentation • Producing a data product (a new dataset) • Producing a data insight (a report component)
Syllabus