Stop 11 · Business Acumen & Domain KnowledgeTopics · 4/8

Translating Business Questions Into Data Questions

In short

"Why are users unhappy?" can't be answered with SQL. "What share of last month's orders got a 1-star rating, by city?" can. Turning the first into the second is half your job.

The core skill of the job — turning a vague ask ('why are sales down?') into a specific, answerable data question ('did conversion rate or traffic volume drop, and in which segment?').

The jaadu in a doctor's coat and stethoscope reads a thermometer with a clipboard under one arm.

Think of it like this

The doctor's follow-up questions

You tell the doctor, "I feel unwell." She doesn't guess. She asks: since when, any fever, where does it hurt? Then she orders one specific test. You do the same with a manager's vague worry before you touch the database.

Watch it happen

From a worry to a query

Vague ask

Decision

Metric

Who, when

Data Q

1/5The ask: "Is the new checkout working?" Nobody can query that directly.

The big ideas

What you need to know

Start from the decision

Ask "What will you do differently based on the answer?" It tells you which metric actually matters.

Name one main metric

Pick a measurable number. "Happy users" might become repeat purchase rate or average rating.

Pin down who and when

Which users, which dates, which comparison. Without this, two analysts will get two different answers.

Write it back to them

Send your data question in one line before starting. Five minutes of agreement saves two days of rework.

Save yourself the pain

Common mistakes

Oops

Answering the question you assumed, then finding out the manager meant something else.

Do this instead

Repeat the question back in data terms and get a "yes, that" before writing any SQL.

Oops

Choosing a metric because it's easy to pull, not because it matters for the decision.

Do this instead

Choose the metric first, then go find the data. If it doesn't exist, say so early.

Your mission

Translate five vague asks

~20 min

Quick check

A manager asks, "Are customers price sensitive?" Which is the best data question?

Go deeper

1Practice rewriting 5 vague business questions into specific, answerable data questions.
2Learn to ask clarifying questions before writing a single query.
3Notice how often the real question isn't the one initially asked.