We are an organisation of data specialists with years of experience with NHS data and more.
OUR OFFERING
Having trouble understanding what is actually happening in your organisation due to poor data quality?
Let us help you discover your main problem areas and come up with robust strategic plans to address them.
Taking a new system and need help translating your old existing data into the new format in a reliable and accurate way?
We have years of experience in doing just that. So why not let us take some of that burden off your hands.
Whatever your data related problems, we are equipped to be able to help you overcome them.
From bespoke systems to performance improvements, if you have a problem we can help.
Joe has been a real asset to the team in transitioning from manual to automatic processes and implementing APC data processes. His knowledge around NHS data and datasets brings an extra dimension to his work and he has really helped us to get a grip of our data quality as evidenced by our DQMI performance, taking us from performing below average to a perfect score. We continue to work with him and are excited about the improvements that we can make in other areas in the year ahead.
Zuzana Vesela - Head of Finance - Modality LLP
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