Data Consistency Checker

How can you benefit for the Data Checker?

If you have ever asked yourself just one of these questions then the Data Checker Checker is the solution for you:

• Want to save time and remove the need for scrolling through Excel Spreadsheets?
• Data Validation worried you may have missed some data that was entered incorrectly?
• Not sure if the data types you are entering are as per the Database?
• Have big volumes of data to validate and only the use of a naked eye to validate against?
• Eradicate those blank cells that are so hard to find in columns were no blank cells are allowed?
• Want to locate those pesky spelling mistakes (were data is linked from separate excel worksheets) that can get through the Spell Checker?

Key Benefits

The Data Consistency Checker will address all of these:

• Ease of performing data migration between systems.
• The ability to load new or existing data into the database without large numbers of man hours taking up by - checking and reloading the data.
• The checking of data in a new system - Data Quality Management.
• User Error will be abolished.
• Ability to add to existing database data without affecting the data integrity.
• Greatly reduce the manual time of sifting through potentially 1000's of data records.

Product Features

The main features of the Data Consistency Checker are:

• Greatly Increase the accuracy of your clients data improving Data Management.
• Excel Import Spreadsheet a loading process, that takes all of the columns and rows then assigns a data type if possible (reserved words).
• Find and Replace when any issues have been returned this will allow the user to quickly update large amounts of the same data (without going into the spreadsheet and running the built in find and replace).
• Discovery or Pattern Matching this will find words or data types that match a set pattern that can be set by the user.
• Reserved words this will be functionality allow the user to assign similar words to mean the same i.e. e- mail, email, e-mail, electronic mail (we will code a large majority of these for the user).
• Checks to see if the imported excel worksheet is a valid one: correct tabs, is an excel file.
• Checks for missing data: no blank rows or columns unless specified.
• Checks the data consistency: the data type is as specified for the row/column; are there any spelling mistakes, redundant data, duplication.
• Checks for unique values: data from one column must be the same as specified for other rows/columns (primary/foreign keys) - see Unique Checks image.
• Checks to see if foreign keys that are set as orphan records are not shown.
• Data Consistency Checker user guide with these added features in the form of a Help section

Market

The Data Consistency Checker has been developed for the following market sectors to name but a few:

• Software Companies - Data Cleansing
• Banks - Data Management
• Marketing - Data Consistency
• Retail - Data Collection
• Health Sector - Data Integrity
• Educational Institutes - Data Validation
• Data Warehouses - Data Manipulation