Data Quality and Data Migration
With the implementation of electronic records through the
National Programme for IT, the Electronic Social Care Record and
solutions to support information sharing between different
agencies, data quality is key. We have expertise in data
quality, cleansing and migration and can help in planning as
well as providing hands on support. Our hands on work includes
completion of complex data migration in both the acute and
community sectors of the NHS.
We have also completed data migration for over 30 awarding
organisations as part of the implementation of either our OPUS
or Quartz systems.
CRS Data Migration Support
Portico Consulting has recently been working with two London
PCTs to support their migration of data for child-health
(including immunisations and vaccinations), district nursing and
therapy services. This work built on our previous experience of
many complex data migrations, and we have now established both a
detailed understanding of the field, inter-field and
inter-record integrity tests which data must ‘pass’, and
mechanisms for transforming and cleansing the data to meet the
LSP's requirements.
We are able to offer assistance in supporting your data
migration work. We recognise that the range and availability of
relevant skills varies from Trust to Trust, and so we can work
with you to provide the level and type of support which would be
most helpful.
For example, we could help by facilitating a workshop where
we could assist in the planning process, drawing on our recent
experience and providing advice on what works well, and what
doesn’t work so well. Alternatively, we could, if you needed,
provide some skilled hands-on help in manipulating and preparing
data; or establish a SQL Server 2005-based technical environment
at your Trust, and possibly provide some focussed training in
aspects of the tools which are particularly relevant. Or we
could provide all technical aspects of the work, cleansing and
transforming the data into the required format in our own
technical environment.
We are not offering a ‘product’, which may be the most
appropriate solution for some Trusts. However, we have found
that the tools available in SQL Server 2005 (an installation of
which most Trusts either already have, or plan to have) provide
an excellent basis for undertaking complex data migrations.
|
