blocks_image

Data Services

Data. It's essential to your business, and yet it is surprising how many organisations are unaware of either the quality or the nature of the data that they hold. We can help your business to understand what data it holds and how to make the best use of it, through
Data Quality Analysis
Working with your business people to define the baseline of what should be held, we can perform a gap-analysis with what is actually stored and whether that data is up-to-date, complete & pertinent.

Where problems are identified, we can produce an action plan detailing what steps must be taken.

Data Cleansing
Erroneous data, orphan records, duplicates, missing key-fields... Most legacy databases are strewn with such problems. We can identify & help you to remedy them.

XML
We regularly make use of XML as a mechanism for automating data migration processes
Data Mapping & Migration
Whether you want to scale up (e.g. from Access to SQL Server), or need to consolidate several disparate databases, we can produce a winning strategy which includes:
  • Data field audit
  • Target database design & build
  • Mappings between Source & Target
  • Perform migration
  • Testing
Want to consolidate countless Excel spreadsheets into an Access database? We can do the data migration and build you an Access application which is robust, controls-driven, user-friendly and which still allows data to be exported to Excel for reporting/pivoting.
one or more of the following data- focused services: