We are an organisation of data specialists with years of experience with NHS data and more.
We are an experienced team with more than 30 years of working directly with NHS data from data entry through to national submission. We can help you find the issues that you may not even know about and help you define plans and targets to work towards. We have experience building out data quality reporting and dashboards alongside daily alerts which can be delivered directly to responsible end-users to correct data at source and in turn help you more accurately reflect your performance and targets when it comes to national reporting.
Although we appreciate publicly available indicators of data quality like the DQMI as an indicator of data quality we understand a lot of data quality issues are hidden from metrics like this. The fields that are sent may well be populated with legitimate values but there are no real metrics possible without access to the source to say they are populated with the correct legitimate values. Let us help you look for other hidden issues like referrals being linked to incorrect appointments, incorrect specialty, missing cancellation and DNA dates, non-outcomed clinics etc which can all have a big impact on targets and income.
We have in-depth experience across the majority of NHS datasets with real detailed knowledge in the lesser understood areas of RTT, the HRG grouper, CDS, contracting etc to name but a few. We can help you look for those missing co-morbities or issues preventing your tariffs resolving to what you should be seeing via the HRG payment grouper.
We are experienced migration experts having helped deliver multiple PAS migrations as well as smaller NHS system migrations eg ED, Casenotes etc.
We know large system migrations present a significant issue for resourcing often requiring the expertise of individuals internally who already have too much to do. Let us help you lessen the load and also use our experience to ensure your transition to the new system is a smooth as possible.
When performing migrations we appreciate it is of the upmost importance to ensure data quality is right before the big day. That is why we suggest also doing a full data quality analysis before kicking off migration to ensure that you are comparing like for like when validating the data in the new system.
With years of experience building data warehouses, reporting suites, RTT tracking systems, data audit systems, follow-up trackers etc we have the experience to help you plug any visibility gaps that you may have today.
We all know that no PAS or EPR system is perfect and there are always data visualisation or monitoring needs that to be handled outside of the core systems. This is where we come in, let us understand the issue and help you define, design and build whatever your organisation requires to keep on top of targets and data quality.
View our presentation on data tools here
With years of experience acting as DBAs, Integration Developers, process automation and BI developers we can assist any data based requirement you may have. If you have the specification of what you want to do and no time to do it or don't know where to start, then please reach out to Data Cure for a no obligations discussion.
I am delighted to extend my heartfelt appreciation to Vijay for his outstanding expertise in revolutionising our data management processes. He has expert knowledge of database technologies to set up various processes around data to ensure reliability of data. Going beyond addressing existing challenges, he optimised our data-related processes, resulting in improved operational efficiency. Vijay ensured a smooth knowledge transfer, empowering our team to independently sustain these advancements. I highly recommend Vijay for his professionalism, attention to detail, and unwavering dedication to client success.
Theresa Smith - Business Change Manager - Sandwell Council
Project Overview
The project requirement was to migrate the council data and databases from legacy housing infrastructure to new corporate infrastructure. This would include migrating all applications and databases from legacy servers to new servers on the new infrastructure
Database Consolidation
The first step was to consolidate a number of databases to ensure it was easier to manage in future for the current in-house team. There were 76 databases in total, and all databases were monitored to ensure active databases are consolidated and unused databases were archived and decommissioned.
Data Processing Improvements
The extraction processes every night were taking a very long time (at least 12 hours every night) and when there were any technical issues it was proving difficult to re-run the current processes and to catchup during the working day. These processes were reviewed to understand the root cause and subsequently the processes were changed to ensure it finished in 3 hours instead of 12 hours. This improvement also enabled the process to be easily restarted during a day to refresh data in cubes, reports and dashboard across council in the event of any unforeseen circumstances.
Database Migration
All databases were migrated from legacy servers of SQL server 2005 to SQL Server 2012. Any unused databases, cube reports and SSRS reports were decommissioned. New reports were set up in line with the requirements from the business users.
Results
The Sandwell council achieved the following advantages from the project:
• The number of SQL servers was reduced from three to one enabling easier maintenance
• The number of databases as a result of the consolidation resulted in the reduction in the total number to 20 from the previous 76
• The extraction process over night was now taking 3 hours instead of the previous 12 hours
• New reports/alerts were set up to improve data quality across various datasets and sources