Learning providers
Luminate
~6,500 learners
Bradford
~5,300 learners
Kirklees
~3,000 learners
Calderdale
~900 learners
Shipley
~900 learners
Heart of Yorks.
~800 learners
Leeds
~370 learners
Calderdale Cncl
~170 learners
IBP Strategy & Research
📁 ILR data store
File share holding each provider's monthly extract.
Load baseline & destination surveys
📋 Survey software (Snap)
Issues and collects the baseline & destination surveys (email / SMS / QR).
🔒 Pseudonymised at this boundary — names & contact details stripped
Data Platform
☁ Azure
- Resource group
- Fabric F2 pay-as-you-go capacity
- Automation (pause / resume)
📊 Microsoft Fabric ↑ ingests ILR data + survey responses into Bronze
ETL workspace F2 PAYG · paused when idle
BronzeRaw — ILR data + survey responses
→
SilverCleaned, matched, pseudonymised
→
GoldModelled — matched pairs, outcomes
↓
Gold → imported into the semantic model
Reporting workspace shared capacity · always available
Data modelImport semantic model
→
Power BI reportsWYCA sees all; each provider sees only its own (RLS)