Projects //
10 case studies
All projects
Pipelines, warehouses, dashboards and models. Open any project for a short visual case study.
- Six county charts draw Census and USPS vacancy rates from 2011 to 2024, mark the 2012 USPS redefinition, and note that the pooled correlation is 0.77, but within a county it ranges from 0.72 to −0.01.
01 // Data engineering · 2026 · Power BI
Can Mail Data Predict Housing Vacancy?
Does USPS vacancy track the Census rate, county by county?
Open case study - Row counts flow from Bronze (10 million transactions, 131 million lines) to Silver (3.3 million completed orders, 1.58 million failing the header-total check) to Gold (43.8 million fact rows).
02 // Data engineering · Jul–Aug 2025
Grocery Transaction Data Warehouse
A Medallion warehouse over 131M+ rows, in plain SQL Server
Open case study - Bars fill toward each district’s 2022 plan; the chain reached 5.90 billion VND of a 6.43 billion plan, 91.7%.
03 // Analytics · Aug 2025 · Power BI
Sales Planning Analysis
Who is on plan, and where targets are at risk
Open case study - Lancaster and Pennsylvania unemployment rates draw from 2015 to 2025; Lancaster stays below the state every year, 7.3% vs 8.9% in 2020.
04 // Analytics · 2026 · Power BI
Lancaster County Economic Indicators
Benchmarking a county economy against the state and the nation
Open case study - Dots representing 18.4 thousand customers sort into segments: 42% At-Risk, 26% Growth, 21% Standard, 10% Premium.
05 // Analytics · 2025 · Power BI
RFM Customer Segmentation
Turning every customer segment into a concrete action
Open case study - A data-quality bar shows 87.7% complete rows, 12.3% missing a field, and 17 invalid currency codes, then credit bands show Poor-credit accounts hold 51.4% of transaction value.
- 1,338 policyholders split into three cost bands by smoking and obesity, and R-squared rises from 0.09 (age and sex) to 0.75 (all predictors) to 0.86 (with the smoker × obese interaction), with 0.88 on held-out data.
07 // Machine learning · Oct 2026
Medical Cost Modeling and Prediction
Which factors are associated with medical costs, and where does the model fail?
Open case study - Error bars: 13.1% under random and time splits, 18 to 38% when a whole region is held out.
08 // Machine learning · 2026
Melbourne Housing Price Prediction
Does the way you test a model change the answer?
Open case study - Reusing last year’s Census vacancy rate gave the lowest error (1.023 points) among the models compared, ahead of ridge (1.054). Its 80% intervals cover 81% overall but only 57% in Champaign.
09 // Machine learning · Oct 2026
Can a Model Nowcast Census Vacancy from Mail Data?
An honest evaluation: in forward-chaining, the test that matches real use, no model beat last year’s number.
Open case study - Data flows from netflix_titles.csv through extract.py into MySQL dimension, fact, and link tables, then into a Power BI report.
10 // Data engineering · Early project
Netflix Titles ETL
An early ETL: one CSV into a normalized MySQL model
Open case study