The journey of one question, and the chapter that covers each stage

Finance lead“What did we make on paid search?”AssistantWarehouse tablesWrites itsown formulaon the tables“£0 profit”Ch 1Semantic layerCh 3Request names the definition,the selected orders and the cutoffCh 4Access checkCh 6Who is asking?Checked beforeanything is calculatedDefinitionCh 3Ch 2Provisional contributionafter advertisingOwner: finance leadPaid-refund rule in forceRecorded by the data teamCutoffCh 5Facts recorded byFri 4 Sep 06:00What was known whenTransformation models you already have · they stay where they areCh 3£50provisional contribution after advertisingNot final profit · no cause claimedCh 7Basis: paid-refund rule · paid-search ordersaccepted 31 Aug–3 Sep · cutoff 4 Sep 06:00Ch 4Over time: versionsCh 85 Oct 00:00: the owner changes the rule → a new versionCurrent answers held until the new version is verifiedFriday’s £50 kept as historyDashboardsOtherassistantsCh 9Ch 10Start from the wrapper you have: replace its guesses one rule at a timeHead of data keeps the discipline; owners decide the meaningConclusion
Finance lead“What did we make on paid search?”AssistantWarehouse tablesWrites its own formula on the tables“£0 profit”Ch 1Semantic layerCh 3Request names the definition,the selected orders and the cutoffCh 4Access checkCh 6Who is asking? Checked beforeanything is calculatedDefinitionCh 3Ch 2Provisional contribution after advertisingOwner: finance leadPaid-refund rule in forceRecorded by the data teamCutoffCh 5Facts recorded by Fri 4 Sep 06:00What was known whenTransformation models you already have,which stay where they areCh 3£50provisional contributionafter advertisingNot final profit · no cause claimedCh 7Basis: paid-refund rule · paid-searchorders accepted 31 Aug–3 Sepcutoff 4 Sep 06:00Ch 4Over time: versionsCh 85 Oct 00:00: owner changes the rule→ a new version; current answersheld until it is verifiedFriday’s £50 kept as historyDashboardsOtherassistantsCh 9Ch 10Start from the wrapper you have:replace its guesses one rule at a timeHead of data keeps the discipline;owners decide the meaningConclusion

The whole route: the finance lead’s question passes an access check, the owner’s recorded definition and the cutoff, is calculated from the models already in place, and returns as £50 contribution, not profit, with its basis. The wrapper’s red “£0 profit” is the route the book argues against.

One question’s route through the book: a wrapper writing its own formula on the warehouse tables gives a confident, wrong answer, while an assistant that asks the semantic layer gets £50 contribution, not profit, checked for access, defined by its owner, fixed to a cutoff and returned with its basis, and the head of data keeps the discipline that holds that route together.

← Your AI Is Guessing by Gavin Somers