analytics
Sälka Designs: Automated ETL Pipeline
Serverless ETL pipeline that automatically ingests Squarespace order data, validates quality, and delivers weekly production reports via email.
Blog
Projects, case studies, and technical writing
analytics
30-Day Readmission Analysis
Exploring patient characteristics associated with hospital readmission rates in a heart failure cohort using synthetic EHR data.
analytics
Length of Stay Analysis
Analyzing patterns in hospital length of stay using CDC discharge data to understand what drives variation in inpatient stays.
analytics
ED Timeliness of Care Analysis
Analyzing emergency department wait times and patient flow using CMS Hospital Compare data across 4,000+ U.S. hospitals.
analytics
U.S. Debt Analysis Project
U.S. federal debt trend analysis using Excel pivot tables, XLOOKUP functions, and ETS forecasting
analytics
UFoods Marketing Campaign Analysis
Customer segmentation and campaign effectiveness analysis identifying high-value customer profiles and optimizing marketing strategy.
analytics
Building a Production Data System: Lessons from TidyTrek
A case study on schema design, aggregation logic, and performance tradeoffs from building a full-featured web application.