Data Quality Tools

ProActive Datum utilizes it’s proprietary, proven Data Quality Tools for the Data Quality Improvement processes that automate Data Quality Compliance tasks. The Data Quality Compliance tool  addresses the Audit, Awareness and Action phases of the Data Quality Improvement Cycle which commonly are in a reactive state before the Data Quality Improvement process begins and have the following characteristics:

  • Utilize very labor intensive, highly technical, expensive IT resources
  • Manual, ad hoc, non-repeatable and undocumented processes and tools
  • Data extracts being moved outside a secure environment 
  • Lack accountability, communication and measurement of data quality performance
  • Cause business process interruptions
  • Identification, root cause analysis and correction of data is not timely
  • Apply undo pressure on support organizations throughout the business

These Data Quality Tools uniquely address three functional business levels that are required for a business to be successful in their Data Quality Improvement processes.  The three functional business levels and responsibilities are:

  • Management Oversight – Establishing, measuring and communicating data quality performance;  Implementing resources and initiatives to improve data quality;  Ensuring data quality business compliance to Data Standards.
  • Administration – Entry of data into the system of record either manually or electronically; Identifying and correcting data defects; Performing root cause analysis for defects; Understanding and communicating the data content and use; Managing Data Quality Operations; Assuring Data Standards compliance; Establishing and documenting data validations and business rules.
  • Data Interoperability – Identifying the data required and how to access it; Implementing and managing data interfaces; Supporting the technical infrastructure of data interoperability.

The Data Quality Tools enable automation of the following functions:

  • Data Standards
    • Supports multiple Data Standards
    • Utilizes pre-loaded industry Data Standards
    • Integrates with external data validation tools/services
    • Provides for use of hierarchical data relationships
    • Enables use of  custom data validations and complex business rules
    • Supports both intra- and inter-record data dependencies
    • Provides for business impact ranking at data element level
    • Allows for configurable management of metadata code sets
    • Enables mapping of system of record application screen/field label and database table/column to data element of Data Standard
    • Provides extensive Data Standards reporting capabilities
  • Data Sources
    • Supports multiple Data Sources
    • Provides for data interface formats of XML, file upload, spreadsheet, database and web services
    • Configurable for either real-time or batch data processing
    • Enables data source verification and assurance
    • Allows for unique Data Standard assignment
    • Supports resynchronization, add, change and delete event processing
  • Data Quality Compliance
    • Identifies defective data
    • Maintains both transaction and defect repositories
    • Categorizes defects
    • Utilizes Six Sigma Process Controls
    • Provides drill-down defect analytics
    • Enables root cause analysis
    • Provides robust defect reporting capabilities
    • Tracks and reports data quality performance metrics
  • Data Correction
    • Records and verifies defect corrections
    • Packages Data Corrections for application import or direct updating
    • Provides Mean-Time-To-Correct performance metrics
    • Supports direct defect correction through integrated application plug-in
  • Data Publishing
    • Provides for multiple data stores or interfaces for Data Publishing
    • Supports defect-free Data Publishing
    • Enables removal or de-identification of data
    • Configurable data store or interface data updating
    • Provides for configurable data mappings
    • Enables Data Publishing operations reporting
  • Notification
    • Enables custom group creation
    • Supports reusable notification templates
    • Allows for automated, recurring email notifications with selected data quality report attachments
    • Provides for email notification by role, user, data source and/or custom group
  • Administration
    • Enables a secured, controlled environment for user access
    • Supports configurable user access by role assignments
    • Provides a portfolio of administrative reports
    • Allows for data source assignments by user
    • Maintains user organization and contact information
    • Provides for a library of data quality documentation