Sheet B-04 / 05
Product designPortfolio 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.
| Claim | Evidence | Decision it drove | Validation |
|---|---|---|---|
| PMs spend most of their time on analysis | 15 PM interviews and shadowed planning sessions | Business rules applied automatically | Field researchn = 15 |
| PMs want the reasoning beside the data | Side-by-side task test, modal against side panel | Side panel shipped | Validated with users40% faster to complete |
| Rejected recommendations leave no trail | Interviews: no record of past recommendations | Disqualify with a stated reason | Field research |
| Adoption 45%, 73%, 89% at week 1, month 1, month 3 | Usage tracking after launch | Outcome of the shipped design | Measured in product |
| Analysis from two weeks to ten minutes | Timed against the spreadsheet process for the same decision | Outcome 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 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:
- Convert it to a task, with the inputs and outputs attached.
- Edit it, changing an input and seeing the output recalculate.
- 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
- Version B was 40 percent faster to complete.
- PMs preferred the reasoning beside the data, not on top of it.
- A bookmark feature request came out of the test.
- The insight: PMs want the why without losing context.
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
- 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.