AI for Operations Certification
Proficient · M21 · lesson 21 of 27 · queued
Preview — browse every lesson free. Enroll to mark lessons complete, open partner links and save your progress. Login & enroll →
Multi-Step Workflows: Combining Analysis, Planning, and Execution
📖
now learning

Multi-Step Workflows: Combining Analysis, Planning, and Execution

15 min

Overview

Tuesday morning, your operations team identifies a quality trend: defect rates in Plant B are 18% higher than historical average. You need to: understand why, propose corrective action, draft an implementation plan, communicate it to plant management, and get executive sign-off.

Old approach: You spend 6 hours analyzing data, write a summary, hand it to the process engineer who spends 4 hours designing a solution, hand that to the improvement manager who spends 3 hours drafting an implementation plan, hand that to communication who drafts a memo. Total: 13+ hours of human work, plus 2-3 days of elapsed time because work happens sequentially.

Multi-step workflow approach: You structure a chain of AI tasks. Analyze the data → Identify root causes → Propose solutions → Design implementation → Draft communication plan. Each task feeds into the next. You review outputs at quality gates (after analysis and after solution proposal). The AI completes what would have taken 13 hours of human sequential work in 30 minutes. Then you spend focused time on judgment decisions and verification.

This is Level 3 operations: integrating AI into complete workflows, not just individual tasks. The key challenge isn't running the tasks. It's ensuring quality across the chain and catching errors before they propagate.

What a Multi-Step Workflow Looks Like

A multi-step workflow has five components:

Component 1: Input Structuring

Format the raw input in a way that the first AI task can work with. This might be data, context, constraints, or a combination.

Component 2: Step 1 - Analysis

First task analyzes the input and produces structured output: What's the current state? What patterns do you see? What are the constraints?

Component 3: Step 2 - Problem Identification

Takes the analysis output and digs deeper: What's actually wrong? What's the root cause? Which factors matter most?

Component 4: Step 3 - Solution Design

Takes the problem identification and proposes solutions: What options exist? Which is most feasible? What are the trade-offs?

Component 5: Step 4 - Implementation Planning**

Takes the solution and produces an operational plan: How do we implement this? What are the steps? Who's responsible? What's the timeline?

Component 6: Step 5 - Communication**

Takes the implementation plan and drafts stakeholder communication: How do we explain this decision? What's the messaging for different audiences?

Each step has a quality gate where a human reviews and either approves, requests modification, or escalates.

Important: Multi-step workflows amplify errors. If Step 1 makes an incorrect assumption, Steps 2-5 build on that assumption. An error in Step 2 propagates to Steps 3-5. You need quality gates at critical junctures, not just at the end.

Before AI vs. With AI: Process Improvement Workflow

Before AI: Process improvement took weeks. Data analysis phase: 2-3 days. Root cause analysis: 2-3 days. Solution design: 3-4 days. Implementation planning: 2-3 days. Communication: 1-2 days. Total: 10-16 days of elapsed time, with multiple handoffs and rework cycles because downstream teams discovered issues upstream teams missed.

With multi-step AI workflows: Analysis phase completes in hours. Root cause analysis completes in minutes (AI review, human judgment). Solution design completes in minutes (AI generates options, humans evaluate). Implementation planning completes in an hour (AI drafts plan, humans refine). Communication: AI drafts, humans approve. Elapsed time: 1-2 days, mostly for human review and decision-making. Volume of human work: reduced from 40+ person-hours to 6-8 person-hours of focused judgment work.

The speed gain matters less than the focus shift: humans now spend time on judgment and verification, not on mechanical drafting and analysis.

Designing Multi-Step Workflows: Output-as-Input Pipelines

The key to effective multi-step workflows is designing each task so its output becomes clean input for the next task. This is "output-as-input" design.

Example Workflow: Supply Chain Risk Assessment

Step 1 Prompt (Analysis):

"Analyze our supplier base using this data [raw supplier data]. Produce a structured output with: (A) Supplier concentration by category (list top 3 suppliers per category and their percentage of total spending). (B) Geographic concentration (list countries and percentage of total spend). (C) Financial risk indicators (note any suppliers with recent credit rating changes or financial distress signals). Output format: structured JSON with each category clearly delineated."

Step 1 Output (becomes Step 2 Input):

```json
{
"supplier_analysis": {
"concentration": {
"raw_materials": [
{"supplier": "Supplier A", "spend_pct": 45},
{"supplier": "Supplier B", "spend_pct": 28},
{"supplier": "Supplier C", "spend_pct": 18}
],
"transportation": [...]
},
"geographic_concentration": {
"north_america": 62,
"asia_pacific": 28,
"europe": 10
},
"financial_risks": [
{"supplier": "Supplier A", "risk": "Single-source dependency + 45% of category spend"}
]
}
}
```

Step 2 Prompt (Risk Identification):

"Based on this supplier analysis [insert Step 1 output], identify concentration risks. Prioritize them by impact to operations if the supplier fails. Output format: Risk ID, Supplier, Category, Current Impact (dollars at risk), Probability (1-5), Mitigation Difficulty (1-5), Overall Risk Score (Impact × Probability × (6-Mitigation))."

Step 2 Output (becomes Step 3 Input):

```json
{
"concentrated_risks": [
{
"risk_id": "RISK-001",
"supplier": "Supplier A",
"category": "raw_materials",
"impact_usd": 8400000,
"probability": 3,
"mitigation_difficulty": 4,
"risk_score": 36
}
]
}
```

Step 3 Prompt (Mitigation Planning):

"Based on these identified concentration risks [insert Step 2 output], propose mitigation strategies. For each risk, provide: (A) Option 1 with pros/cons and implementation cost, (B) Option 2, (C) Option 3. Prioritize options by feasibility and cost-benefit. Output format: Risk ID, Option 1 [Design, Cost, Timeline, Benefit], Option 2, Option 3, Recommended Option."

Step 3 Output (becomes Step 4 Input):

```json
{
"mitigation_options": [
{
"risk_id": "RISK-001",
"options": [
{
"option_num": 1,
"approach": "Dual-source 25% of Supplier A volume to Supplier B",
"implementation_cost": 280000,
"timeline_months": 4,
"benefit": "Reduces Supplier A single-source risk from 45% to 33.75%"
}
],
"recommended": 1
}
]
}
```

Step 4 Prompt (Implementation Planning):

"Based on these recommended mitigations [insert Step 3 output], create a detailed implementation plan. For each mitigation, specify: (A) Project phases, (B) Resource requirements, (C) Timeline and milestones, (D) Success criteria, (E) Risk mitigations for the implementation itself. Output format: Structured JSON with phases, timelines, resource types, success metrics."

Step 4 Output (becomes Step 5 Input):

```json
{
"implementation_plans": [
{
"risk_id": "RISK-001",
"mitigation_option": 1,
"phases": [
{
"phase": "Phase 1: Qualification",
"timeline": "Month 1-2",
"activities": "Qualify Supplier B for volume increase",
"resources": "1 procurement specialist, quality engineer"
}
]
}
]
}
```

Step 5 Prompt (Communication):

"Based on this implementation plan [insert Step 4 output], draft communication for three audiences: (A) Executive summary (1 page, CFO audience), (B) Operational brief (2 pages, operations team), (C) Supplier communication (brief, for Supplier B). Each should explain the risk, the mitigation approach, and what's expected. Output format: Three separate documents."

This is output-as-input design: each step's structured output becomes the input for the next step. No manual reformatting. No information loss. Quality gates happen at decision points, not at every step.

Tip: Define a consistent JSON schema across your workflows. If all your analyses produce JSON with "id," "priority," "impact," "mitigation," your downstream steps can process outputs programmatically. This enables automation of the routing to quality gates.

Failure Scenarios: When Workflows Break Down

Scenario 1: Garbage In, Garbage Out Amplification

Step 1 analyzes supplier data but misses a critical data field (supplier financial condition). All downstream steps build plans around an incomplete picture. Step 5's communication presents a mitigation plan that doesn't address the actual risk because the risk wasn't identified in Step 1. You've invested hours in a flawed analysis that looked complete but was built on incomplete data.

Root cause: No quality gate after Step 1. You assumed the data was complete without verifying.

Mitigation: Place a hard quality gate after Step 1 where a human data expert verifies data completeness and quality before proceeding. Ask: "Do we have all the data we need? Are there missing fields? Are there data quality issues?" Until this gate passes, Steps 2-5 don't start.

Scenario 2: Assumption Drift and Divergence

Step 1 assumes supplier failure probability of 3% based on historical data. Step 2 builds risk scores around that assumption. Step 3 designs mitigations assuming that probability. Step 4 estimates implementation costs assuming 3% probability. By Step 5, no one remembers that the original assumption was "historical data", which might not reflect current market conditions where suppliers are more fragile. You implement an expensive mitigation for a risk that's actually higher than 3% (more likely to occur, requires bigger mitigation).

Root cause: Assumptions were not explicitly carried forward. Each step made local decisions without validating upstream assumptions.

Mitigation: Explicitly carry assumptions from step to step in a "assumptions document." Each step explicitly lists assumptions it's making. Quality gates review assumptions: "Is the 3% failure assumption still valid? Has market changed? Should we revise?" Assumption drift is caught at quality gates, not at the end when mitigation is already planned.

Scenario 3: Scale Misalignment and Incoherence

Step 1 produces results at "supplier category" level (e.g., "raw materials, electronics, logistics"). Step 2 tries to analyze risk at "individual SKU" level (specific parts). The mismatch causes Steps 3-5 to make recommendations at inconsistent granularity. Mitigation Step 1 is category-level ("diversify raw material suppliers"). Mitigation Step 2 is part-level ("qualify alternate source for circuit board Z-47"). You get implementation plans where some mitigations are broad-stroke strategic changes and others are tactical part-level changes. Execution becomes incoherent.

Root cause: Data granularity was not defined upfront. Step 1 chose one granularity; Step 2 chose another. No coordination.

Mitigation: Define data granularity for each step upfront. Write it in the prompt: "Analyze at the supplier category level, not individual SKU level. Provide recommendations at the category level." Make granularity explicit and consistent across all steps. In quality gates, verify: "Are all analyses at the same granularity? Is the implementation plan at the appropriate level of detail?"

Scenario 4: Over-Reliance on Earlier Steps**

Step 3 (solution design) gets a risk identification from Step 2. It designs mitigations to address those identified risks. But Step 3 doesn't independently ask "are there solutions that address even broader problems?" It's trapped in solving Step 2's identified risks rather than thinking about solutions more broadly.

Root cause: Each step sees the previous step's output as constraints rather than inputs to be synthesized with other thinking.

Mitigation: In Step 3+ prompts, explicitly ask: "These risks were identified in Step 2. Design solutions to address them. Also consider: are there higher-level solutions that address even broader problems? Should we recommend a different approach entirely?" This allows later steps to feedback to earlier steps rather than blindly following earlier outputs.

Quality Gates in Multi-Step Workflows

A quality gate is a checkpoint where human judgment verifies that the workflow should continue.

Critical Quality Gates:

Gate 1: After Analysis (Step 1)

Does the AI have the right data? Is the analysis complete? Are there data quality issues? This gate prevents bad data from propagating downstream.

Gate 2: After Risk Identification (Step 2)

Did the AI identify all material risks? Are risk scores reasonable? Are there risks the AI missed that a human expert would catch? This gate prevents the workflow from optimizing solutions for the wrong problems.

Gate 3: After Solution Design (Step 3)

Are the proposed solutions operationally feasible? Do they actually mitigate the identified risks? Is the recommended option sound? This gate prevents the implementation of solutions that look good on paper but won't work in practice.

Gates 4 and 5 (implementation planning and communication) are lower risk if gates 1-3 worked well.

For each gate, define:

  • Who reviews (data expert, operations manager, etc.)
    - What they're checking for (completeness, feasibility, risk assessment accuracy)
    - What happens if they reject (request modification, escalate, restart)

Real Schema: Multi-Step Workflow with Quality Gates

```json
{
"workflow": {
"workflow_id": "WF-2026-SUPPLY-RISK-001",
"name": "Supplier Concentration Risk Mitigation",
"created_date": "2026-04-09",
"steps": [
{
"step_num": 1,
"name": "Supplier Analysis",
"status": "complete",
"output_summary": "Identified 5 high-concentration suppliers representing 68% of total spending",
"quality_gate": {
"gate_status": "passed",
"reviewed_by": "Data Analytics Lead",
"review_date": "2026-04-09",
"notes": "Data is complete; analysis is sound. Ready for risk identification."
}
},
{
"step_num": 2,
"name": "Risk Identification",
"status": "complete",
"output_summary": "5 concentration risks identified; highest risk score 42 (Supplier A, raw materials)",
"quality_gate": {
"gate_status": "passed",
"reviewed_by": "Supply Chain Director",
"review_date": "2026-04-09",
"notes": "Risk identification is comprehensive. Recommend proceeding with mitigation design."
}
},
{
"step_num": 3,
"name": "Solution Design",
"status": "complete",
"output_summary": "Recommended dual-sourcing strategy; estimated cost $680K, timeline 8 months",
"quality_gate": {
"gate_status": "pending_review",
"assigned_to": "VP Operations",
"review_deadline": "2026-04-10"
}
}
]
}
}
```

Implementing Multi-Step Workflows: Step-by-Step

Step 1: Define Your Problem and Desired Output**

What problem are you solving with the workflow? "Quality issue in Plant B." What's your desired output? "A complete action plan including root cause analysis, cost impact, recommended solution, and implementation timeline." This defines the scope of the workflow.

Step 2: Decompose into Workflow Steps**

What sequence of steps gets you from "quality problem" to "action plan"? Typically: (1) Analyze data, (2) Identify root cause, (3) Estimate impact, (4) Design solutions, (5) Plan implementation, (6) Draft communication. More or fewer steps depending on complexity.

Step 3: Define Step Inputs and Outputs**

What data does Step 1 need? (Quality metrics, timeline, process documentation.) What should Step 1 produce? (Structured analysis with trends, patterns, hypotheses.) This output becomes Step 2's input. Design for structured, machine-readable handoff between steps.

Step 4: Write Step Prompts**

For each step, write a detailed prompt. Include: context about the workflow, what you're asking the step to do, what output format you expect. Make each prompt self-contained (include relevant context from previous steps rather than assuming AI remembers earlier steps).

Step 5: Design Quality Gates**

After which steps do you need human review before proceeding? Typically: after analysis (validate data quality) and after solution design (validate feasibility). Place gates at critical decision points.

Step 6: Test the Workflow**

Run it on a real problem. See where it breaks. Do outputs feed smoothly between steps? Do quality gates catch real issues? Refine the workflow based on testing.

Step 7: Operationalize**

Once the workflow is proven, document it. Build a template. Train people to use it. Integrate it into your decision-making processes.

Measuring Workflow Value

How do you know if your multi-step workflow is actually better than sequential human work?

Metric 1: Elapsed Time**

How long does the workflow take end-to-end (from problem to action plan)? Traditional sequential work: 2-5 days. Multi-step workflow with human quality gates: 4-8 hours. The time savings is dramatic.

Metric 2: Human Effort Hours**

How many human hours does the workflow consume? Sequential human work: 20-40 person-hours (analyst, engineer, planner, communicator each working independently). Workflow with AI: 4-6 person-hours (focused judgment and review time). The effort reduction is significant.

Metric 3: Quality of Decisions**

Are decisions made from workflow outputs better than decisions made from sequential human work? Ask decision-makers: "Is this analysis more complete? More thorough? Does it reveal factors you would have missed?" Track whether recommendations are actually implemented and whether they solve the problem.

Metric 4: Consistency**

When you run the workflow multiple times, do you get consistent quality? Workflows produce consistent output; human sequential work varies based on who's involved. If consistency is valuable (for repeatability, for audit), workflows win.

Monday Morning to Takeaways

Monday Morning Scenario Redux: Tuesday, 8:00 AM, you discover the quality issue in Plant B. By 8:30 AM you've fed quality data into a multi-step workflow. By 10:00 AM you have: analysis showing root cause (inadequate preventive maintenance schedule with clear data supporting this), risk identification quantifying cost impact ($1.2M scrap cost this quarter if uncorrected), proposed solutions (three maintenance schedule options with cost-benefit analysis), and implementation plan (Phase 1: schedule redesign 1 week, Phase 2: staff training 1 week, Phase 3: monitoring 2 weeks). You review the analysis (quality gate, data looks solid, root cause is credible), review solutions (quality gate, all three options are feasible), and select the recommended solution. By 11:00 AM you have a complete decision-ready analysis with implementation plan. You call the plant manager with the recommendation. What would have taken 2+ days of sequential work (different people analyzing, designing, planning, communicating separately) took 3 hours total elapsed time with focused human judgment at key decision points. The plant implements the fix, and quality returns to normal within 2 weeks.

Key Takeaways:**

  • Multi-step workflows chain analysis, planning, and communication tasks, where output from one step becomes input to the next.
    - Design for output-as-input: each step produces structured (typically JSON) output that feeds directly into the next step's input without manual reformatting.
    - Quality gates are critical. Place them after high-risk steps (analysis, solution design). They prevent errors from propagating downstream where they're expensive to fix.
    - Document assumptions explicitly and carry them through the workflow. Each step should validate assumptions from previous steps before proceeding.
    - Failure modes: garbage-in amplification, assumption drift, scale misalignment, over-reliance on earlier steps. Counter each with appropriate quality gates and validation.
    - Multi-step workflows free humans from mechanical work (drafting, data reformatting, synthesis) so they can focus on judgment and verification at quality gates.
    - Measure workflow value through elapsed time, human effort hours, decision quality, and consistency. All typically show dramatic improvement over sequential human work.

Frequently Asked Questions

Q: Can I automate the quality gates?

A: Partially. You can automate simple gates (e.g., "does output contain required fields?"). But subjective gates (e.g., "does the risk assessment look reasonable?") require human judgment. Mix automated and human gates.

Q: What if a quality gate rejects output?

A: Have a rework protocol. Typically: request modification to the output, rerun the step with revised prompt, re-review at the gate. Document what was wrong and how it was corrected. This is valuable learning for refining your prompts.

Q: How many steps should a workflow have?

A: 3-5 steps is typical. Beyond that, the workflow becomes hard to manage and quality gates proliferate. If you need more than 5 steps, consider breaking it into two separate workflows.

Q: Can I run workflows in parallel or only sequentially?

A: Primarily sequential (output of one step feeds next step's input). But you can have parallel branches if they don't depend on each other. E.g., communication can draft multiple audience messages in parallel. Just ensure they reconverge before final output.