Confusion-Adjusted Engineering Time (CAET)

An empirical study of ‘Can You Pull This Real Quick?’

Stakeholder confusion
6.5 / 10
Predicted time cost
3 hrs
😵 ‘Quick question’
2 hours. Somehow this needs a new model.
How confused everyone is →Time I spend on it →
“Can you just pull
that real quick?”
“Why does this differ
from Finance?”
“Board deck needs
this in 20 minutes”
Current point
Confusion6.5
Time3 hrs
Built with equal parts: SQL, duct tape, and vibes.
Stakeholder confusion
6.5 / 10
Predicted time cost
3 hrs
😵 ‘Quick question’
2 hours. Somehow this needs a new model.
How confused everyone is →Time I spend on it →
“Can you just pull
that real quick?”
“Why does this differ
from Finance?”
“Board deck needs
this in 20 minutes”
Current point
Confusion6.5
Time3 hrs
Built with equal parts: SQL, duct tape, and vibes.

What I do all day

What I do all day

Real-time operational metrics form the Business Intelligence System

Real-time operational metrics form the Business Intelligence System

Queries written today
18
Slack pings
34
Quick questions
6
Experiments shipped
3
Manual processes remaining
7
Hours saved via automation
11h
BI Trust Score
82%
Sanity (30d trend)
Source: Snowflake + duct tape + vibes
Queries written today
18
Slack pings
34
Quick questions
6
Experiments shipped
3
Manual processes remaining
7
Hours saved via automation
11h
BI Trust Score
82%
Sanity (30d trend)
Source: Snowflake + duct tape + vibes

Pipeline Playground

Pipeline Playground


Hover nodes for “documentation”.


Hover nodes for “documentation”.

Extract
Transform
Test
Serve
RAWELTSTGDBTTESTSDWHBIOPSCSVeventdealinvoicespvcsv
If it breaks, it’s either “a one-line fix” or “a metrics layer discussion”. There is no middle.
Extract
Transform
Test
Serve
RAWELTSTGDBTTESTSDWHBIOPSCSVeventdealinvoicespvcsv
If it breaks, it’s either “a one-line fix” or “a metrics layer discussion”. There is no middle.