We are often asked to help with data quality issues.
Data quality efforts are closely tied to important business needs. Accurate, consistent, rationalized and coordinated data records are keys to a useful database, a database that can be employed to help reach business objectives.
One of the most obvious indicators of data issues is duplicate records. This can include duplicate contact records, as well as duplicate organizational location records. In addition to duplicates, there are several other dimensions of data quality that exists in a database. These include the accuracy, completeness, timeliness, interconnectedness and usability of the data records.
To help our clients to get a full understanding of their data, we suggest undertaking a Data Discovery. This involves
* identifying all the data sources that are needed
* profiling the data from all data sources, to identify data characteristics and issues
* determining what data actions are needed
* planning how to work with the data to meet the underlying business goals
Today tools like SingleVision® are available to help undertake effective, practical and affordable Data Discovery.