Featured

Illinois Health Vulnerability Dashboard

An analysis of health vulnerability metrics such as provider availability and at-risk group prevalence, with a goal of identifying vulnerable counties and creating an intervention list that will be used to focus efforts on areas that will have a high impact.

Healthcare Tableau Visualization Public Health

Interactive Dashboard

Interactive Tableau Dashboard Open in Tableau

Overview

This dashboard analyzes health vulnerability across Illinois counties by examining provider availability, at-risk population prevalence, and other key health indicators. The goal is to identify the most vulnerable counties and prioritize intervention efforts where they will have the greatest impact.

Key Features

  • County-Level Analysis: Drill down into individual Illinois counties to compare vulnerability scores
  • Provider Availability: Visualize gaps in healthcare provider coverage across the state
  • At-Risk Population Metrics: Identify concentrations of elderly, low-income, and chronically ill populations
  • Intervention Prioritization: Rank counties by composite vulnerability score to guide resource allocation

Tools & Technologies

  • Tableau Desktop for dashboard design and interactivity
  • Public health datasets from Illinois state health agencies
  • Data blending to combine multiple source datasets into a unified view

Insights

The analysis highlights significant disparities in healthcare access across Illinois, with rural counties in the southern and western regions showing the highest vulnerability scores. Counties with low provider-to-population ratios and high proportions of elderly residents represent the highest-priority intervention targets.

Data Sources

Data was sourced from publicly available Illinois Department of Public Health records, U.S. Census Bureau demographic data, and CMS provider enrollment datasets.