Technical Dives

Architecture, tooling, and the decisions behind building data systems that hold up under pressure.

Your Data Is Dirty and That's Fine

ERP exports break in predictable ways. Here's how the OIM handles the full range of it. From encoding errors at the gate to null values that make it all the way to the dimension table.

technical-dives

Industrial Grade Analytics

A six-layer architecture that never needs its SQL touched. Here's how config-driven design, dimensional modeling, and a parametric targeting engine converge.

technical-dives

The Stress Harness

25 runs. 76 million rows. Zero failures. How I built the adversarial test that earns the right to call the OIM production-ready.

technical-dives

Why Dash

I knew Power BI better than almost anyone. That's exactly why I walked away from it.

technical-dives

First 50M Row Run

2.5M rows was the proof of concept. 50M rows in under two hours on a laptop was the proof it was real.

technical-dives

Why DuckDB

The OIM started as a Power BI template. Power Query was the plan. Then I hit a wall and found the tool that changed everything.

technical-dives