DQA is a great tool that utilizes software already owned to assess data quality for a variety of purposes.

Features

1. Import Rules
   Stored in a spreadsheet format
   Handles fixed-width and delimited data in the same record
   Includes some transformation or substitution capability
   
   
2. Data Quality Rules
   Stored in a spreadsheet format
   Value-based rules that work on comparisons between fields and/or constants
   Format-based rules
   Rules can be dependent (Example: only requiring a 5 number postal code format if the address is US)
   Statistical rules that check number of occurrences of a value by count or percentage of sample
   Mathematical rules that allow values in a record to be compared according to mathematical formulas
   
   
3. Data Quality Report
   Report on data's compliance to the supplied import rules
   Specific counts and confidence calculations by rule, column and sample
   Text translations of the data quality rules to help explain reports

System Requirements

Operating System: Win95, Win98, NT 4.0 (with Service Pack 4), Win2000, WinXP
Microsoft Excel 2000