learn-asking-right-questions-as-de-with-phoebe / Session 1 of 6
Learn Asking the Right Questions as a Data Engineer with Phoebe · Session 1 of 6

The gap, from the engineer's chair

An operations director says "our numbers never match. Finance says one thing, the POS says another." A data engineer hears a join, a sync, a reconciliation job, and starts sketching one. A few weeks later there is a nightly pipeline that copies both numbers into one place, on time, every night, and they still disagree by the same amount, because the thing she was worried about was an auditor's letter asking which number was right, and the pipeline never decided. Nobody was careless. They used one word for two things. Tonight is how to notice: why the gap opens, why the data-state door is your widest but never your first, and the one sentence that lets her learn how data work thinks while she is answering you.

🟡 Core Data engineers, and anyone asked to "connect the systems" No code. A pen. 45 min
0-3 · Welcome 3-18 · Two tunes, door 4, the teach-back 18-40 · Build-along: the engineer's sheet 40-45 · Q&A
Part 0

Where we start

An engineer's output is a pipeline other people trust without checking. That makes the first meeting more dangerous for you than for anyone else in the data team: a wrong assumption in an analyst's chart is visible on the page, but a wrong assumption in a pipeline runs every night, quietly, and gets copied into everything downstream. The running case for all six sessions is Harbourline, an invented chain of 38 pharmacy and clinic outlets across Singapore and Malaysia, and its operations director Adeline Tan, who has never seen a schema and does not need to. She has a request. You have 45 minutes with her. Everything in the six sessions is about what you ask in those minutes, so that what you build settles which copy is real instead of moving the disagreement faster.

🎫 Clear all three quiz questions to stamp your passport Live = presented in the 45 minutes Self-study = the full depth, after class ★ Build-along = write it yourself

★ What you walk out with tonight. A one-page Six Doors sheet for "our numbers never match", or for a request of your own: the data-state row written widest, the outcome question placed first, with the reason beside it, a plain teach-back line attached to every question, and the order you will walk them in. Session 3 puts that sheet in front of Adeline and counts what it gets out of her.

Part 1 · covers why the gap opens

Two tunes, and the word match

5 min live

In a 1990 Stanford study reported by Chip and Dan Heath, Elizabeth Newton split people into tappers and listeners. Tappers tapped the rhythm of a well-known song on a table; listeners had to name it. Tappers predicted listeners would get about half. Listeners got 3 of 120. The tapper cannot stop hearing the tune, so the taps sound obvious; the listener hears knocking. When Adeline says "match" she is tapping a tune you cannot hear, and when you answer with a word like "reconcile" you are tapping one she cannot.

ONE SENTENCE, TWO TUNES "our numbers never match" means a different thing on each side of the table THE AUDITOR'S LETTER Which number is right? finance and the POS differ by about 2 percent, every month, and she could not tell him her tune: an answer she owes by name Adeline "match" pos_sales ledger a join, a sync, a reconciliation job his tune: two tables and an arrow the engineer WHAT GETS BUILT IF NOBODY NOTICES a nightly job that copies both numbers into one warehouse, faster; the 2 percent and the letter remain
🔍 Click to zoom - the teal letter is the request; the two tables are only the engineer's word for it
LiveThe tune behind "match", and why neither side can hear the other's3 min▶

Newton's tappers were not bad at tapping. They could not un-know the song while they tapped, so every knock arrived with the melody attached, and they judged the listener's chances from inside that experience. Economists had named the effect a year earlier: Camerer, Loewenstein and Weber called it the curse of knowledge, the finding that better-informed people cannot fully set their information aside when predicting what less-informed people will understand.

"Match" carries two tunes. Adeline's is the letter on her desk: last month the auditor asked which revenue number was right, in writing, and she could not answer him. Her "match" means "one number I can defend, by a date, to a person". The engineer's tune is the machinery: two tables, a key to join them on, a job that runs nightly. His "match" means "the rows line up". Both are real. Only one of them is the request.

The gap is not closed by either side learning the other's vocabulary. It is closed by questions that make the tune audible: the last time two numbers did not match, which two, who noticed, and what happened next, asked in words that need no translation, with the reason for asking said out loud. That is the rest of tonight.

Self-studyWhy the engineer's version of the gap is the expensive one2 min▶

An analyst who misreads the request ships a chart nobody opens. It is visible, it is cheap to throw away, and the next meeting starts from the embarrassment. An engineer who misreads it ships a pipeline, and a pipeline does not look wrong. It runs green every night. It loads two numbers that disagree into one table, where they now disagree faster, in more places, with a timestamp that makes both look official. The disagreement has not been settled; it has been automated.

That is the failure every page in these six sessions is written against: a pipeline that moves the disagreement faster instead of settling which copy is real. The engineering is rarely the hard part. Deciding which copy is real is a business decision, it needs facts only Adeline and her team hold, and the first meeting is the only cheap place to get them.

Real world

The integration that stalled. Harbourline is a constructed case, but this shape is common enough to be a pattern. Two years ago a vendor ran an "integration" project to connect Harbourline's systems. It stalled the week Kenneth, the only IT person, went on leave, and it never restarted. Whatever else went wrong, the stall says the whole project hung on one person, and a person is the one single point of failure nobody draws on a system diagram. Adeline only mentions it once she trusts you, and only if you ask whether they have tried this before. It is the single most useful fact for predicting where your project will stall, because it is usually the same place.

Part 2 · covers the widest door

The data-state door, opened widest, but not first

6 min live

Every discovery meeting is a corridor of six doors: Outcome · Decision · Current way · Data state · Constraints · Success and partnership. The corridor, and the question that opens each door, is drawn once in the analyst's session 1; walk it there if you have not. Tonight spends its minutes on door 4, data state, because it is where an engineer's work is decided: every system a number passes through, who can log in to each, how often each is read, and which copy is declared real. It is your widest door. It is not your first.

ONE SALE, FOUR SYSTEMS, EVERY HAND-OFF NUMBERED each numbered arrow is a place the number can change the timing gap 1 2 3 4 5 the till (POS) one cloud vendor, CSV per outlet; API never used bank settlement cards: 2 days late cash: weekly deposit the ledger outsourced bookkeeper in Kuala Lumpur; refunds only here finance's number one export a month, booked by the 5th working day the POS number 38 CSVs on Monday, a 2019 macro merges stock sheet three copies in use; Priya's laptop copy route unknown: ask about 2 percent between the two numbers, every month; mostly timing hand-off 1 is where most of it lives At hand-off 1 a card sale waits two days and cash waits a week. Both numbers are true of different days.
🔍 Click to zoom - count the arrows, not the boxes; the teal one is where the two numbers part company
LiveOpen questions first, because door 4 holds the sensitive facts3 min▶

The instinct is to open with the systems, because the systems are what you will touch. Resist it for three questions. Door 4 is where the facts people guard live: who holds the only login, which copy of a file is actually used, who fixes numbers by hand without telling anyone. Adeline does not hand those to a stranger who opened with "what is your stack". She hands them to someone who has shown they understand what she is worried about.

So the first question is an outcome question in the past tense: "Tell me about the last time two numbers did not match. Which two, how far apart, and who noticed?" Its teach-back: "A mismatch is two systems answering two different questions. I need the exact pair before I can say which one is right." In four or five minutes you learn which mismatch matters (month-end revenue, about two percent, and an auditor who has now asked in writing), you earn a notch of trust, and every data-state question after it lands on a warmer table.

On Adeline's sheet the most sensitive data-state fact, that Kenneth is the only IT person, holds the only POS admin login, and is leaving in January, needs the highest trust of anything she knows. She has not told her own team. Asked cold, "who can log in?" gets you a name. Asked after trust, it gets you the risk.

LiveThen every system one sale touches, and which copy is real3 min▶

Once she trusts you, open door 4 wide and walk one sale through it: "Which systems does one sale touch, from the till to the bank to the ledger?" At Harbourline the answer is a cloud POS with a CSV export per outlet and an API nobody has used; a bank that settles cards two days late and receives cash weekly; a ledger in a cloud accounting package run by an outsourced bookkeeper in Kuala Lumpur, who exports once a month; and, off to the side, a stock spreadsheet. Then ask how often each is read today and by whom, because that frequency is a ceiling you inherit until a contract or a login changes it.

Leandro DalleMule and Thomas Davenport's 2017 frame for data strategy, as reported, sets a single source of truth against multiple versions of the truth, each fit for a purpose. Both are legitimate designs. What is never a design is having several versions by accident with nobody saying which one wins, and that is Harbourline: finance's number and the POS number are both honest, built along two paths, and nobody has declared which one the auditor gets. The engineer's job at door 4 is not to pick. It is to find out who can decide, and to get it decided before anything moves.

Self-studyWhere the business sits, and why the first build is small2 min▶

Joe Reis and Matt Housley, in Fundamentals of Data Engineering (O'Reilly, 2022), describe organisations as starting with data, scaling with data, or leading with data, and argue the engineering should fit the stage; the framing here is as reported, not read chapter by chapter. Harbourline is plainly starting: 38 CSV files pasted on Monday, a 2019 macro, one IT person, no budget this quarter. A starting business does not need a platform first. It needs one declared real copy of one number, reproduced exactly, with a second person who knows how it is made.

That is also why data state is asked in plain words. Session 2 turns door 4 into a ladder of questions that a person who has never seen a schema can answer, and draws the system map from her replies.

Real world

Three copies of one spreadsheet. In the same constructed case, three versions of the stock spreadsheet are in circulation, and the one Priya treats as real lives on her laptop. A leading question ("stock lives in the POS, right?") gets a polite "sure" and puts a false belief in your notes. An open one ("where do the stock numbers live, and which copy is the real one?") gets the laptop, and a teach-back worth saying out loud: "A file that exists three times has no real copy until someone declares one. I need that declared before I move it anywhere."

The order is worth measuring. On session 3's bench, the same questions in any order at all average 27.6 points (the shuffles range from 5 to 45); walked door by door they score 47; tuned for an engineer, three trust-earning questions and then data state widest, they score 51. The ordering is the finding. The numbers belong to a constructed company, not a real one.

Part 3 · covers the teach-back line

The teach-back line for an engineer

4 min live

Every open question in the bank carries a second sentence: a plain statement of why you are asking. Said out loud before the question, it does three things at once. It turns the question into a reason rather than an interrogation, it earns trust, and it teaches Adeline one true thing about how data work is decided. An engineer's teach-back lines are mostly about hand-offs, logins and timing, which are exactly the things she has never had explained and most needs to understand before she can decide which copy is real.

ONE QUESTION, TWO SENTENCES, THREE THINGS BACK THE QUESTION "Where does finance's revenue number come from, step by step?" THE TEACH-BACK "Two numbers built along two paths usually disagree about timing long before they disagree about truth." the engineer A fact comes back "Card settlements land two days late and cash is deposited weekly." A lesson stays with her a mismatch is usually timing, not truth trust, one notch up She only explains settlement timing once she trusts you. The second sentence is how the trust gets there.
🔍 Click to zoom - the teal box is the part of the meeting that outlives it
LiveThree lines an engineer says in almost every meeting2 min▶

A teach-back line is plain: no word she would have to ask about, so "the file" not "the extract", "log in" not "credentials", "two days late" not "latency". It is true: a real principle of the craft, not a pleasantry. And it is one sentence, because two is a lecture and she stops answering. These three carry most of door 4.

Before "Which systems does one sale touch, from the till to the bank to the ledger?": "Every hand-off between systems is a place a number can change. I am counting the hand-offs."

Before "Who can log in to each of those, and pull an export?": "Access is the first blocker on most data projects, so I ask early and I ask by name."

Before "Where does finance's revenue number come from, step by step?": "Two numbers built along two paths usually disagree about timing long before they disagree about truth." Said to Adeline, that last one changes the meeting. She came in believing one side was wrong. She leaves knowing that both may be right about different days, which is the first step to deciding which day the auditor gets. Session 4 builds the rest of the set and chooses the one concept per meeting worth explaining properly.

Self-studyJargon and leading questions, the engineer's two habits2 min▶

Session 3 sorts every question into five kinds: open, closed, vague, jargon and leading. Engineers are most exposed to two. Jargon is the question you would ask a colleague: "Do you have change data capture on the POS, or should we batch?" It costs minutes while she works out what you mean, and it costs trust, because she is now a little less sure you understand a pharmacy. Leading questions are the dangerous kind because they feel efficient: "The POS is the source of truth, right?" gets a "sure", and a belief that is wrong goes into your notes. On this bank the POS is not the source of truth; the two percent is settlement timing.

The fast yes-or-no interview on the bench records five false beliefs of exactly this shape, and each one is a thing you would build on: pull everything daily, the vendor API is in use, finance is simply wrong, stock lives in the POS. Six weeks later each is a pipeline that is correct about a world that does not exist.

Real world

The two percent that was not an error. Still the constructed case. Adeline has spent months treating the gap between finance and the POS as somebody's mistake. It is mostly timing: card settlements reach the bank two days after the sale, cash is deposited weekly, and refunds are processed in the accounting system, which the POS never sees. A reconciliation job built on "finance is wrong" would have flagged the same honest difference every month, forever. A single question about where finance's number comes from, asked with its reason, turns a blame problem into a definition problem, and definitions can be decided.

Build-along

The engineer's sheet for "our numbers never match"

★ 22 min · everyone writes

One page, six rows, one of them wider than the rest. Use Adeline's request, or a "connect the systems" request from your own inbox, and build the sheet you will carry into the meeting. Every line is written before the meeting; the meeting is for listening.

THE SHEET, ONE PAGE, WRITTEN BEFORE THE MEETING in her words: "Our numbers never match. Finance says one thing, the POS says another." DOOR OPEN QUESTIONS, PAST TENSE TEACH-BACK, ONE LINE EACH 1 Outcome last time two numbers differed? a mismatch is two questions 2 Decision month-end: who decides, by when? whose definition wins, and when 3 Current way where does finance's number start? two paths: timing before truth 4 Data state widest which systems does one sale touch? who can log in and pull an export? which copy is real? how often read? same product codes in SG and MY? I am counting the hand-offs access first, and by name three copies means no real copy two names break a total 5 Constraints what is off the table? limits first, so I propose a yes 6 Success tried this before? what happened? the last attempt shows the stall first: the outcome question, to start widest: door 4, asked once trust is earned Three open questions buy the trust the most guarded answers behind door 4 need.
🔍 Click to zoom - the teal row is three rows tall because it is where an engineer's build is decided

Write the request as it was received, in her words. Not your translation. If it arrived as "our numbers never match", do not write "reconcile POS and ledger". You will want her sentence back at the end of the meeting, to see how far the real request was from it.

★ Step 1 · the requestRequest, verbatim: "Our numbers never match. Finance says one thing, the POS says another, and last month the auditor asked which one was right. I could not tell him." From: Adeline Tan, operations director Received: in the first two minutes of the meeting

Place the outcome question first, and write the reason beside it. The reason is for you, not for her: it stops you skipping the question when the systems start to look interesting.

★ Step 2 · the first question and why it is firstQ: Tell me about the last time two numbers did not match. Which two, how far apart, and who noticed? Teach-back: A mismatch is two systems answering two different questions. I need the exact pair before I can say which one is right. Why first: it tells me which mismatch matters, it costs her nothing sensitive, and it earns the trust that "who can log in" needs later.

Write the data-state row widest: four or five questions, each with its teach-back. Every system one sale touches, who can log in, how often each is read, and which copy is real. Write them so a person who has never seen a database can answer every one.

★ Step 3 · door 4, opened widestWhich systems does one sale touch, from the till to the bank to the ledger? Why: Every hand-off between systems is a place a number can change. I am counting the hand-offs. Who can log in to each of those, and pull an export? Why: Access is the first blocker on most data projects, so I ask early and I ask by name. Where do the stock numbers live, and which copy is the real one? Why: A file that exists three times has no real copy until someone declares one. How often does each system get exported today, and by whom? Why: How often a system is read today is a ceiling I inherit until a contract or a login changes it.
The same door, as it is usually openedDo you have change data capture on the POS, or should we batch? What is the SLA on the ledger sync? The POS is the source of truth, right?

Write the order you will walk tonight. One outcome question, a question each at decision and current way so you know whose number wins and how it is made today, then door 4 widest, then the rest. Session 3 runs exactly this order against Adeline and counts it.

★ Step 4 · the order for tonight1 Outcome (one question) -> 2 Decision (one) -> 3 Current way (one) -> 4 Data state (four or five, widest) -> 3 again: where finance's number comes from -> 6 Success -> 5 Constraints Budget: 45 minutes. The first eight questions take about half an hour. Everything after that is spares.

Rehearse the first thirty seconds against her opener. Say your first question out loud with its teach-back. If it took more than twenty seconds, it is two questions; split it.

★ Step 5 · the first thirty secondsAdeline: "Thanks for coming. Our numbers never match. Finance says one thing, the POS says another, and last month the auditor asked which one was right. I could not tell him." You: "Before the systems, can I ask about that month? Tell me about the last time two numbers did not match: which two, how far apart, and who noticed? A mismatch is two systems answering two different questions, and I need the exact pair before I can say which one is right."

Keep the sheet after the meeting. Session 2 turns the door 4 answers into a map of every system a number passes through, session 5 turns her answers into three candidate projects, and session 6 turns the filled-in sheet into the one-page brief you send within 24 hours. The same page carries all of it.

Homework

Before session 2

30 min
  1. Finish the sheet for your request: the outcome question first with its reason, the data-state row widest, a teach-back line on every question, and the order. Bring it printed; session 3 puts it on the bench.
  2. Find the tune. For a "numbers never match" request of your own, write what you think "match" means to the person who said it: whose question does the mismatch stop them answering, and by when? Then write what it meant to you when you first heard it.
  3. Count the hand-offs in one number you already move. Follow one record from where a person or a till creates it to where someone reads it, and number every hand-off. Mark the one where timing differs most.
  4. Find the declared copy. For one file or table you load today, find out who, by name, declared it the real one. If nobody did, write that down; session 2 starts there.
Check yourself

Three questions

Clear all three and session 1 gets stamped in your passport.

1 · Adeline says "our numbers never match". Why is "match" two questions, not one?

The curse of knowledge runs both ways. Neither reading is wrong, and neither side notices the other one. A nightly job that loads both numbers into one warehouse satisfies the engineer's "match" and leaves the auditor's letter unanswered.

2 · Data state is the engineer's widest door. Why do open questions from other doors go before it?

On Adeline's sheet, the fact that Kenneth holds the only POS admin login and leaves in January needs the most trust of anything she knows. Asked cold, "who can log in?" gets a name. Asked after trust, it gets the risk.

3 · Why does the engineer count hand-offs rather than systems?

The two percent between finance and the POS is mostly timing. Each system is right about its own day; the disagreement lives in the arrows between them, and that is why the teach-back line is "I am counting the hand-offs".

Sources covered

What this session teaches, and where it came from

✓Tappers and listeners, about 50 percent predicted, 3 of 120 namedElizabeth Newton, "The Rocky Road from Actions to Intentions", PhD dissertation, Stanford, 1990; figures as reported in Chip Heath and Dan Heath, Made to Stick, Random House, 2007, ch. 1. The dissertation itself was not read at source
✓The curse of knowledge, the termCamerer, Loewenstein and Weber, "The Curse of Knowledge in Economic Settings", Journal of Political Economy 97(5), 1989
✓The Six Doors corridorStated in full once, in the analyst's session 1; this page names the six and opens door 4 widest
◐Single source of truth versus multiple versions of the truthLeandro DalleMule and Thomas H. Davenport, "What's Your Data Strategy?", Harvard Business Review, May-June 2017; reported, the article is paywalled and was not read in full
◐Starting, scaling and leading with dataJoe Reis and Matt Housley, Fundamentals of Data Engineering, O'Reilly, 2022; reported, and no chapter is cited because none was confirmed
✓Any order 27.6 (5 to 45), door by door 47, tuned for an engineer 51Measured on session 3's bench against a constructed fact sheet; the ordering is the finding, never the numbers as facts about a real business
◐Harbourline and Adeline TanConstructed. Every fact on her sheet, from the two percent to Kenneth's login, is printed in the bench's bank file and is invented to be typical, not sourced

Every fact on this page, and its verification tier, is recorded in the course's source map.

Session 1 cheat sheet · pin this

Two tunes behind "match"Hers: one number she can defend, by a date, to a person. Yours: rows that line up. Only hers is the request.
The failure to avoidA pipeline that moves the disagreement faster instead of settling which copy is real.
Open questions first"Tell me about the last time two numbers did not match." It earns the trust door 4 needs.
Door 4, widestEvery system a sale touches, who can log in, how often each is read, which copy is real.
Count the hand-offsA number changes between systems, not inside them. A mismatch is usually timing, not truth.
The teach-back linePlain, true, one sentence, before the question. Trust up, and she learns one real thing.