Data Investigations

Data Investigation Tracker: From Anomaly to Resolution

Metric anomalies rarely get resolved. They get Slacked, debated, and forgotten — leaving the root cause undocumented and the next investigation starting from scratch. This template brings Austin Hay's RFC investigation framework from Ramp to your analytics team. Each investigation gets a structured record with RACI ownership, a required bias checklist before any hypothesis is written, and status tracking that surfaces blocked investigations before they stall. The workbook covers every phase: confirm the signal is real, assign ownership, document the hypothesis, record the findings, and close with a reviewed resolution type. The Investigations Board shows every open, in-progress, and blocked investigation at a glance. Designed for analytics leads and senior analysts at B2B SaaS and fintech companies running recurring data quality investigations across product events, marketing attribution, revenue data, and infrastructure pipelines.

Data Investigation Tracker: From Anomaly to Resolution