Data-Driven Thinking

Analytics, Made Practical.

Real-world tutorials, templates, and notebooks — built by an analyst who's actually used them in production. No fluff, just results.

Your Timestamps Are a Staffing Model. You're Just Not Reading Them.

Every operation that logs when work arrives is sitting on a precise, data-driven staffing model. This notebook reads one datetime column — from any system, any industry — and tells you exactly when to staff up, when to staff down, and where your peak risk windows are. Includes a free Google Sheets template, full percentile distributions, an interactive day-of-week heatmap, and a self-contained HTML report you can email to anyone.

8 min read · Free template included Read Article

Hourly arrival volume — 24-hour distribution

Analytics · Case Study · Free Template

Pre/Post Go-Live Analysis: Automatically Detect Your Impact Date

Stop manually flagging go-live dates. This approach detects the inflection point from transaction volume alone and builds a rigorous before/after comparison on top of it. Free Google Sheets template and $299 Colab notebook.

10 min read Read Article

Lab Operations · TAT Analytics · Free Template

Stop Guessing Your Sendout Staffing. Let Your TAT Data Decide.

Every in-lab arrival timestamp in your LIS is a data point your staffing model is ignoring. Turn a single datetime column into hourly distributions, a day-of-week heatmap, and a shareable HTML report built for lab operations leadership.

10 min read Read Article

Templates · Excel

The Only Excel Dashboard Template You'll Ever Need

A clean, modular Excel framework that handles KPI tracking, trend analysis, and department-level drill-down — all without macros.

6 min read Coming Soon

Engineering · Python

Automated HTML Reports from Pandas: No BI Tool Required

Generate interactive, shareable dashboards straight from a Python script. We cover Chart.js integration, control charts, and multi-level drill-downs.

8 min read Coming Soon

Analytics · SQL

Writing Queries That Actually Get Read: Analytics SQL Style Guide

How to write SQL that your future self (and your teammates) will thank you for. Naming conventions, CTEs, and documentation patterns from 15 years in the field.

5 min read Coming Soon

Tools · Google Colab

Google Colab as a Business Intelligence Platform

You don't need Tableau. A well-structured Colab notebook connected to Google Sheets can handle most of what a small analytics team needs — and it's free.

7 min read Coming Soon