Featured Projects
Hospital-Acquired Infections Quality Improvement Analysis (August 2026)
Built an end-to-end healthcare quality improvement project using a fully synthetic 2024 inpatient dataset spanning patient encounters, Foley catheter and central-line exposure, infection-surveillance records, and device-maintenance audits. The project moved from relational dataset creation and intentional data-quality issues through SQL-based cleaning, surveillance review, process measurement, and Tableau visualization.
Used SQL to validate relationships, standardize unit names, reconcile device exposure, calculate device-days, screen infection-surveillance records, and create analytical CAUTI and CLABSI candidate rates. A separate maintenance-audit dataset was used to evaluate individual bundle elements and all-or-none bundle compliance.
Developed a four-dashboard Tableau report connecting outcome, process, exposure, and data-quality measures to identify improvement priorities, explore possible drivers, review candidate-event context, and translate findings into a structured quality-improvement plan.
Tools Used: Python | Google BigQuery / SQL | Google Sheets | Tableau Desktop | Tableau Public
Hospital Falls Analysis and Recommendations (August 2026)
Utilizing a synthetic EMR dataset of 85 fall events across four major Chicago health systems, this project establishes an end-to-end data analytics pipeline to uncover clinical, temporal, and operational drivers of patient harm. Designed as a self-imposed challenge to sharpen technical skills and expose platform weaknesses, complete data cleaning, feature engineering, and interactive dashboarding workflows were executed independently in both Google Sheets and Google BigQuery (SQL), culminating in an interactive visualization storyboard on Tableau Public.
Completed all data cleaning and preparation processes indepedently in both Google Sheets and SQL, designed a Google Sheets Dashboard, and designed an Interactive Tableau Dashboard investigating falls across four Chicago-based hospitals. Identified baseline risk factors such as functional status and cognitive status, temporal risk factors, root cause analysis, and created a list of recommendations to reduce fall risk when providers are not present in patient rooms
Tools used: Chat GPT (to create synthetic dataset) | Google Sheets | BigQuery (SQL) | Tableau Public
County Health Rankings and Roadmaps (August 2026)
The County Health Rankings & Roadmaps framework provides vital nationwide benchmarks for evaluating public health outcomes, socio-environmental factors, and clinical performance. This project establishes an interactive, data-driven analytics ecosystem that evaluates the intersection between behavioral risk factors, physical environments, and long-term health outcomes across more than 3,000 U.S. counties.
By engineering a data model in Google BigQuery (SQL) using zero-padded geographic concatenation and designing a dual-parameter, multi-dimensional Tableau Dashboard, this case study enables public health officials, epidemiological researchers, and quality assurance officers to isolate localized health disparities, track historical trajectories across shifting multi-year rolling intervals, and uncover high-leverage socio-environmental correlation trends.
Tools used: BigQuery (SQL) | Tableau Public | Google Cloud Storage
Illinois Healthcare Quality & Patient Experience Analysis (July 2026)
The HCAHPS patient survey and CMS star ratings serve as national benchmarks for evaluating hospital quality, patient satisfaction, and clinical performance. This project establishes an interactive, data-driven framework analyzing the intersection between patient-reported experiences, institutional quality ratings, and 30-day clinical readmissions across 194 Illinois healthcare facilities.
By engineering a wide-format data model in Google BigQuery (SQL) and designing a parameter-driven interactive Tableau Storyboard, this case study enables hospital executives, quality assurance officers, and clinical leadership to evaluate patient satisfaction performance, isolate patient-perception vs. clinical performance silos, and identify high-leverage communication strategies for post-discharge care.
Tools used: BigQuery (SQL) | Tableau | Google Sheets
National Physical Therapy Exam Performance Analysis (July 2026)
The National Physical Therapy Examination (NPTE) serves as the benchmark entry-to-practice credential for Physical Therapists (PT) and Physical Therapist Assistants (PTA) across the United States. This project establishes an interactive, data-driven framework analyzing institutional performance, class-size dynamics, regional variances, and pass-rate trajectories across 683 academic programs.
By engineering a consolidated data model in Google Sheets, Google BigQuery (SQL), and designing an interactive Tableau Storyboard, this case study enables educational leaders, accrediting bodies, and health system recruiters to benchmark institutional outcomes, identify top-tier programs, and pinpoint institutions requiring targeted academic resources.
Tools used: Google Sheets | BigQuery (SQL) | Tableau
North Carolina County Health and PT Workforce Trends (July, 2026)
Capstone for Google Data Anayltics Certificate
This project investigates physical therapy (PT) and physical therapy assistant (PTA) workforce dynamics and community health disparities across North Carolina's 100 counties from 2000 - 2024. Using Python, BigQuery SQL, and Google Sheets to prepare data and Tableau to create a four-dashboard layout, this project isolates workforce volatility and highlights retention challenges in rural, low-income healthcare markets. The resulting model provides high level insight for healthcare organizations, public health agencies, and insurance companies with insights related to retention incentives to improve regional quality of care.
tools used: Python | BigQuery (SQL) | Google Sheets | Tableau
County Health and Cardiovascular Mortality Rate (June, 2026)
Analyzed county-level CDC PLACES and CDC WONDER data to examine relationships among leisure-time physical inactivity, coronary heart disease, stroke, arthritis, mobility disability, and cardiovascular/circulatory-system mortality across the United States. The analysis also identified extreme-value counties, overlapping health-metric outliers, and areas where small population size may make mortality rates less stable.
Built a complete analytics workflow using BigQuery, Google Sheets, and Tableau Public. The final interactive Tableau story combines county maps, outlier classifications, population-based filters, diagnostic tables, and linear trend models to move from national patterns to county-level investigation while clearly separating correlation from causation.
Tools Used: BigQuery (SQL) | Google Sheets | Tableau Public
Bellabeat Case Study (June, 2026)
Google Data Analytics Capstone analyzing Fitbit activity, sleep, and feature-use patterns, supplemented by exploratory wellness data, to identify opportunities for Bellabeat's marketing and user-engagement strategy.
Findings supported recommendations around sleep and stress messaging, day-specific engagement, and onboarding that encourages users to take advantage of multiple wellness-tracking features.
Tools Used: Google Sheets | BigQuery (SQL) | Google Slides
Fun/Leisure Projects
Hollywood Performance Analysis (August 2026)
Evaluted Hollywood film performance from 2007 - 2011 detailing gross worldwide earnings, profitability, audience scores, and critic scores
Created an interactive dashboard to filter by genre and primary studio to evaluate differences across the filmmaking industry
tools used: Google Sheets | Tableau
Footwear Durability and Economic Analysis: Goodyear-Welted vs. Cemented Construction (August, 2026)
Comparing durability, price-per-wear, and economic analysis of higher front-end cost Goodyear-Welted footwear vs. cheaper cemented construction
Created with synthetic dataset developed from Python in JupyterLab
tools used: Python | Tableau
Pierogi Fest 2026: Festival Intake Analytics
Exploratory event logging and KPI visualization project comparing two peers' weekend pierogi intakes
tools used: Google Sheets | Tableau