Certify’s™ reporting capabilities provide
rapid turnaround of results and instant notification
to data users and suppliers. Results from data validations
can be viewed at both the detail and summary levels,
from any web browser. Data validations and results
are easily tailored to the needs of individual users,
data suppliers or business units which may need to
see a particular "slice" of data.
Certify’s Data Quality Report Cards allow users
to interactively drill-down to data errors at the
table, row and column level, to see the full instance
and context of data problems. Certify offers two types
of Data Quality Report Cards:
The Data Quality Certification Index Report Card™
displays complete detail on data errors, identifying
the exact columns and rows affected, as well as summarization
based on the steps of Certica’s data validation
methodology. Certify’s Data Quality Certification
Index (DQCI) can be likened to a “super-metric,”
summarizing the overall quality of the database or
data set. Certify automatically calculates the DQCI
based on the results of pre-defined data validations.
The Severity Level Report Card provides the same level
of detail as the DQCI Report Card, but shows summarization
based on the severity level of errors. Given that
not all data errors are equally problematic, Certify
provides users the ability to easily assign a severity
level to each data quality validation. Severity levels
aid in the prioritization of data clean-up efforts
and can flag “fatal flaw” conditions before
data is allowed to populate critical databases or
be reported to regulators.
Both indexes and severity levels can be used as
data quality thresholds; as such, they can activate
follow-on events, such as the generation of an email
notification to a data supplier, the trigger of a
stored procedure, or the execution of custom code
to activate a subsequent process in the data flow.
Other reporting capabilities include a Trend Report
which allows users to gauge the changing quality condition
of data over time, and a comprehensive Metadata Report
which displays all the business rules and metadata
used in a Certify project.
Certify’s ability to quickly validate and report
on data quality issues allows for rapid feedback between
data suppliers, data consumers and data administrators.
This feedback— with definitive, measurable information
about the quality condition of data—promotes
a valuable and lasting data quality management process,
where stakeholders can be actively involved and accountable
for the improvement of data.
To achieve this rapid cycle of validation, reporting
and feedback, Certify provides two main user roles—the
data quality analyst and the data quality reviewer.
The analyst is the “power user,” responsible
for configuring Certify projects, scheduling observations,
creating and maintaining user profiles, etc. Reviewers
are individuals—either internal or external
to the organization—who review Data Quality
Report Cards and other pre-defined reports online.
Many times, it is the reviewers who have the responsibility
for cleaning up data, especially if they are also
the suppliers—or “owners”—of
the data. |
