
Kanban Flow Analyzer
Analyze Kanban board data to identify bottlenecks and optimize team flow
What You Can Do
You can systematically diagnose flow problems in your Kanban board by analyzing stage-by-stage work accumulation, cycle time patterns, and throughput trends. The skill generates flow metrics dashboards, identifies capacity constraints, forecasts delivery dates based on historical data, and produces prioritized improvement recommendations with estimated impact—giving you objective evidence to guide WIP adjustments, process changes, and retrospective discussions.
Features
Calculate cycle time, throughput, WIP efficiency, and SLA compliance across all board stages
Pinpoint stages where work accumulates, quantify frequency and impact, and identify systemic constraints
Generate delivery date estimates and throughput projections based on historical velocity patterns
Prioritize flow interventions (WIP limit changes, process redesign, resource reallocation) with estimated ROI
Break down total cycle time by stage to reveal where time is spent versus where work stalls
Track compliance rates and identify which work classes or item types miss deadlines most often
Data-driven prompts and discussion templates for flow-focused team retrospectives
Detect throughput variations, identify recurring congestion windows, and forecast seasonal impacts
Example Output
Flow Metrics Summary:
- Average cycle time: 12.3 days (target: 8 days)
- Monthly throughput: 34 items
- WIP efficiency: 68% (work actively progressing vs. waiting)
- SLA compliance: 78% (target: 95%)
Bottleneck Analysis:
- Code Review stage: 4.2 days average dwell time (43% of total cycle time)
- Test/QA stage: Work accumulates to 6–8 items on Fridays; Monday releases clear queue
- Deployment: 2–3 day variance due to manual coordination
Top 3 Improvement Recommendations:
- Reduce Code Review WIP limit from 8 to 5 and establish 4-hour review SLA → Estimated 2-day cycle time reduction
- Shift QA testing earlier (pair with dev) → Reduce Test stage dwell time by 40%
- Automate deployment checklist → Stabilize deployment stage variance to <8 hours
What's Included
- kanban-flow-analyzer SKILL.md: Complete system prompt for analyzing board data, calculating metrics, and generating recommendations
- Flow metrics template: Spreadsheet calculator for cycle time, throughput, WIP, and SLA tracking
- Bottleneck analysis worksheet: Stage-by-stage accumulation tracker with frequency and impact assessment
- Improvement prioritization framework: Scoring matrix to rank flow interventions by effort and estimated cycle time reduction
- Retrospective facilitation guide: Data-driven discussion prompts and action item templates for flow-focused retrospectives
Who It's For
- Scrum Masters — Diagnose flow problems objectively and guide team process improvements with data
- Kanban coaches — Analyze board health across multiple teams and benchmark flow metrics
- Engineering managers — Forecast delivery dates, manage stakeholder expectations, and justify WIP limit and process changes
- Delivery leads — Identify why cycle times are inconsistent and prioritize capacity constraints to fix
- Product owners — Understand which work stages delay delivery most and negotiate realistic commit dates
Best For
- Measuring and communicating flow health to leadership and stakeholders with quantified bottleneck analysis
- Designing or adjusting WIP limits based on real throughput data and stage-specific accumulation patterns
- Forecasting delivery dates and projecting throughput for quarterly planning and commitment conversations
- Preparing data-driven retrospectives focused on flow optimization rather than individual performance
- Evaluating the impact of process changes (new definition of done, deployment automation, team restructuring) on cycle time







