---
title: "Insight Report Pilot Studies"
ocid: "ocds-h6vhtk-0775af"
canonical_url: "https://d3tenders.com/contract/?ocid=ocds-h6vhtk-0775af"
markdown_url: "https://d3tenders.com/contract/ocds-h6vhtk-0775af.md"
json_url: "https://d3tenders.com/contract/ocds-h6vhtk-0775af.json"
source: "Find A Tender Service"
current_stage: "Award"
buyer: "O F W A T"
published: "2026-09-18"
---

# Insight Report Pilot Studies

Buyer: O F W A T  
Current stage: Award  
OCID: ocds-h6vhtk-0775af

[View canonical contract page](https://d3tenders.com/contract/?ocid=ocds-h6vhtk-0775af)  
[Download OCDS JSON](https://d3tenders.com/contract/ocds-h6vhtk-0775af.json)

## Summary

The Water Services Regulation Authority (Ofwat) commissioned insight report pilot services to capture, structure and share the experience and tacit knowledge of highly experienced staff. The work covers designing five adaptive interview question sets in the DUCHESS system; supporting up to four interviewees through up to five interviews each; analysing interview outputs; identifying lessons, experience and organisational knowledge; and developing an initial Ofwat Experience Library. Outputs include interview evidence, lessons lists, structured experience cards, an Excel-based experience matrix, an exploitation guide showing use of the library including through Copilot, a pilot report and final recommendations. The service is delivered across England. The relevant work is software programming and consultancy services, including knowledge capture, qualitative interviewing, analysis, information structuring and digital-tool demonstration.

This procurement is complete and was awarded directly without competition under a below-threshold procedure. Ofwat selected Diem Analytics Limited, an SME, on 11 September 2026. The active contract runs from 11 September 2026 to 31 January 2027, with a possible extension to 31 March 2027. Its value is £16,473.60 excluding VAT, or £19,768.32 including VAT. The customer may extend or modify the agreement by up to 50% of the original value, subject to the stated below-threshold modification conditions. Options include additional support for interviewees and up to five interviews per interviewee. One lot was awarded, covering the complete pilot requirement. The procurement and contract are recorded as complete and active respectively.

For a future requirement of this kind, credible suppliers would need to combine senior qualitative research and interviewing with practical knowledge-management and digital delivery skills. Relevant capability includes designing adaptive interview frameworks, conducting structured interviews with experienced professionals, analysing transcripts and identifying transferable lessons, patterns, decision-making insights and warning signs. Suppliers should be able to turn unstructured knowledge into consistent experience cards, thematic tags, organisational knowledge records and an accessible experience library, with strong attention to source traceability and information quality. Experience configuring or working with systems such as DUCHESS, Excel-based knowledge tools and Copilot would be useful, as would the ability to demonstrate user exploitation through clear presentations, screenshots or video. The requirement indicates demand for an integrated consultancy and software-enabled knowledge-capture service.

## Notice

Deliver an initial pilot to demonstrate how lessons learnt, experience and tacit knowledge from a small number of highly experienced Ofwat staff can be captured, structured and made available for use by other Ofwat staff. The scope shall include: Interview framework and question sets * Develop and configure five sets of adaptive interview questions within the DUCHESS system. * Review and refine the question sets progressively based on the findings from each interview phase. Interviews * Support up to four Ofwat interviewees. * Conduct up to five interviews per interviewee, resulting in a maximum of 20 interviews. * Interviews will progressively explore career experience, critical experiences, tacit knowledge, patterns and indicators, case studies, decision-making and key lessons that should be transferred to others. Interview analysis * Analyse individual interview outputs. * Identify lessons, experience and knowledge areas from each interview. * Refine subsequent interview questions based on the findings from earlier interviews. Experience library development * Analyse the overall interview corpus. * Develop structured experience cards and an initial Ofwat Experience Library. * Identify cross-interview and cross-theme organisational knowledge and lessons. Demonstration of exploitation * Demonstrate how Ofwat staff could use the Experience Library, including through Copilot, to identify relevant previous experiences, approaches, lessons, warnings and options when considering a current problem or situation. Deliverables are: * Interview question sets - Five configured interview question sets within DUCHESS, refined during delivery based on interview findings. * Interview evidence - Transcripts from up to 20 interviews, provided in an agreed format such as PDF, Word or Excel. * Lessons list - A consolidated list of the knowledge and experience areas identified from each interview, together with the associated lessons. * Experience cards - Structured cards capturing, as applicable: situation, problem, context, warning signs/cues, experienced approach, action, why it worked, lesson learnt, rule of thumb, conditions/limitations, source and thematic tags. * Ofwat Experience Library - An Excel-based experience matrix containing the lessons list, individual experience cards and organisational knowledge cards covering cross-interview and cross-theme lessons. * Exploitation Guide - A presentation, including screenshots or video as appropriate, demonstrating how Ofwat staff can interrogate and use the Experience Library, including through Copilot. * Pilot Report - A Word report comprising an executive summary and detailed sections covering the introduction, approach, findings, conclusions and recommendations, together with supporting annexes. * Final pilot recommendations - Recommendations arising from the pilot on the effectiveness of the approach, potential improvements and considerations for any future development or wider implementation.

## Key Details

| Field | Value |
| --- | --- |
| Publication source | Find A Tender Service |
| Latest notice | https://www.find-tender.service.gov.uk/Notice/088807-2026 |
| Notice type | UK7 - Contract Details Notice |
| Procurement type | Standard |
| Procurement category | Services |
| Procurement method | Direct |
| Procurement method details | Below threshold - without competition |
| Tender suitability | Not specified |
| Awardee scale | SME |
| All stages | Award |

## Dates

| Field | Value |
| --- | --- |
| Publication date | 18 Sep 2026 |
| Submission deadline | Not specified |
| Future notice date | Not specified |
| Award date | Not specified |
| Contract period | 11 Sep 2026 - 31 Jan 2027 |
| Recurrence | Not specified |

## Values

| Field | Value |
| --- | --- |
| Tender value | Not specified |
| Lots value | Not specified |
| Awards value | Not specified |
| Contracts value | £16,473 |

## Status

| Field | Value |
| --- | --- |
| Tender status | Complete |
| Lots status | Complete |
| Awards status | Active |
| Contracts status | Active |

## Buyer

| Field | Value |
| --- | --- |
| Main buyer | O F W A T |
| Locality | BIRMINGHAM |
| Postcode area | Birmingham |
| Postcode | B5 4UA |
| Country | England |
| ITL 1 | TLG West Midlands (England) |
| ITL 2 | TLG3 West Midlands |
| ITL 3 | TLG31 Birmingham |
| Local authority | Birmingham |
| Electoral ward | Ladywood |
| Westminster constituency | Birmingham Ladywood |
| Delivery location | Not specified |

## Supplier

| Field | Value |
| --- | --- |
| Number of suppliers | 1 |
| Supplier names | Diem Analytics Limited |

## CPV Codes

### Divisions

- 72 - IT services: consulting, software development, Internet and support

### Codes

- 72200000 - Software programming and consultancy services

## Release History

- 18 Sep 2026 at 15:29 - Award - UK7 - Contract Details Notice - https://www.find-tender.service.gov.uk/Notice/088807-2026

## Documents

- https://www.find-tender.service.gov.uk/Notice/088807-2026
  18th September 2026 - Contract details notice on Find a Tender

## Notice URLs

- https://diemanalytics.co.uk/
- https://www.legislation.gov.uk/ukpga/2023/54/contents

## Provenance

This Markdown file is an alternate public rendering of the D3 Tenders contract record. The canonical page is https://d3tenders.com/contract/?ocid=ocds-h6vhtk-0775af. The underlying structured data is available as OCDS JSON at https://d3tenders.com/contract/ocds-h6vhtk-0775af.json.