Build a portfolio that gets you a placement
Each project is graded by an instructor in a different sector — so your portfolio shows you can deliver across industries, not just the one you already know. Pass them all and earn your Junior or Senior placement.
HealthPY Core — Standalone
NHS commissioning activity-reconciliation pipeline. Build the weekly report every commissioning support unit runs against trust returns. Instructor-reviewed submission, reviewer feedback within 10 working days.
InsurancePY Core — Standalone
UK motor-claims FNOL reconciliation pipeline. Process claim notifications through the cover-rule × incident matrix every motor insurer runs. Instructor-reviewed submission, reviewer feedback within 10 working days.
LogisticsPY Core — Standalone
UK parcel-carrier SLA reconciliation pipeline. Derive service-level performance from multi-attempt scanner feeds with minute-precision datetime arithmetic. Instructor-reviewed submission, reviewer feedback within 10 working days.
PatientLT Core — Standalone
Single-table NHS Patient Snapshot capstone. Eight Board-ready outputs against PatientLT.Patient — GROUP BY, CASE, DATEDIFF, NULL-safe full-name concatenation, UNION ALL summary, single-row completeness audit. Assessor-led defence on completion.
EnergyLT Core — Standalone
Single-table Meter Read Snapshot capstone. Eight outputs against EnergyLT.MeterReading covering actual-vs-estimated splits, monthly consumption trends, failed-read audit, and a single-row completeness dashboard. Assessor-led defence on completion.
LogisticsLT Core — Standalone
Single-table Shipment Volume Snapshot capstone. Eight outputs against LogisticsLT.Shipment covering status mix, weight-band CASE distributions, SLA breach DATEDIFF, daily creation trend, and an unassigned-shipment audit. Assessor-led defence on completion.
HealthPY Applied — Standalone
Twelve-month NHS provider-variance investigation. Pandas-based analytics, casemix-drift detection, written findings doc reviewed by instructor. Feedback within 10 working days.
InsurancePY Applied — Standalone
Twelve-month loss-ratio decomposition and reserve-adequacy investigation. Pandas-based analytics, channel × cover × incident dimension, written findings doc. Feedback within 10 working days.
LogisticsPY Applied — Standalone
Twelve-month parcel-network performance investigation with postcode-mix adjustment. Direct standardisation, route-level anomaly detection, written findings doc. Feedback within 10 working days.
PatientLT Applied — Standalone
Twelve-output Clinical Data Quality Audit across the full PatientLT schema. Investigation Framework discipline, the four investigation patterns (orphan / duplicate / missing / reconciliation), and a reusable vw_PatientAuditCard View. 30-minute live code review.
EnergyLT Applied — Standalone
Twelve-output Customer & Billing Data Quality Audit across the full EnergyLT schema. Referral chains, debt-ageing FULL OUTER JOIN, contract-continuity checks, and a reusable vw_CustomerAuditCard View. 30-minute live code review.
LogisticsLT Applied — Standalone
Twelve-output Network Data Quality Audit across the full LogisticsLT schema. Depot-hub orphan detection, shipment-event sequence checks, SLA breach attribution, and a reusable vw_ShipmentAuditCard View. 30-minute live code review.
PatientLT Pro — Standalone
Seven-pane Clinical Analytics Engine — Views, recursive CTEs, parameterised stored procedure, window functions, idempotent temp-table pipeline, subquery-vs-CTE comparison, LAG-based 30-day readmission detection, and a performance rewrite. 45-minute code-review defence.
EnergyLT Pro — Standalone
Seven-pane Customer Insight Engine — referral-tree recursive CTE, parameterised stored procedure, NTILE/RANK/ROW_NUMBER segmentation, NetCashPosition running balance, retention priority list, silent-meter detection, and a performance rewrite. 45-minute code-review defence.
LogisticsLT Pro — Standalone
Seven-pane Network Analytics Engine — depot-hierarchy recursive CTE, parameterised stored procedure, weight-band quartile segmentation, NetPending running balance, top-route SLA positioning, LAG-based stuck-parcel detection, and a performance rewrite. 45-minute code-review defence.
HealthPY Pro — Standalone
Productionised NHS reconciliation pipeline: validated inputs, idempotent runs, structured logs, HTTP surface, scheduled runs, containerised. Instructor-reviewed including architecture rubric. Feedback within 15 working days.
InsurancePY Pro — Standalone
Productionised motor-claims pricing service: versioned cover-rule lookup, validated FNOL ingestion, idempotent re-pricing, HTTP surface, structured logs, ops runbook. Instructor-reviewed including architecture rubric. Feedback within 15 working days.
LogisticsPY Pro — Standalone
Productionised SLA-engine service: scanner-event ingestion, late-event recompute, weekly-close idempotency, compensation payable output, HTTP surface, ops runbook. Instructor-reviewed including architecture rubric. Feedback within 15 working days.
SQL Core Portfolio Trilogy
All three SQL Core capstones across regulated UK sectors — NHS Patient Snapshot, energy Meter Read Snapshot, parcel Shipment Volume Snapshot. Same assessor pool reviews all three. LinkedIn-ready portfolio summary on completion. Save £48 vs buying standalones individually.
Python Core Portfolio Trilogy
All three Python Core portfolio projects across three regulated UK sectors — healthcare commissioning, motor insurance, parcel logistics. Same instructor pool reviews all three submissions. LinkedIn-ready portfolio summary on completion. Save £48 vs buying standalones individually.
Python Applied Portfolio Trilogy
All three Python Applied portfolio projects — provider-variance analytics, loss-ratio + reserve-adequacy, parcel-network postcode-adjusted KPIs. Three written findings docs reviewed by the same instructor. Save £78 vs buying standalones individually.
SQL Applied Portfolio Trilogy
All three SQL Applied capstones — clinical data quality, customer-billing data quality, parcel-network data quality. Investigation Framework discipline across three regulated UK sectors, three reusable audit-card Views. Save £78 vs buying standalones individually.
SQL Pro Portfolio Trilogy
All three SQL Pro analytics engines — Clinical Analytics, Customer Insight, Network Analytics. Recursive CTEs, parameterised stored procedures, window-function segmentation, idempotent pipelines, gap detection, performance rewrites across all three regulated UK sectors. LinkedIn-ready portfolio summary including architecture write-up. Save £148 vs buying standalones individually.
Python Pro Portfolio Trilogy
All three Python Pro portfolio projects shipped as services: NHS reconciliation pipeline, motor claims-engine, parcel SLA-engine. Versioned rules, idempotent runs, structured observability, ops runbooks across all three. LinkedIn-ready portfolio summary including architecture write-up. Save £148 vs buying standalones individually.