The 21st Minute


Data Quality Management

CaseWare Monitor Applications

High volumes of data can increase the likelihood of ‘dirty’ or poor quality data which can negatively impact your business. Incomplete and inconsistent data such as having incorrect customer, product and financial data can lead to problems such as duplicate marketing mail-outs, unpaid invoices, misidentified customers, and duplicate payments. This can potentially lead to lost revenue, stalled operations and compromised credibility.

Cross-Matching Data from Multiple Sources

  • Cross-match data from multiple sources that share common entities (customers, suppliers, etc.)
  • Identify, link or merge related entries
  • Consolidate data to correctly identify one customer who is entered into the database multiple times
  • Group similar data from multiple sources about a person, family, household or company

Data Accuracy

  • Split full names into component parts
  • Standardize name prefixes, including honorifics, professional titles and salutations
  • Assign gender to names through probabilistic gender assignment
  • Add custom name files for cultural name differences and known aliases
  • Find postal codes and zip codes for the U.S Canada and more than 240 other countries automatically
  • Identify name and address parts in non-standard addresses

Data Cleansing

  • Standardize data entered inconsistently, improperly fielded or with no structure
  • Create unique records to avoid errors
  • Purge duplicate records

Areas of Applications , CaseWare Monitor

Posted By


Related Posts
Give Python a Go
Mar 29 Python is considered the official programming language for non-programmers. It gives you increased flexibility and expansive access to your data. For those usin...
No Image
Sep 19 The general ledger is the core of the financial reporting system. Since the GL holds nearly all the financial information used to create the financial statement...
No Image
Jan 18 For years, Audimation’s Solutions Development Team had been performing ad hoc implementation of Accounts Payable-related analytics for various clients. Af...

This website has been designed for modern browsers. Please update. Update my browser now