
Think Like an Analyst: The Questions That Drive Decisions
đ Transcript
A Harvard review found the biggest gap between average and top analysts isnât tools or codingâitâs the questions they ask. Youâre in a meeting, a dashboard full of charts on the screen. Numbers look fine. Then one sharp question suddenly flips the whole decision.
Most people open a dataset and immediately ask, âWhat can I do with this?â Analysts who consistently drive impact start somewhere else: âWhat *must* I learn to change this outcome?â That tiny shift turns a pile of numbers into a focused search. Think about how a good editor treats a messy draft: they donât fix every sentence; they hunt for the one structural issue that, if clarified, makes everything else fall into place. Analysts do the same with information. Theyâre not chasing more charts; theyâre chasing sharper prompts. Each refinement trims the noise, revealing which metrics actually move revenue, risk, or customer behavior. Over time, this habit changes how you walk into any problem. Youâre no longer the person asked to âpull some data.â You become the one people turn to when the room is stuck and someone needs to ask, âAre we even solving the right thing?â
Strong analysts donât wait for perfect data or fancy tools; they create clarity by deliberately zooming in and out. At the widest level, they anchor on business stakes: revenue, risk, cost, reputation. Then they tighten the lens: which behaviors, segments, or time windows could actually move those outcomes? Instead of accepting a vague ask like âunderstand churn,â they peel it back: churn of whom, when, after which events, compared to what? This layered questioning turns a foggy request into a map of sub-questions you can test, prioritize, and sequence, so each step in your work has a reason to exist.
The analysts who change outcomes treat their questions like prototypes, not pronouncements. They donât ask one âbigâ question and disappear into a spreadsheet; they iterate through layers of smaller, testable ones that evolve as they learn.
Start with the most concrete layer: *observable change*. Something movedâsignâups dipped, complaints spiked, conversion ticked up on mobile. Effective analysts first pin this down with precision: âWhich exact metric moved, by how much, over what window, and for which slice of users or products?â Until thatâs nailed, anything upstream is guesswork.
Next comes *structure*: âHow can I break this vague topic into mutually exclusive, collectively exhaustive buckets?â Instead of âWhy are sales down?â you might push into: âIs this volume, price, or mix? New customers or existing? Specific regions or channels?â Each sub-question is a fork in the road that eliminates whole swaths of irrelevant data.
Then they move to *mechanisms*: questions about behaviors and sequences rather than aggregates. âWhat common sequence of actions do churned customers show in the 30 days before they leave?â or âWhich touchpoints appear in 80% of our highestâvalue journeys?â Now your questions start aligning with levers the business can realistically pullâproduct changes, pricing tests, message tweaks.
Alongside this, strong analysts continually ask *comparative* questions. Rarely is an absolute number as revealing as a contrast: this month vs. last, exposed vs. not exposed, customers who saw feature X vs. those who didnât. âCompared to what?â becomes a reflex, because comparison naturally points toward causality candidates, even before formal modeling.
They also learn to ask *constraints* questions early, because a beautiful analysis that canât influence action is theater: âWhat decisions are actually on the table?â âWhatâs the time horizon?â âWhat canât we change, no matter what the data says?â These boundaries sharpen the scope of your work more than another ten filters ever will.
Underneath all of this sits one quiet habit: they write their questions down, in order, as they go. That evolving listâwhat you believed, what you asked next, what you ruled outâbecomes both a thinking tool and an audit trail. It keeps you from chasing every curiosity and helps you explain, in plain language, why your recommendation makes sense.
Consider a real scenario: a retailer sees loyalty-app usage stall. A weak prompt is, âPull everything on app engagement.â A stronger analyst asks instead, âWhich three customer behaviors, if changed, would most increase repeat purchases through the app?â From there, they might line up testable subâquestions: âDo push notifications nudge lapsed users back?â âDoes simplifying checkout lift completion?â The questions now point to experiments, not just dashboards.
Or take Amazonâs recommendations. The engine didnât start from âShow more products.â It started from a focused curiosity: âWhat related products meaningfully increase a customerâs order value without annoying them?â That framing steered which signals to collect, how to evaluate relevance, and how to measure success.
In practice, you can borrow this mindset even without advanced tooling. Before opening a spreadsheet, draft two versions of your core prompt: one vague, one uncomfortably specific. Then ask: âWhat analysis would *not* change based on how I answer this?â If nothing would change, your question is still too soft. Keep tightening until a âyesâ or ânoâ would clearly alter your next step.
As tools grow more automated, the real leverage shifts to how you frame whatâs worth exploring. Think of future analysts less as numberâcrunchers and more as editors, deciding which âstorylinesâ in the data deserve a deeper chapter. Augmented analytics will propose angles youâd miss, but youâll be the one judging which paths are ethical, strategically aligned, and feasible. That judgment will be a differentiator, not a commodityâand itâs built one disciplined question at a time.
Treat this like learning a new language: fluency comes from daily use, not theory. Your challenge this week: before any report or meeting, draft one âtoo narrowâ and one âtoo broadâ version of your core prompt. Then adjust until it feels slightly uncomfortable. That edge is where better patterns, bolder options, and clearer tradeâoffs start to surface.
From this course

Data Analysis Without Code: Excel to Insights
7 episodesUnlock all episodes
Full access to 7 episodes and everything on OwlUp.
Subscribe â $1.99/monthLess than a coffee â · Cancel anytime

