Nithya Suri · Product designer

Sheet B-04 / 05

Product design

Portfolio recommender

Two weeks of spreadsheets per decision, down to ten minutes.

Product managers decided which products to expand, reprice or retire by working business rules through huge spreadsheets, two weeks per analysis, with no version history. The recommender applies the rules, shows its reasoning beside the data, and lets a PM act on each recommendation without leaving the page.

Client
Dr. Reddy's
Product
AI recommendations for portfolio decisions
Year
2022
Scope
15 PM interviews · 25 PMs giving weekly feedback · side-by-side task test · 4 reusable patterns
Role
Senior product designer, design and research lead
Team
2 product owners, 4 engineers, data scientists
Timeline
12 weeks, 2022
Status
Shipped

Impact at a glance

per portfolio analysis
2 wk → 10 min
retention at month three
89%
more recommendations implemented
+35%
out of 10, user satisfaction
8.4

Adoption tracked at week one, month one and month three. Analysis time compared against the spreadsheet process for the same decision.

Evidence trail

Every claim on this sheet, traced from the evidence to the decision it drove and how it was validated.

ClaimEvidenceDecision it droveValidation
PMs spend most of their time on analysis15 PM interviews and shadowed planning sessionsBusiness rules applied automatically Field researchn = 15
PMs want the reasoning beside the dataSide-by-side task test, modal against side panelSide panel shipped Validated with users40% faster to complete
Rejected recommendations leave no trailInterviews: no record of past recommendationsDisqualify with a stated reason Field research
Adoption 45%, 73%, 89% at week 1, month 1, month 3Usage tracking after launchOutcome of the shipped design Measured in product
Analysis from two weeks to ten minutesTimed against the spreadsheet process for the same decisionOutcome of the shipped design Measured in productRules engine plus a one-view review

Method: field research finds the problem, each finding drives one decision, decisions are validated with users or leadership, and outcomes are measured in the product.

The share expansion recommender's high impact list: products ranked by combined opportunity size, the number of recommendations for each, and an action to open them.

The problem

This came first, in 2022: one kind of decision, share expansion and the moves around it, run on business rules, as the first AI feature in Dr. Reddy’s portfolio tools. It shipped inside the early Panorama product shell, which is why the screens carry its name. Panorama 360 later rebuilt the whole landing page on what it taught.

From the docs

60 percent of a product manager’s time went on analysis instead of strategy.

  • Two weeks per analysis. Business rules applied by hand across large spreadsheets.
  • Errors and no history. No version control, manual rules, no record of past recommendations.
  • The cost. Delayed product decisions and inconsistent recommendations across the portfolio.

What the research found

How. Interviews with 15 PMs, shadowing quarterly planning sessions, and a workflow analysis of the tools in use, structured with jobs to be done.

  • The functional jobs. Analyse portfolio performance, generate strategic recommendations, track market opportunities, manage rule-based decisions.
  • The emotional jobs. Feel confident in data decisions, spend less time on manual analysis, show strategic value.
  • What they did today. Large spreadsheets with no broad view, constant number crunching before any step, and no way to filter out a type of recommendation.
  • What they wanted. A small, almost one-click flow, a history of past recommendations, a zoomed-out view, and rules applied for them.
What PMs did and said Design decision
Constant number crunching before any step Rules applied automatically; the PM checks the result
Large spreadsheets with no broad view A portfolio view first, then one recommendation at a time
No record of past recommendations Every recommendation closes with an action, and a no records why
No way to filter out a type of recommendation Filters by impact and opportunity on the list
Wanted a small, almost one-click flow Review, decide and act on one screen, reasoning beside the data

One decision, three ways out

Every recommendation ends in one of three actions, so nothing is left half-decided in a spreadsheet:

  1. Convert it to a task, with the inputs and outputs attached.
  2. Edit it, changing an input and seeing the output recalculate.
  3. Disqualify it with a reason, so the next PM sees why it was turned down.

Version A against version B

Version A · modal detail

Version B · side panel, shipped

  1. Version B was 40 percent faster to complete.
  2. PMs preferred the reasoning beside the data, not on top of it.
  3. A bookmark feature request came out of the test.
  4. The insight: PMs want the why without losing context.
The same recommendation, two layouts, tested side by side with PMs on the same task. Click either image for full size.
Portfolio recommender · shipped
The shipped recommender, recorded. From the portfolio view into one recommendation, with the reasoning beside the numbers.

Patterns built to outlast it

  • Recommendation cards for AI insights.
  • Drill-down tables for sortable data grids.
  • Rule visualisation to show the business logic.
  • Progress indicators for multi-step guidance.

Together they kept five areas consistent and made each new area faster to build.

After launch

Version one · the recommendations list

Added in the analytics round · disqualify with a reason

Two screens, not a before and after: the list PMs work from in version one, and the disqualify step the analytics round added to it. Turning a recommendation down now records why, so the history PMs asked for builds itself.
  • Adoption. 45 percent tried the new workflow in week one, 73 percent used it as their primary tool by month one, 89 percent were still using it at month three.
  • Efficiency. Analysis from two weeks to ten minutes. Most of that is the rules running automatically; the design’s share is that checking each result takes one view instead of a spreadsheet hunt. 35 percent more recommendations implemented, satisfaction 8.4 out of 10.
  • Requested next. Bulk export, collaborative comments and a better mobile experience.

The recommender later grew into Panorama 360.

With the team

  • Lead designer and researcher, with two product owners, four engineers and 25 users giving weekly feedback.
  • Data scientists on explainability, engineering on real-time data, product owners on the balance between users and technology.
  • Design workshops with a fifteen person team kept the stakeholders aligned.

Revisions

Δ1
Fifteen PM interviews and shadowed quarterly planning, structured with jobs to be done.
Δ2
Every recommendation closes three ways, task, edit or disqualify.
Δ3
Version A modal against version B side panel. Side panel won.
Δ4
Four reusable patterns built for the recommender and the areas after it.
Δ5
Analytics round added disqualify with a reason, bulk export and comments.