Harish Rao
Harish RaoBusiness Process Transformation & AI Advisory
Menu
Process transformation & automation discovery toolkit

Process Issue Tree, Demand Mapping & Automation Opportunity Explorer

An industry-agnostic L1-L2-L3 framework for decomposing complex processes and problem landscapes into actionable issues, attaching demand and complexity data, and identifying where root-cause analysis, process redesign, automation discovery or transformation prioritization should begin.

Includes a fully populated retail-banking example with 13 L1 domains, 46 L2 categories and 185 L3 issues to demonstrate how the methodology can be applied in practice.

Developed by Harish Rao · Independent Business Process Transformation & AI Advisor
Download Asset See how to use the issue tree Free download · ZIP package containing the Excel issue-tree master and connected browser-based explorer
The discovery problem

Transformation decisions improve when broad processes are decomposed into the specific issues that create demand, friction or failure.

High-level labels such as “claims,” “payments,” “billing,” “onboarding,” “order management,” “customer service” or “finance operations” are usually too broad for good process-redesign or automation decisions. The opportunity becomes actionable only when the landscape is decomposed into specific issues, volumes, complexity and problem paths.

The underlying issue-tree logic is reusable for process mapping, problem decomposition, demand analysis, root-cause structuring, automation discovery and transformation prioritization across industries and business functions. The included banking dataset is a worked example of the method, not a limitation of the framework.

13L1 banking service domains
46L2 customer-service categories
185L3 customer issue statements
100%of modeled customer-service demand allocated
What is included

A reusable issue-tree framework, with a complete banking example already built in.

01 · EXCEL MASTER

Process Issue Tree Master

A structured master dataset using L1 domains, L2 categories and L3 issues, with demand share, roll-ups, complexity, automation score, opportunity tier and recommended action. The supplied workbook is fully populated with a retail-banking example.

02 · CONNECTED EXPLORER

Interactive Issue Tree & Opportunity Explorer

A browser-based explorer that loads the Excel workbook and provides domain navigation, search, filters, sorting, L1/L2/L3 score roll-ups, automation ranking and detailed issue inspection.

Issue decomposition

Move from a broad process domain to a specific, actionable issue.

The framework is deliberately hierarchical so teams can move between executive-level process or demand views and individual problem statements without losing the relationship between them.

LEVEL 1

Service domain

Broad process, service or problem domains such as Customer Service, Claims, Payments, Billing, Onboarding, Order Management or Operations.

LEVEL 2

Issue category

More actionable issue categories that divide a broad domain into meaningful workstreams, demand types or failure modes.

LEVEL 3

Specific customer issue

Concrete issue statements that are specific enough for root-cause analysis, process mapping, automation feasibility or intervention design.

Worked example included

The downloadable toolkit includes a fully populated retail-banking issue tree.

The banking example demonstrates how the method can be applied end-to-end, including demand allocation, complexity and opportunity scoring. You can replace the taxonomy with your own process, function, customer journey or industry while retaining the same structure.

Account Management
Payments & Transfers
Cards
Loans & Credit
ATM, Cash & Cheques
Profile, KYC & Service Requests
Digital Channels
Fraud & Disputes
Deposits
Charges, Fees & Interest
Communication & Alerts
Branch & Assisted Service
Complaints & Escalations
Opportunity prioritization

Use volume and complexity as an initial screen—not as the final automation decision.

The included model uses issue-volume share and a simple ease factor derived from complexity to create an automation-priority score. That helps transformation teams identify where deeper analysis should begin.

Included prioritization logic
Automation score = Issue volume % × ease factor   |   Low complexity = 3 · Medium = 2 · High = 1
Quick WinHighest initial priority for deeper validation and early-wave consideration.
High PotentialAttractive opportunity that should move into feasibility assessment.
Selective AutomationPotential exists, but value or ease is less compelling across the whole issue.
Human-led / Low PriorityLower initial automation priority based on volume and complexity alone.

The score is deliberately an opportunity-screening mechanism, not a substitute for feasibility assessment. Issues that look attractive here should move into path-level process, API/data, risk and ROI assessment before implementation decisions are made.

What the explorer can do

Turn a static taxonomy into an interactive discovery workspace.

BROWSE

Navigate L1 → L2 → L3

Expand banking domains and categories to understand how individual customer issues sit within the larger demand structure.

SEARCH

Find issues quickly

Search across domains, categories, issue statements and any additional metadata loaded from the workbook.

FILTER

Focus on a specific domain

Filter the explorer to one banking domain when a transformation workstream has a narrower scope.

SORT

Reorder by volume, score or complexity

Surface high-volume issues, automation-priority candidates or complex problem areas for further review.

ROLL UP

See L1 and L2 demand views

The explorer aggregates issue volume, automation score and weighted complexity at domain and category level.

INSPECT

View issue-level detail

Select an L3 issue to see its full path, volume, complexity, automation score, tier, recommended action and additional Excel metadata.

Practitioner perspective

What a useful issue taxonomy should enable

A good issue tree is not merely a reporting taxonomy. It should create a common problem language across operations, transformation, digital, technology and analytics teams so that demand can be measured, root causes can be investigated and interventions can be matched to the right level of the problem.

Mutually understandable issue definitions

Teams should know what each issue includes and excludes so volume data and analysis remain comparable.

Enough granularity to support action

L3 issues should be specific enough that teams can investigate workflow, policy, system and customer-experience causes.

Demand linked to the problem structure

Volume should roll from individual issues to categories and domains so leaders can see both concentration and detail.

Prioritization separated from feasibility

The issue tree should tell you where to investigate first; deeper feasibility work should determine what should actually be automated or redesigned.

How to use it

Use the issue tree at the front end of transformation discovery.

Start with the supplied taxonomy or replace it with your own.

The included workbook provides a banking customer-service starting point. Adapt L1, L2 and L3 definitions to reflect the target operation.

Validate the taxonomy with operations SMEs.

Check that issue definitions reflect how customers actually present problems and how the operation currently classifies demand.

Replace modeled volumes with real demand data.

Use contact-reason, CRM, speech/text analytics, case-management or operational data where available so prioritization reflects the actual environment.

Assess complexity at L3.

Use a consistent view of complexity to distinguish simple information or status issues from multi-step, exception-heavy or judgment-intensive problems.

Load the workbook into the HTML explorer.

Open the connected HTML file, click Load / Refresh Excel and select the workbook. The explorer reads the taxonomy directly from Excel.

Use the ranking to identify where deeper analysis should begin.

Focus first on high-demand, lower-complexity issues or categories with concentrated demand, then validate them through workflow and automation-feasibility analysis.

Connect shortlisted issues to downstream transformation tools.

Move promising L3 issues into process mapping, automation feasibility, technology-readiness, business-case and roadmap sequencing work.

Where it is most useful

Use it before jumping from a broad process problem directly to a solution.

Process mapping & decomposition

Break a broad end-to-end process into progressively more actionable problem categories before detailed workflow mapping begins.

Conversational AI discovery

Identify a comprehensive candidate-intent universe and distinguish high-volume simple issues from complex or exception-heavy demand.

Process improvement

Use L3 issues as the starting point for root-cause analysis, journey mapping and process redesign rather than treating broad categories as problems.

Automation opportunity screening

Prioritize where deeper feasibility assessment should begin based on demand and complexity.

Demand & root-cause analysis

Create a consistent taxonomy that can be linked to volumes, repeat demand, complaints, defects, failure points and other operational evidence.

Transformation portfolio design

Translate a large universe of customer problems into structured workstreams and candidate initiatives for roadmap development.

Adaptability

The methodology is industry-agnostic; banking is simply the worked example.

The same L1-L2-L3 structure can be applied to customer journeys, back-office processes, operational workflows, product issues, service demand or enterprise problem landscapes across industries. Replace the domain taxonomy, issue statements, demand volumes and complexity inputs while keeping the decomposition and prioritization logic intact.

The transferable principle is to create a sufficiently granular problem architecture before choosing the intervention. A high-level process tells you where the problem sits; an L3 issue tells you what must actually be understood, fixed, redesigned or automated.

Decision questions

Questions this framework is designed to help answer

How do you build an issue tree for process mapping and transformation discovery?
How do you decompose a broad process or problem domain into actionable L1, L2 and L3 issues?
How should operational demand be structured before root-cause analysis, process redesign or automation?
How do you identify high-volume, low-complexity automation opportunities?
How can an L1-L2-L3 issue taxonomy support process mapping, customer-journey analysis or Conversational AI discovery?
How do you connect customer issue volumes to transformation prioritization?
What should happen after an issue is identified as a high-potential automation candidate?
Consulting application

Good transformation starts with a better definition of the problem landscape.

An issue tree creates the bridge between broad process or performance metrics and actionable transformation design. It helps leaders see where demand is concentrated, gives cross-functional teams a common taxonomy and creates a disciplined starting point for deeper process, technology and value analysis.

I use this type of issue-tree work at the front end of process transformation, root-cause analysis, customer-service transformation, automation discovery, Conversational AI and operating-model redesign — before individual solutions are selected or roadmaps are committed.

Frequently asked questions

About the toolkit

What is a process issue tree?

An issue tree organizes a complex process, problem or demand landscape hierarchically, moving from broad domains to issue categories and then to specific actionable problems. This makes the landscape easier to map, measure, analyze and prioritize.

What do L1, L2 and L3 mean in this toolkit?

L1 is the broad service domain, L2 is the issue category within that domain, and L3 is the specific customer problem statement where deeper process or automation analysis can begin.

How does the automation score work?

The included model multiplies issue-volume percentage by an ease factor based on complexity: 3 for low complexity, 2 for medium and 1 for high. The result is used as an initial opportunity-screening score.

Does a Quick Win tier mean the issue should automatically be automated?

No. It means the issue deserves early validation based on the model's demand and complexity inputs. Workflow, data/API, risk, business-rule and ROI feasibility should still be tested before implementation.

Can I use the framework outside banking or customer service?

Yes. Banking is the supplied worked example. The HTML explorer reads the Excel workbook, so you can replace the L1, L2 and L3 taxonomy, volumes, complexity and metadata with your own process, function, product, service or operational problem landscape.

Is this useful for Conversational AI?

Yes. The issue tree can help create and validate an intent universe, identify where demand is concentrated and provide a starting point for deciding which intents should remain informational, move into guided workflows or progress to deeper transactional automation.

Continue exploring

Explore related ConsultHarish content

The issue-tree toolkit sits within a broader body of work on customer operations, process redesign, AI, automation economics and enterprise transformation.

About the author

Harish Rao is an independent transformation advisor focused on business process transformation, AI-led digital transformation, customer operations and enterprise program execution. Read more about Harish →

Practical transformation asset

Map and structure the problem landscape before deciding what to redesign or automate.

Download the toolkit and use it to structure complex process or demand landscapes, identify priority problem areas and create a stronger starting point for root-cause analysis, process redesign, automation discovery and transformation prioritization.