The Coders Guild

Business Analysis

As-is analysis of the apprenticeship training operation. People, processes, data flows, and metrics - built from workshops, PICS/LMI data, and ops notes.

Analysis pages
People, Tools & Issues
Who's involved in the apprenticeship operation, what systems they use, and where the cross-cutting issues sit. From sales and delivery to compliance and finance.
  • 6 personas with jobs to be done
  • Tools landscape mapped by function
  • Cross-cutting issues across the operation
  • Pain points linked to process stages
View people & tools
Process Map
The apprenticeship lifecycle in 12 stages. From lead generation and employer engagement through enrolment, delivery, EPA, and programme closure.
  • 12 collapsible process stages
  • Decision points with branching paths
  • Actor and system tags per step
  • Pain points and opportunities mapped
View process map
Data Flow & Handoffs
System-to-system data flows across the apprenticeship lifecycle. Where data originates, how it moves between systems, and where handoff friction creates risk.
  • 8 handoff points between systems
  • Entity journey through the lifecycle
  • Data integrity risks identified
  • Manual vs automated flow mapping
View data flows
Metrics Inventory
What's tracked, what's partially tracked, and where the gaps are. Operational metrics mapped against the apprenticeship lifecycle stages.
  • Current metrics with tracking status
  • Gaps linked to process stages
  • Proposed new metrics with rationale
  • Owners and data sources identified
View metrics
Metrics Drill-down
Interactive tree from EBITDA down to operational activity metrics. Shows how enrolment, retention, and delivery efficiency connect to financial outcomes.
  • EBITDA to activity-level in 4 levels
  • Filter by department area
  • Tracking status at each node
  • Gaps and opportunities highlighted
Drill down
Project context
Client
The Coders Guild
Business
Apprenticeship training provider
Target
60 apprentices enrolled by June 2026
Sources
4 workshops, PICS/LMI data, ops notes
Status
Working document - March 2026
Prepared by
Specs