Business Analytics Fundamentals

Chapter 2
Analytical Problem Framing and Decision-Making

Diploma in Business Analytics
Business Analytics Fundamentals   •   Diploma

Analytical Problem Framing and Decision-Making

Introduction

Business analytics creates value only when analysis is connected to a real decision. A technically sophisticated dashboard, model, or report may still be ineffective if it addresses the wrong problem, uses an unsuitable measure, ignores constraints, or is not trusted by decision-makers. Analytical problem framing is therefore the disciplined process of translating a broad business concern into a clearly defined decision, analytical question, objective, scope, and evidence requirement.

For example, “sales are declining” is a business observation, not yet an analytical problem. A useful analytical formulation might be: “Which customer segments and product categories contributed most to the decline in quarterly gross margin, and which retention or pricing actions should management prioritize within a fixed budget?” This formulation identifies the outcome, possible explanatory dimensions, decision alternatives, and constraints.

This chapter explains how to frame analytical problems, identify stakeholders, define objectives and constraints, establish key performance indicators (KPIs), select appropriate decision structures, and communicate recommendations responsibly.

Learning Objectives

By the end of this chapter, you should be able to:

  1. Distinguish business problems, decisions, analytical questions, and data questions.
  2. Translate vague business concerns into precise analytical problem statements.
  3. Identify stakeholders, decision rights, assumptions, objectives, and constraints.
  4. Develop suitable KPIs and distinguish leading from lagging indicators.
  5. Apply structured approaches such as issue trees, logic models, and decision matrices.
  6. Recognize uncertainty, trade-offs, bias, ethical risks, and limitations in analytics-based decisions.
  7. Communicate an analytical recommendation in a form that supports action.

1. From Business Concern to Analytical Problem

A business concern is an observed condition that may require attention: declining profit, increasing complaints, delayed deliveries, employee turnover, or inefficient resource use. A decision is a choice among alternatives. An analytical question determines what evidence is needed to support that choice.

These concepts should not be confused:

LevelExample
Business concernCustomer churn appears to be increasing.
DecisionShould the firm introduce a retention programme?
Analytical questionWhich customers are most likely to churn, and which intervention is effective for them?
Data questionDo transaction, service, and customer-contact records contain reliable predictors of churn?
ActionTarget eligible customers with the approved intervention and monitor results.

A well-framed problem connects all five levels. If the decision is not identified, analysts may produce interesting findings that do not guide action. If the analytical question is too broad, the project may become expensive and unfocused. If the data question is ignored, recommendations may rely on unavailable or unreliable evidence.

Problem versus symptom

A symptom is an observable effect; a problem is a condition requiring a decision. “Website conversion has fallen” is a symptom. Possible underlying problems include poor traffic quality, payment failure, confusing navigation, uncompetitive pricing, or stock shortages. Analysts should avoid assuming that the first visible symptom identifies the root cause.

A useful diagnostic sequence is:

  1. Observe: What has changed, compared with which baseline?
  2. Locate: Where, when, and for whom does the change occur?
  3. Explain: What plausible factors could account for it?
  4. Decide: What action could influence the outcome?
  5. Evaluate: How will success and unintended effects be measured?

This sequence does not prove causation by itself. It creates a disciplined path from observation to investigation and decision.

2. Writing an Analytical Problem Statement

A practical problem statement normally includes:

  • the business context;
  • the decision owner;
  • the outcome requiring improvement;
  • the population, process, product, or period in scope;
  • the decision deadline;
  • relevant alternatives;
  • constraints and risks; and
  • the intended use of the analysis.

A useful template is:

The [decision owner] must decide whether/how to [action] because [business condition]. The analysis will determine [specific evidence or comparison] for [defined population and period], subject to [constraints], so that [business objective] can be improved by [decision date].

Example

Weak statement: “Investigate delivery problems.”

Improved statement: “The operations manager must decide whether to change carrier allocation for metropolitan deliveries because late deliveries increased during the last two quarters. The analysis will compare carrier performance by route, parcel type, and service level, subject to the existing transport budget and contractual commitments, so that the late-delivery rate can be reduced before the next peak season.”

The improved version is more useful because it defines the decision, outcome, scope, comparison, constraints, and time horizon.

Scope and boundaries

Scope determines what is included and excluded. It should specify the unit of analysis, period, geography, products or services, and relevant customer or employee groups. Scope prevents “scope creep,” in which a project gradually expands from one decision into an unmanageable investigation.

A scope statement might specify: “This analysis covers domestic online orders shipped between January and June, excluding wholesale orders, cancelled orders, and deliveries affected by documented natural disasters.” Exclusions should be justified rather than hidden, because they affect interpretation and generalisability.

3. Stakeholder Identification and Decision Rights

Stakeholders are individuals or groups affected by the problem, able to influence the analysis, responsible for implementation, or interested in its consequences. Typical stakeholders include:

  • the sponsor, who authorizes the work and provides resources;
  • the decision owner, who chooses among alternatives;
  • the subject-matter expert, who understands the operational context;
  • the data owner, who controls access and defines data meaning;
  • the analyst, who structures the problem and performs analysis;
  • the implementation team, which converts a recommendation into action; and
  • affected customers, employees, suppliers, regulators, or communities.

The sponsor and decision owner may be different. A senior executive may fund a project while a frontline manager makes the operational choice. This distinction matters because a recommendation must be acceptable to the person with decision authority and practical to the people who implement it.

Stakeholder analysis

Stakeholders can be assessed by influence and impact. High-influence, high-impact stakeholders require close engagement. High-impact groups with limited formal influence—such as customers affected by automated decisions—still require protection and representation. A stakeholder register should record each stakeholder’s role, interests, information needs, concerns, and engagement method.

The analyst should clarify early:

  • Who owns the decision?
  • Who can approve changes?
  • Who supplies or validates data?
  • Who bears the cost or risk?
  • Who may be harmed by an error?
  • Who must trust and use the result?

Governance and accountability

Analytics should not obscure accountability. A model can rank customers, forecast demand, or recommend staffing, but an organization remains responsible for how the result is used. Decision rights, approval thresholds, escalation routes, and audit records should be documented, particularly where decisions affect employment, credit, insurance, healthcare, safety, or access to essential services.

4. Objectives, Constraints, and Trade-offs

An objective states what the organization is trying to achieve. Objectives should be specific enough to guide measurement and comparison. Common objectives include increasing contribution margin, reducing waiting time, improving retention, increasing service quality, or reducing risk.

A useful distinction is between an objective function and constraints. The objective function describes the desired direction or value of an outcome. Constraints describe conditions that must be satisfied. For example, a firm may seek to maximize contribution margin while remaining within a marketing budget, maintaining service capacity, and meeting regulatory requirements.

In a simplified setting, a decision can be represented as:

Choose d ∈ D to maximize U(d)
subject to gj(d) ≤ cj, j = 1, 2, …, m

Here, d is a decision, D is the set of feasible alternatives, U(d) is the value or utility associated with the decision, gj(d) represents the use of a constrained resource or risk measure, and cj is the allowable limit. This formulation is conceptual: actual objectives may involve several outcomes and uncertain consequences.

Multiple objectives

Business decisions often involve trade-offs. A low-cost supplier may be less reliable; a fast service may be more expensive; aggressive debt collection may increase short-term cash receipts while damaging customer relationships. Analysts should make trade-offs explicit rather than presenting a single metric as if it represents total value.

A weighted scoring approach can be used when decision-makers agree that several criteria should be considered:

Si = ∑(wk rik), k = 1 to n

In this expression, Si is the total score of alternative i, wk is the weight assigned to criterion k, and rik is the rating of alternative i on that criterion. Usually, weights are non-negative and sum to 1, while ratings use a consistent scale. The method is useful for transparent comparison, but results depend on subjective weights, rating quality, and the assumption that criteria can reasonably be combined.

Hard and soft constraints

A hard constraint cannot be violated, such as a legal requirement, safety threshold, or fixed capacity. A soft constraint is a preference that may be relaxed at a known cost, such as a target delivery time or budget guideline. Confusing the two can lead either to unacceptable risk or unnecessarily restrictive decisions.

5. KPIs and Measurement Design

A KPI is a deliberately selected measure used to monitor performance against an objective. Not every metric is a KPI. A metric becomes a KPI when it is connected to a decision, has a defined owner, uses a clear calculation, and supports a specified review process.

A KPI definition should include:

  • name and purpose;
  • numerator and denominator, where applicable;
  • unit of measurement;
  • population and time period;
  • data source and refresh frequency;
  • target, threshold, or benchmark;
  • owner and review audience; and
  • known limitations.

For example, an on-time delivery rate may be defined as:

On-time delivery rate = (Number of deliveries meeting the agreed deadline ÷ Total eligible deliveries) × 100%

The denominator must be defined. Are cancelled orders, customer-requested delays, and force-majeure events included? Without these rules, two departments may report different rates while using the same label.

Leading and lagging indicators

A lagging indicator measures an outcome after it occurs, such as quarterly profit or annual employee turnover. A leading indicator is expected to provide earlier information about future performance, such as service response time, abandoned baskets, or training completion. Leading indicators are useful for intervention, but they are not automatically causal predictors. Their relationship with outcomes should be monitored and validated.

KPI hierarchy

A balanced measurement system may include:

  1. Outcome KPIs: the final result, such as profit, retention, or customer satisfaction.
  2. Driver measures: factors believed to influence the outcome, such as response time or product availability.
  3. Activity measures: actions performed, such as calls completed or inspections conducted.
  4. Guardrail measures: indicators that prevent improvement in one area from causing unacceptable harm elsewhere, such as complaint rates, equity measures, safety incidents, or staff workload.

A common error is to optimize an activity measure rather than the desired outcome. Increasing the number of customer calls, for instance, may reduce call quality or create unwanted contacts. Guardrails help expose such unintended effects.

6. Analytical Frameworks for Problem Framing

Issue trees

An issue tree decomposes a broad question into smaller, answerable components. For example, “Why has profit declined?” might be divided into revenue and cost. Revenue can be divided into volume and price; volume can be divided into customer numbers and purchase frequency; cost can be divided into variable and fixed cost.

A good issue tree is:

  • logically connected to the main question;
  • sufficiently complete for the decision;
  • non-overlapping where possible; and
  • structured around questions that can be tested.

Issue trees are not statistical models. They are reasoning tools that organize investigation and expose missing branches or assumptions.

Logic models

A logic model links inputs, activities, outputs, outcomes, and impacts:

Logic model from inputs to impact InputsresourcesActivitieswhat is doneOutputsimmediate resultsOutcomesbehaviour/changeImpactlong-term value Assumptions, risks and external influences must be tested
Logic model from resources to impact
Figure: Logic model from resources to impact

Figure: A logic model connects resources and activities to measurable outcomes and longer-term impact.

A logic model is useful for programme evaluation because it distinguishes what an organization controls from what it merely influences. It also prevents analysts from claiming that an output automatically proves an impact.

Hypothesis-driven analysis

A hypothesis is a testable explanation or expectation. For example: “Late deliveries are concentrated among two carriers on high-volume urban routes.” The hypothesis guides data collection, but it should remain open to disconfirmation. Analysts should record alternative explanations, such as seasonal demand, address quality, warehouse delays, or changes in service definitions.

7. Decision-Making Under Uncertainty

Decisions are frequently made with incomplete information. Three distinctions are important:

  • Risk: possible outcomes and their probabilities are reasonably estimable.
  • Uncertainty: outcomes or probabilities are poorly known.
  • Ambiguity: the problem itself, including objectives or definitions, is contested or unclear.

A simple expected-value calculation can compare alternatives when outcomes and probabilities are credible:

EV(a) = ∑ ps V(a, s)

Here, EV(a) is the expected value of action a, ps is the probability of state s, and V(a,s) is the value of action a if state s occurs. Probabilities must sum to 1 across mutually exclusive and collectively exhaustive states. Expected value is not a prediction of what will happen; it is a decision aid that averages possible consequences under stated assumptions.

Sensitivity analysis examines how the recommendation changes when assumptions vary. Scenario analysis compares coherent combinations of assumptions, such as high-demand, baseline, and low-demand conditions. These methods are especially useful when precise probabilities would create false confidence.

A decision tree can show choices, uncertain events, probabilities, and consequences. However, a tree is only as reliable as its branches, probabilities, valuations, and definitions. It should support managerial judgment, not replace it.

8. Worked Example: Choosing a Customer Retention Intervention

An online subscription company has 10,000 customers. Management is considering an intervention for customers identified as likely to cancel. The decision alternatives are:

  • Alternative A: no intervention;
  • Alternative B: offer a digital support package; or
  • Alternative C: offer a discount.

The business objective is to increase contribution after intervention costs. The team estimates the following illustrative values for a selected customer group. These figures are hypothetical and are not a causal estimate unless supported by an appropriate evaluation design.

AlternativeExpected retained customersContribution per retained customerIntervention cost per selected customer
A: None100$80$0
B: Support160$80$8
C: Discount190$60$15

Suppose 1,000 customers are selected. The estimated contribution is:

  • A: 100 × $80 × 1,000/1,000 = $8,000
  • B: 160 × $80 − 1,000 × $8 = $4,800
  • C: 190 × $60 − 1,000 × $15 = $1,400

Under these assumptions, Alternative A produces the highest incremental contribution for the selected group because the estimated retained-customer figures are interpreted per 1,000 selected customers? The table must be internally consistent: if retained customers are stated per 1,000 selected customers, then A gives 100 × $80 = $8,000, B gives 160 × $80 − $8,000 = $4,800, and C gives 190 × $60 − $15,000 = −$3,600. Thus, the decision would be no intervention on the stated assumptions.

This result should not be accepted without validation. The estimates may be biased because customers who receive support differ from those who do not; discounts may retain customers who would have stayed anyway; and retained customers may generate different future costs. A randomized pilot, where ethically and operationally feasible, could compare outcomes between intervention and control groups. The analysis should also include guardrails such as complaint rates, fairness across customer segments, and long-term profitability.

The example illustrates a central principle: an attractive operational outcome, such as more retained customers, does not necessarily produce the best business decision. Objectives, costs, time horizon, and measurement design determine the conclusion.

9. Illustrative Case Study: Delivery Reliability at Northstar Retail

This is a fictional illustrative case.

Background

Northstar Retail, an online retailer, reported that its on-time delivery KPI had fallen from 94% to 88% over two quarters. Customer complaints increased, and the operations team proposed replacing its lowest-performing carrier.

Problem framing

The initial proposal assumed that carrier performance was the main cause. The analyst reframed the decision: “Should Northstar reallocate shipments among carriers, change warehouse cut-off times, or adjust delivery promises in order to improve on-time delivery without increasing total fulfilment cost or disadvantaging remote customers?”

This version identified several alternatives and prevented premature commitment to a carrier replacement.

Analysis

The analyst defined an eligible delivery, the promised deadline, treatment of customer-requested changes, and the reporting period. Performance was segmented by carrier, route type, warehouse, parcel size, and order time. The analysis showed that late deliveries were concentrated in orders placed after a revised evening cut-off time. One carrier appeared weak overall because it handled a disproportionate share of remote deliveries.

The team used a logic model: staffing and cut-off rules were inputs; warehouse processing and carrier dispatch were activities; dispatch completion and delivery were outputs; on-time receipt and complaint reduction were outcomes. Guardrail measures included total cost per order, rural delivery performance, and employee overtime.

Approach and solution

Northstar tested three changes in a pilot: restoring the previous warehouse cut-off for selected products, reallocating some urban orders, and improving customer communication for unavoidable delays. The pilot included a comparison group and predefined success criteria. Rather than judging only the overall on-time rate, the team monitored segment-level results and cost.

Outcome

The pilot improved on-time delivery in the affected urban segment without materially increasing cost. Replacing the carrier entirely was rejected because it would have increased remote-area risk and contract costs. The company adopted differentiated cut-off rules and retained multiple carriers with clearer performance monitoring.

Learning points

  1. A symptom can have several operational causes.
  2. Aggregate KPIs can conceal segment-level differences.
  3. The apparent worst performer may serve the most difficult cases.
  4. A decision should compare feasible alternatives, not merely confirm a preferred solution.
  5. Pilot evaluation and guardrails reduce the risk of implementing a misleading recommendation.

10. Ethics, Governance, and Responsible Use

Problem framing includes ethical judgment because the choice of objective determines whose interests count. Analysts should consider:

  • privacy: collect and use only data appropriate for the stated purpose;
  • fairness: assess whether errors or benefits are distributed unevenly;
  • transparency: explain important measures, assumptions, and decision logic;
  • accountability: identify who approves, monitors, and remedies decisions;
  • security: protect sensitive information from unauthorized access;
  • purpose limitation: avoid repurposing data in ways people could not reasonably expect; and
  • human oversight: provide review and appeal where automated decisions have significant effects.

A model or KPI can produce discriminatory outcomes even without explicitly using a protected attribute, because proxy variables may reproduce social inequalities. Removing a sensitive field does not guarantee fairness. Analysts should examine data representativeness, error rates, outcomes across relevant groups, and the consequences of false positives and false negatives.

AI-assisted analysis can accelerate summarization, forecasting, and pattern detection, but it introduces risks including fabricated information, hidden training bias, confidentiality breaches, and overreliance on automated recommendations. Human review, source verification, access controls, version records, and monitoring for performance drift are essential.

11. Common Failure Modes and Best Practices

Common failures include:

  • starting with available data rather than the decision;
  • defining the problem as a solution, such as “build a dashboard”;
  • using vague KPIs without numerator, denominator, or ownership;
  • optimizing one metric while ignoring quality, equity, or cost;
  • treating correlation as proof of causation;
  • presenting a single forecast without uncertainty or sensitivity analysis;
  • excluding inconvenient stakeholders;
  • allowing scope to expand without a decision rationale; and
  • failing to plan how the recommendation will be implemented and evaluated.

Best practice is to produce a concise analytical charter before substantial analysis begins. It should record the decision, objective, scope, stakeholders, alternatives, assumptions, constraints, KPIs, data sources, risks, approval points, and delivery date. The charter should be reviewed with the decision owner and updated when material assumptions change.

Chapter Summary

Analytical problem framing connects a business concern to a decision, an analytical question, evidence requirements, and action. Effective framing distinguishes symptoms from problems, identifies the decision owner, defines scope, and makes assumptions and constraints explicit. Stakeholder analysis clarifies interests, authority, data ownership, implementation responsibility, and potential impact.

Objectives describe desired outcomes, while constraints define acceptable limits. KPIs should have precise definitions, owners, targets, data sources, and review processes. Outcome, driver, activity, and guardrail measures should be considered together. Issue trees, logic models, hypotheses, decision matrices, expected-value reasoning, sensitivity analysis, and scenario analysis provide complementary ways to structure decisions.

Good analytics does not eliminate judgment or uncertainty. It makes them visible and manageable. Ethical, transparent, and well-governed problem framing is essential when analytical results influence customers, employees, communities, or access to important services.

Key Terms

Analytical question: A question specifying what evidence is needed to support a business decision.

Business concern: An observed condition that may require investigation or action.

Constraint: A limit or requirement that restricts feasible alternatives.

Decision owner: The person or group authorized to choose among alternatives.

Decision tree: A representation of choices, uncertain events, probabilities, and consequences.

Driver measure: A measure believed to influence an outcome KPI.

Expected value: A probability-weighted average of possible consequences.

Guardrail metric: A measure used to prevent improvement in one outcome from causing unacceptable harm elsewhere.

Hypothesis: A testable explanation or expectation about a business condition.

Issue tree: A structured decomposition of a broad question into smaller questions.

KPI: A key performance indicator connected to an objective, owner, and decision process.

Lagging indicator: A measure of an outcome after it has occurred.

Leading indicator: A measure expected to provide earlier information about future performance.

Logic model: A framework linking inputs, activities, outputs, outcomes, and impacts.

Objective: A desired result that guides evaluation of alternatives.

Problem statement: A concise description of the decision context, outcome, scope, constraints, and intended use of analysis.

Scope: The defined boundaries of a project, including population, period, geography, and exclusions.

Stakeholder: A person or group affected by, interested in, or able to influence an analytical project.

Trade-off: A situation in which improving one objective requires sacrificing another.

Uncertainty: Limited knowledge about outcomes, relationships, or probabilities.

Review Questions

Short Answer Questions

  1. Distinguish a business concern from an analytical question.
  2. What information should be included in an analytical problem statement?
  3. Explain the difference between a leading indicator and a lagging indicator.
  4. Why are guardrail metrics useful?
  5. Name two ethical risks associated with analytics-based decisions.

Long Answer Questions

  1. Explain how stakeholder identification improves the quality and implementation of an analytical project.
  2. Discuss the role of objectives, constraints, and trade-offs in business decision-making.
  3. Compare issue trees, logic models, and hypotheses as problem-framing tools.
  4. Explain why KPI definitions must specify the numerator, denominator, population, period, and data source where relevant.
  5. Discuss how sensitivity analysis and scenario analysis can improve decisions under uncertainty.

Analytical / Application Questions

  1. A retailer reports falling profit but has not identified the cause. Construct an issue tree with at least two major branches and propose suitable KPIs for investigating each branch.
  2. A company wants to use an AI model to prioritize customers for retention offers. Identify the decision, stakeholders, constraints, ethical risks, and guardrail measures that should be considered before deployment.
  3. A hospital must reduce waiting time without reducing safety. Propose a problem statement, two alternatives, an outcome KPI, two driver measures, and two guardrail measures.

Multiple Choice Questions with Answers

Question 1

Which statement best distinguishes a business concern from an analytical question?

A. A business concern identifies the evidence required, while an analytical question identifies a symptom.

B. A business concern is an observed condition, while an analytical question specifies what must be learned to support a decision.

C. A business concern is always quantitative, while an analytical question is always qualitative.

D. A business concern is a final recommendation, while an analytical question is an implementation plan.

Correct Answer: B. A business concern is an observed condition, while an analytical question specifies what must be learned to support a decision.

Question 2

Who normally has authority to choose among alternatives in an analytical project?

A. The data owner

B. The analyst

C. The decision owner

D. The software vendor

Correct Answer: C. The decision owner

Question 3

Which of the following is a guardrail metric?

A. Number of calls made by a sales team

B. Total website visits

C. Revenue target

D. Customer complaint rate monitored while optimizing retention

Correct Answer: D. Customer complaint rate monitored while optimizing retention

Question 4

What is the main purpose of an issue tree?

A. To decompose a broad question into smaller, testable questions

B. To encrypt sensitive data

C. To replace all managerial judgment

D. To calculate a probability automatically

Correct Answer: A. To decompose a broad question into smaller, testable questions

Question 5

An on-time delivery rate is calculated as 920 eligible deliveries meeting the deadline divided by 1,000 eligible deliveries. What is the rate?

A. 9.2%

B. 80%

C. 92%

D. 108.7%

Correct Answer: C. 92%

Question 6

Which expression represents expected value under stated probabilities?

A. The maximum possible outcome only

B. A probability-weighted sum of possible values

C. The number of alternatives divided by the number of stakeholders

D. The average of KPI labels

Correct Answer: B. A probability-weighted sum of possible values

Question 7

Which is an example of a hard constraint?

A. A preferred colour scheme for a dashboard

B. A manager’s informal preference for weekly meetings

C. A legal safety requirement that cannot be exceeded

D. A suggestion to improve presentation style

Correct Answer: C. A legal safety requirement that cannot be exceeded

Question 8

Why can aggregate KPI results be misleading?

A. Aggregates always exclude all data

B. Aggregates may conceal important differences between segments

C. Aggregates cannot be displayed in tables

D. Aggregates are never used in business analytics

Correct Answer: B. Aggregates may conceal important differences between segments

Question 9

What is a principal risk of treating correlation as causation?

A. The analysis may recommend an intervention that does not produce the desired effect

B. The dataset will automatically become larger

C. The KPI definition becomes more precise

D. The decision owner is removed from the process

Correct Answer: A. The analysis may recommend an intervention that does not produce the desired effect

Question 10

Which practice best supports responsible use of AI-assisted analytics?

A. Accepting generated recommendations without verification

B. Removing all human review to improve speed

C. Using confidential data in any publicly available tool

D. Verifying outputs, documenting assumptions, and monitoring performance and bias

Correct Answer: D. Verifying outputs, documenting assumptions, and monitoring performance and bias

Business Analytics Fundamentals
Chapter 2 of 15