NHS Nottinghamshire
Case Study
30% Productivity Gains
How Oka-Bi Accelerated a Regional Enterprise Data Warehouse with Privacy Enhancing Technology Automation
Challenge
7 NHS organisations in the Nottinghamshire area wanted to control costs while delivering a multi-organisation centralised data warehouse on SQL Server platform. The platform requirements were stringent; enable single and multi organisational analysis using pseudonymised identifiers, driven by optimised Role Based Access Control (RBAC) to segment and safeguard individual user personal data access. Oka-Bi proposed their proprietary solution which fulfilled these requirements,
Solution
Oka-Bi first deployed the platform in a pre-production test environment. The software and platform was then was then subject to a 12 month beta test, before reaching production grade maturity with sign off of the 7 Regional NHS bodies (across both technical and data governance functions for each separate organisation). The software provided;
-
Scalable loading of large scale historic datasets sourced from the NHS Spine (Inpatients, Outpatients, A&E, GP and Public Health datasets).
-
Automation of Spine dataset(s) integration into the Data Warehouse.
-
Balanced Cyber Security Posture achieved through pseudonymisation and data access audit technologies
-
Integration with analytics & reporting - Tableau and SQL Server Reporting Services
-
Deep Infrastructure integration with Active Directory & SQL Server platform.
Result
The data warehouse, was delivered with a 30% productivity gain compared to manual builds, with the identities of over 1 million peoples data, safeguarding the Nottinghamshire population against PII Acquisition and the Trusts themselves protected regarding GDPR/DPA provisions. See core benefits below.
-
30% TTRR (Time To Risk Reduction) achieved
-
Via training, NHS database administrators became self sufficient in integration of new datasets to the warehouse
-
Data compliance and governance all signed off on the platform (even describing its adoption a "no brainer")
-
Over the coming years, over 20 enterprise datasets were integrated to the platform and subject to its rigorous data protection and role based sharing mechanisms.
The Oka-Bi Pseudonymisation Toolkit met the compliance criteria we were looking for in the protection of Nottinghamshire patient data. The automated development package, in particular, helped us develop our own system in-house and was a time saver whilst exhibiting accuracy and quality. Oka-bi were good to work with and worked very hard to help us implement the system and tailor the configuration to our local requirements. I would recommend their Pseudonymisation Toolkit to NHS organisations considering the development of systems to protect patient data.
Andy Hall, Deputy Director, NHS Nottinghamshire Community