Data Visualization Portfolio

1 Introduction

This RMarkdown portfolio report generates data visualization efforts from various data viz programs, including R, QGis, and Tableau. Data sources for each graph are listed below.

1.1 Health Data & Disparities

The focus of this report is health data and health-related disparities. Specifically investigated in this report is estimated diabetes prevalence for counties of Michigan and national data regarding annual check ups and estimated lack of health insurance for selected U.S. cities.

1.1.1 Diabetes

Investigating diabetes prevalence numbers sheds light on important health characteristics of a community. Based on this data, it is imperative to determine and study the access of residents to health care, health education and literacy, and the possibility of preventative programs.

Diabetes Predictors & Consequences

1.1.2 Annual Check-Ups and Insurance

These specific variables were pulled from the dataset for their important relationship to diabetes health and treatment. Annual check-ups to a primary care physician ensures that there is some interaction with a physician; endocrinology, being a specialty field, may be financially inaccessible to low-income communities. Engagement with a primary care physician ensures that a person’s overall health is being looked after.

Insurance plays a vital role in the treatment and management of diabetes, whether Type 1 or Type 2. Insulin is too expensive to be paid for out of pocket per month; diabetics who experience lapses in insurance or are not covered at all may be at risk for diabetic ketoacidosis, coma, or death.

Annual Check-Ups and Insurance Predictors and Outcome

2 Data

In order of appearance:

R base graph and the QGIS map uses data from https://www.cdc.gov/diabetes/atlas/countydata/DMPREV/Michigan.xlsx. This data originating from the Center for Disease Control (CDC) lists 83 Michigan counties and the prevalence of diabetes diagnoses from 2004 to 2013. A selection of counties from the 2013 was used to create the graph. All 2013 data was used to create the map.

R ggplot graph and Tableau visuals use data from the CDC, found at https://catalog.data.gov/dataset/500-cities-city-level-data-gis-friendly-format-845f9/resource/a1ba8579-235f-45f3-aff9-b7544a39ed58. The data set includes 500 cities across the United States and associated population health characteristics. The dataset was cleaned to only include city population from 2010 and prevalence estimates for those with no health insurance, a diabetes diagnosis, chronic kidney disease, and primary care visits.

3 Graphs

3.1 R Base Graph

The following graph is a visual representation of the prevalence of diabetes diagnoses in selected southeast Michigan counties for the year 2013.

Diabetes Diagnoses - Selected Counties

3.2 QGIS Map

The following map from QGIS depicts 2013 diabetes prevalence estimates by 83 Michigan Counties.

Michigan Diabetes Prevalence - 2013

3.3 GGPlot Graph

The following GGPlot graph depicts the percentage of population in selected U.S. cities with no health insurance.

U.S. Cities - No Health Insurance

3.4 Tableau Visuals

The following map from Tableau depicts estimated percent of annual check-ups for adults 18 and older, proportionate to city population.

Annual Check-Ups