Ad-Hoc Request Queue & Analyst Capacity

Beacon Health Analytics · 9 Analysts · 220 Requests/Quarter

North-Star Goal
P1 Cycle Time: 5.2→3.5d
Open Backlog
52
+18% vs target
Median Cycle Time
4.1d
-8% vs 4.5d
Throughput/FTE
6.8
requests/wk
Rework Rate
14%
Above 10% threshold
SLA Attainment
87%
Target: 90%
Escalations
3
this month

Cumulative Flow – 12 Week Backlog

Median Cycle Time by Priority

18 Open Requests – Aging Analysis

Req ID Business Unit Title Priority Days Open Analyst Status
REQ-2847 Marketing Campaign ROI by Cohort P1 12 Sarah Chen In Build
REQ-2839 Finance Variance Analysis FY24 Q3 P2 8 James Park QA Review
REQ-2851 Operations Supply Chain Lead Time Trends P3 5 Maria Lopez Intake
REQ-2822 Marketing Customer Segment Performance P1 18 David Kim Rework
REQ-2834 HR Headcount by Department P3 7 Alex Johnson In Build
REQ-2845 Product Feature Adoption Funnel P2 9 Sarah Chen Acceptance
REQ-2856 Finance Budget vs Actuals Deep Dive P1 3 James Park Intake
REQ-2829 Marketing Email Open Rates by Campaign P3 11 Maria Lopez In Build

Analyst Utilization Heatmap

Week 1
Week 2
Week 3
Week 4
Sarah Chen
98%
92%
105%
88%
James Park
82%
91%
79%
72%
Maria Lopez
68%
75%
71%
84%
David Kim
94%
102%
89%
93%
Alex Johnson
77%
81%
69%
76%
<75%
75-85%
85-95%
>95%

Top Duplicate Request Themes (Pareto)

Template Created: "Campaign ROI by Cohort" appeared 7 times. Template saved 34 analyst hours this quarter.

SLA Attainment Trend by Business Unit (12 Weeks)

Week 8 Escalation: Product launch drove P1 SLA miss in Marketing. 3 requests escalated to Data Leadership.
KB Reuse Saves
48 hrs
Templates avoided duplicate builds this month
Avg Complexity
6.4 hrs
Complexity-weighted hours per request
First-Time Accept
86%
Requests accepted without rework