Based on a True Story
A blog presenting real analytical solutions I provided. The cases you’re about to read are inspired by actual events that happened in a real usage-based tech company. Certain field names and operational details have been altered to protect sensitive information. Any resemblance to a real business case is not coincidental - because it is one.
Cases
Case 1 - Defining Churn with SQL in a Usage-Based Company
No ML, no black box - just structured logic, decision thresholds, and a clean SQL solution.
Case 2 - Predicting the Present
How time-series counterfactuals reveal the true impact of business changes.
Case 3 - Because Your MoM and YoY Lie
A practical module for cutting through seasonal noise in analysis and modeling.
Case 4 - Because Not All Days Are Created Equal
A SQL-based AvT allocation model for nonlinear month-to-date performance.
Range Against the Machine
A blog where a business analyst challenges AutoML using feature intuition, context-aware modeling, and domain reasoning - proving that sometimes, knowing your business domain matters more than brute force.
Cases
Case 1 - The Model That Outsmarted AutoML
A PCA-driven rethinking of the Boston Housing classic.
Case 2 - Beating AutoML by Looking Under the Hood
Used-car pricing prediction with business signals, not just buttons to click.
Theory, Made Useful
Concepts, models and methods explained without the textbook.
Explainers
Explainer 1 - If a Decision Tree Falls in a Random Forest and no One is Around to Hear - Did it Make a Sound?
On trees, forests, and the noise between them
Explainer 2 - Explaining PCA Like a Hollywood Casting Director
A fun visual guide to Principal Component Analysis using movie stars and screen chemistry
Explainer 3 - When Means Don’t Mean a Thing
When chasing the mean leaves your job performance below average