Menu

Turning a Business Request into an Analytical Question

Lesson 5: Turning a Business Request into an Analytical Question

Why does question framing matter?

A request often describes a concern rather than a measurable problem. For example, "Customers are unhappy" could refer to:

  • Product quality
  • Delivery time
  • Price
  • Customer support
  • A mismatch between expectations and reality

A good analyst clarifies the concern before choosing data or tools. A well-framed question saves hours of unnecessary analysis.

Use the who, what, where, and when prompts

Prompt

Question to ask

Example answer

WhoWhich customers or business areas are involved?First-time buyers on mobile
WhatWhat outcome matters?Checkout completion rate
WhereWhere does the issue appear?Payment page
WhenWhat time period should be examined?Last 8 weeks vs previous 8 weeks
Why (decision)What decision will the answer inform?Whether to redesign the payment page
How muchWhat counts as a meaningful change?A drop of 2+ percentage points

Example: from vague to specific

Vague request

Better question

"Find out why sales are poor.""Which product categories and regions contributed most to the 12% revenue decline from April to May, compared with the same period last year?"
"Are our students engaged?""What percentage of learners who enrolled in July completed at least 50% of lessons within 30 days?"
"Is the new feature working?""Did weekly active users who adopted the feature in August retain at a higher rate after 4 weeks than similar non-adopters?"

A good question identifies:

  • An outcome (revenue, completion rate)
  • A comparison (vs last year, vs another group)
  • A time period (April to May)
  • A scope (categories, regions, cohort)

Choose a measurable metric

Metrics translate an idea into something observable.

Metric

What it describes

Simple formula

RevenueTotal money earnedSum of sales (under a defined rule)
Conversion rateShare of people who complete an actionConversions ÷ eligible visitors × 100
Average order value (AOV)Typical order sizeRevenue ÷ number of orders
Repeat-purchase rateCustomer loyaltyCustomers with 2+ orders ÷ all customers
Return rateProduct or expectation problemsReturned orders ÷ total orders

Before comparing results, define:

  • Numerator – what is being counted
  • Denominator – out of what total
  • Time period – which dates
  • Exclusions – e.g., test orders, internal accounts, cancelled orders

Check assumptions and limitations

  • Does the available data actually measure what you care about?
  • Who is missing from the data?

Example: Customer satisfaction scores may not represent every customer, because only some people respond to surveys. Very happy and very unhappy customers often respond more than everyone else.

State such limitations openly instead of presenting the result as universal truth.

Key takeaways

  • A clear question guides the choice of data, method, and visualisation.
  • If the question is unclear, pause and clarify before beginning the analysis.
  • Every metric needs an agreed definition before results are compared.

Data Analytics Tutorial

J

Jebasta



Learn via Video Course

Data Analysis and Processing with Python using Pandas - Data Science Course Logo

Data Analysis and Processing with Python using Pandas - Data Science Course

5 hrs



Get in Touch For Details