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

By Team Audimation

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
Nov 07 The SmartAnalyzer Financial App and other Audimated Apps are very powerful additions to IDEA. However, some users may find that they need a little assistance us...

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