AI Solutions Case Study

ST0117 Level 4 Business Analyst · Apprenticeship with AI Integration

What a Business
Analyst Finds
in Four Months

Three industries. Real analytical work. Evidence that the apprenticeship route delivers an investment return the consultancy route cannot match.

91
Agentic AI opportunities identified
3
Businesses across 3 industries
4
Months into an 11-month programme
£900
Max cost /apprentice (non-levy)
2
About This Document

Real work. Real numbers. Real businesses.

All three businesses in this portfolio have been anonymised. What has not been anonymised is the analytical work itself — the process maps, AI opportunity catalogues, ROI portfolios, and implementation roadmaps are genuine outputs from the first four months of the programme.

🎯
Chief Executive Officer

Your business moves from AI-curious (Stage 2) to AI-architect (Stage 4–5) within four months — without commissioning a single external consultant. By programme end, month 11, you hold a 3-year deployment roadmap for 20-30 agentic AI opportunities, six+ AI applications in production, and an internal capability that continues to compound independently. When the strategy needs updating next year, you do not pay consultancy rates again. The expertise is already inside the building.

20–40%
Revenue increase expected
~400x–700x
ROI on programme cost
Stage 4–5
AI maturity at month 4
💷
Chief Financial Officer

Three consultancy cost lines disappear — all related to buying in external capability rather than building it internally. The initial AI strategy and roadmap (£100–250k). The build-out of 30-plus priority applications (£250–400k). And the ongoing maintenance and iteration consultancy that recurs every year the business wants to keep its AI current (£30–50k pa). The total employer cost for the apprenticeship that replaces all three: £0 for levy payers, £900/apprentice for non-levy. If your levy account is sitting unspent, every month of delay is money expiring.

£350k–£650k
Year-1 cost avoidance
£30–50k pa
Ongoing maintenance avoided
£0–£900 per apprentice
Total employer cost
⚙️
IT Director

You receive requirements that are actually specific — every solution classified by complexity category (1–4), every Category 4 build accompanied by a build-vs-buy threshold analysis that tells you precisely when SaaS is cheaper than custom development. In one portfolio, two build-vs-buy decisions alone saved £91,000 in development cost. The apprentice understands the full spectrum from no-code quick wins through to custom AI applications — and can work alongside your team to specify, prioritise, and co-design solutions that your developers can actually build without ambiguity.

Cat 1–4
Solution complexity framework
3 year roadmap
20-30 Agentic Apps Specified by Users
6+ apps built
No-code low code
📋
Head of Departments

Your operation is mapped end-to-end — probably for the first time. Every friction point, every failure mode, every handoff that is silently losing value is named, documented, and addressed at the right level of complexity. Knowledge that currently lives only in your best people’s heads is captured and systematised before it walks out the door. Your team moves from managing daily operational chaos to managing the exceptions that actually require human judgement. Admin that no professional should still be doing is automated. What requires skill gets it.

All Processes
Mapped & Optimised
10–20%
Operating cost reduction
30–60%
Quality improvement
0.3 – 5x
Time Saving
3
The Methodology

Four analytical disciplines. One framework.

These are the core skills at the centre of the ST0117 standard — and exactly what is needed to surface AI opportunities that are grounded in business reality rather than theoretical possibility.

01
Structured Elicitation

One-to-one structured interviews with every person who runs the business. Not surveys — conversations that surface what people actually do, not what the procedure says they do. 28+ interviews across three businesses.

02
Pipeline Mapping

End-to-end process maps showing every stage, every role, every failure mode, and every risk rating. Once mapped, AI opportunity signals become visible at every friction point. 70+ stages documented.

03
Opportunity Classification

Every AI opportunity classified by complexity — from a five-minute prompt template (Cat 1) to a six-month agentic AI build (Cat 4). The skill is knowing which level each problem belongs at. 91 opportunities classified.

04
ROI Framework

Each opportunity financially evaluated: development cost, annual saving, ROI %, payback period, and a build-vs-buy threshold — transforming poorly prioritised portfolios into high-return, phased implementation plans.

Category 1–4
Solution complexity framework
Tier 1–3
Implementation timeline framework
Build vs Buy
Monthly SaaS threshold analysis
Case Study A

The Multi-Site Dental Group

A fee-for-service dental practice with 5+ dentists and 3+ hygienists. Premium market positioning. FCA-adjacent compliance environment.

12
Stakeholder interviews
3
Patient pipelines mapped
34
AI Buddies identified
Dental team collaboration
The core finding: invisible revenue loss at both ends of the patient journey.

Over 50% of inbound enquiries arrive after hours and are never seen. One person converts at 90%+; everyone else converts at a fraction of that. Hundreds of thousands of dollars in outstanding treatment plans sit in a task list that is never systematically worked through.

🔔 Out-of-Hours Lead Engagement
Captures every after-hours enquiry. Target: 80%+ lead recovery from 0% current.
Very High Impact
📋 Treatment Plan Follow-Up
Manages outstanding plans automatically — prioritised daily outreach list for the treatment co-ordinator.
Very High Impact
🎙️ Clinical Transcription
Replaces 1 hr/day of memory-based note-writing (75–80% accuracy) with near-100% transcript capture.
High Impact
📁 Treatment Co-ordinator Brief
Replaces “they need a crown” with full clinical and emotional patient context before every presentation.
Very High Impact
🔬 Examination Quality
“The biggest revenue loss opportunity” — standardising examination depth across all clinicians.
Very High Impact
✅ Compliance Audit
Replaces 30–60 min daily manual schedule checking with automated overnight run. Saves 2.5–5 hrs/week.
Moderate Impact

+ 28 further AI Buddies identified including 14 deployable immediately via prompt templates.

Case Study C

The Regional Insurance Brokerage

A multi-line insurance brokerage with 15+ call advisors across personal lines, commercial, motor trade, and specialist heritage. FCA-regulated, MS365 environment, and operating at scale across multiple departments.

10+
Stakeholder interviews
4
Departments mapped
24
AI solutions identified
The core finding: revenue, quality, and knowledge all leaking through the same structural gaps.

Lead generation is entirely dependent on business hours and a single seasonal window. Call quality monitoring covers only 3–4% of conversations. An expert whose product knowledge spans multiple lines is leaving — with no systematic way to capture what he knows. Cross-sell opportunities are identified informally and inconsistently across 15+ advisors. Every one of these gaps is addressable with no-code and low-code AI solutions already available to the IT team.

💬 Awareness to Lead Chatbot
24/7 AI-powered engagement converts website visitors and inbound enquiries into qualified leads before a human advisor is ever needed. Captures intent, qualifies budget, and routes to the right team automatically.
Cat 4 · Custom AI App
📞 AI QA Monitoring System
Monitors 100% of advisor calls against quality and compliance standards — replacing a 3–4% manual sample. Every conversation scored, every coaching opportunity surfaced, FCA audit trail built automatically.
Cat 3 · AI Prompt
📈 AI Cross-Sell Analyser & Lead Generator
Analyses existing customer portfolios in real time and surfaces cross-sell opportunities during live advisor conversations. Turns every inbound call into a structured commercial conversation.
Cat 3 · AI Prompt
🧠 AI Knowledge Base for Advisors
Instant answers to complex underwriting and product questions — removing the dependency on a single expert whose knowledge currently has no backup and is walking out the door.
Cat 3 · AI Prompt
📊 Power BI Dashboard Suite
Consolidates advisor performance, budget tracking, and sales pipeline data across all lines into a single live management view. Replaces manual weekly reporting across multiple spreadsheets.
Cat 1 · Quick Win
🎭 AI Call Emotional Intelligence Assessor
Reads emotional signals in customer conversations to help advisors identify hesitation, frustration, and buying readiness — and adapt tone and approach before the call is lost.
Cat 3 · AI Prompt

+ 18 further solutions across Categories 1, 3 and 4 — including HR, finance, compliance, operations, and training functions. All no-code or low-code, deployable by the IT team without external development resource.

Cross-Case Synthesis

Three industries. The same five problems.

Whatever the sector, the same structural failures appear. A business analyst who maps the pipeline end to end makes these invisible problems visible — and then designs the right level of intervention for each.

1
Lost leads at the first touchpoint
Revenue generated through marketing leaks away before any human contact is made. The cost of recovering an already-interested lead is low. The cost of regenerating intent from scratch is high.
50%+ of dental enquiries lost after hours. Zero out-of-hours engagement exists before the programme.
2
Knowledge in one person’s head
The best qualification script, the deepest product knowledge, the most effective call technique — all personal, all non-transferable, all at risk of leaving the business permanently.
One expert leaving the brokerage would take irreversible product knowledge with him.
3
Manual data entry everywhere
Paper forms, spreadsheets, hand-written logs — generating transcription errors, compliance risk, and hours of avoidable administrative work that no professional should still be doing in 2026.
Insurance breakdown form: 40–50 data points transcribed manually per patient.
4
The handoff problem
Critical context is lost at every role transition. The person receiving the handoff makes worse decisions because they are working with insufficient information from the person who passed the work.
Treatment co-ordinator received “they need a crown” as her complete briefing before a £2,000+ conversation.
5
Invisible revenue
Revenue not generated is invisible in ways revenue lost is not. Missed examinations, unanswered enquiries, and uncompleted treatment plans produce no report, no alert, and no visible failure signal.
“Dentists say patients don’t need work — but patients don’t know they need work.”
Functional Impact

What this means for every team in your organisation

The BA’s analytical work connects directly to the priorities of every function — because every function has the same underlying problems in different forms.

💻
IT Team

Gets tighter requirements, specific process context, and a build-vs-buy recommendation for each solution. No longer reverse-engineering what the operations director actually meant. Moves from order-taker to co-architect.

📣
Marketing Team

Lead capture automated. Newsletter generation from hours to minutes. WhatsApp engagement platform turning campaign-driven contact into always-on conversation. Frees marketers for strategy and creative work.

📈
Finance Team

Manual reporting replaced by real-time dashboards. P&L generation automated. Statistics assembly eliminated. Finance moves from assembling last week’s numbers to providing strategic intelligence on this week’s decisions.

⚙️
Operations Team

Process mapped for the first time. High-risk stages identified and addressed. Pipeline visibility replaces the status-update meeting. Team moves from managing daily chaos to managing the exceptions that actually need human judgement.

Six Commercial Outcomes
📈
New customer acquisition
Lead leakage fixed at the first touchpoint — the highest-ROI intervention in every portfolio.
💎
Increased customer LTV
Outstanding treatment recovery, cross-sell activation, referral programmes — all automated and systematic.
💰
Reduced acquisition costs
SaaS-first decisions and internal builds reduce development cost by £200k+ per portfolio.
⏱️
Lower operating costs
Rule-based admin eliminated across all roles. 5+ hours per week per person recovered on average.
Quality improvement
Note accuracy 75–80% → near-100%. Call coverage 3–4% → 100%. Order errors → near-zero with validation.
🔗
Cross-dept co-ordination
IT and business share the same map and the same analysis. Joint ownership — not as a governance principle, but because the work was done together.
9
AI Maturity Framework

From Curious to Architect in four months

All three apprentices started at Stage 1–2. By month four, the evidence across the case studies places them firmly at Stage 4 (Architect), with early Stage 5 (Builder) indicators.

01
Curious
Basic prompts
02
Realist
AI-assisted tools
03
Visionary
Business use cases
04
Architect
Deployment roadmap
NOW
05
Builder
AI implementation
06
Innovator
ROI optimisation
07
Master
Self-learning apps

Green = reached at month 4  ·  Teal = on trajectory  ·  Stage 6–7 expected within 2–3 years post-programme

Transformation journey
£
The Investment Case

Five dimensions of financial return.

The consultancy route produces documents. The apprenticeship route produces documents — and retains the person who produced them, growing toward Stage 6–7, with permanent context embedded in the business.

1. Strategy & roadmap
Stakeholder elicitation, pipeline mapping, AI opportunity catalogue, phased implementation plan
£100k–£250k saved
2. Build-out cost
30+ priority solutions; 6 applications built internally during programme
£250k–£400k saved
3. New customer acquisition
Lead recovery, always-on engagement, improved conversion — scales with business size
20–40% increase
4. Customer lifetime value
Cross-sell activation, treatment follow-up, aftercare and referral — scales with business size
10–30% increase
5. Operating cost reduction
Rule-based admin automated across all functions — scales with business size
10–20% reduction
6. Ongoing maintenance avoided
Internal expert continues to develop; no consultancy re-engagement needed
£30–50k pa saved
Year-one cost avoidance (strategy + build) £350k–£650k
Business impact of deployed AI — across all three case studies
20–40%
New customer acquisition
10–30%
Customer lifetime value
10–20%
Operating cost reduction
30–60%
Quality improvement
Your investment (non-levy employer)
£900
5% of £18,000 levy funding over 11 months

For levy employers (payroll > £3M): the cost is zero. The levy sits in a digital account that expires if unspent.

~400x–700x
Return on the £900 apprenticeship investment in year one
What the programme delivers
Strategy & roadmap (vs consultancy) £100k–£250k avoided
Build-out of 30+ solutions £250k–£400k avoided
Ongoing maintenance & iteration £30–50k pa avoided
New customer acquisition 20–40% increase
Quality improvement 30–60% improvement
Life Time Customer Value 10–30% increase
Ready to find out what your business needs?
ST0117 Level 4 Business Analyst Apprenticeship with AI Integration · 11 months · Levy funded
Book a Discovery Call

All businesses in this document have been anonymised. Outputs are genuine work produced during the first four months of the programme. © Master Agentic AI Academy 2026.

Scroll to Top