Joon Han | Digital Diagnostics
Python Analysis
A collection of case studies using Python to clean data, segment patterns, and diagnose business questions beyond surface-level metrics.
These projects show how pandas-based analysis, validation, and structured comparison can reveal hidden variation that a single KPI would miss.
Pandas · Segmentation · Data Validation · Diagnostic Analysis · Visualization
When SaaS Activation Looks Stable Until You Segment It Analysis
Focus:
Python · Pandas · Segmentation · Activation Analytics
A Python case study examining how subscription activation quality shifted across referral source and plan tier, despite a stable headline activation rate.
Key insight:
The overall activation rate looked stable at 50.92%, but segmentation showed that activation quality varied by referral source and plan tier. The average hid meaningful differences in where stronger activation environments were forming.
Turning Campaign Metrics Into Budget Decisions
Focus:
Python · Excel Workflow · Budget Review · Campaign Performance
A Python case study showing how campaign metrics were transformed into budget action using ROAS, CPA, profit, and conversion signals.
Key insight:
High spend alone did not determine budget priority. The analysis separated campaigns ready for increased budget from campaigns that needed review, control, or reduction based on performance efficiency.