U.S. COVID-19 Hospital Capacity & Utilization Analysis

As part of the SQL course, my team and I analyzed a large-scale dataset on U.S. COVID-19 Hospitalizations and Capacity from 2020 to 2024 to uncover key healthcare trends and resource utilization across states 🏥 😷 🛏.

- Managed a complex dataset with nearly 1 million records and 128 columns.
- Cleaned, transformed, and aggregated data using SQL and Excel.
- Joined external datasets (e.g., population by state) to enrich analysis.
- Visualized insights using Tableau to track bed usage and identify regional risk patterns.

This project challenged us to handle real-world data with technical constraints, long field names, import issues, and missing dimensions, while building practical skills in data wrangling, analysis, and visualization. By examining trends in hospital bed usage and COVID-19 cases, we provided actionable recommendations to support public health officials and policymakers in allocating resources and improving outbreak preparedness.

Datasource:
- https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/anag-cw7u
- https://github.com/cphalpert/census-regions/blob/master/us%20census%20bureau%20regions%20and%20divisions.csv
- https://www.census.gov/data/tables/time-series/demo/popest/2020s-state-total.html