ABSTRACT

Header Information

• Work-Tool Code: DQ01WT12
• Product-Code: BIPM-DQPACK02
• Help File (excluding FAQs and Tips): 5pages
• Relevant FAQ: 5
• Relevant Tips: 4
• Number of Main working-sheets: 2

List of Main Work-Sheets

• DQ Gaps Tracking
• Ownership
• Prioritization
• Alternatives
• Decision and Planning
• Tracking
• Initiative Tracking
• Overview
• Scope and Benefit
• Status
• Reference

Overall Usage Guide

This template essentially has two parts

Data Gaps Scoping and Tracking

This part essentially has four sub-parts

• Rates the impact of the data quality gap in terms of urgency, importance, volume and complexity.
• Provides Alternatives
• Final Decision on what, how and when to fix a data gap. A data gap can be fixed through more than one initiative or change control over a span of time. An initiative can be addressing multiple data gaps (partially or fully)
• Status tracking of the agreed actions

Data Quality Initiatives scoping and Tracking

This sheet essentially is a kind of transpose of the first part. Here, we are listing out the initiatives to address the data quality gaps and track their progress. Sometime an imitative to address data quality may be a part of large initiative. For example moving from a legacy system to next generation platform, may fix many of the data quality issues. As a matter of fact many solutions to the data quality gaps

Who uses it?

This template ideally is an enterprise level reference point on what is happening on all identified data gaps, through different data quality programs. Therefore, it should be owned by the data steward. If the role of data steward is not defined, it can be owned by either a CFO or CIO.

When is it used?

Towards the end of data quality program analyze phase

This template is used during the analyze phase of a data quality program. After you have done Data Quality Assessment exercise, you will have all the details around the data gaps, their severity and the root-cause. The next step is to decide and plan out our actions, so that we can create a formal project proposal.

Business as usual to track the data quality issues

This template is also used for tracking on what is happening to your identified data quality gaps, through different initiatives and change controls. This in a way becomes the central reference point.

Relevant FAQs:

• How do assess, if a gap has to be assigned to a change control or a project?
• How do we track the changes in the plans to address a DQ gap? This work-tool captures on the latest planned dates.
• Given our organization, it is not possible to have a central tracking mechanism for all DQ gaps. Is there any other alternative to have an effective oversight?
• How do we track the data quality gaps, which happen and get fixed within a period of few days?
• We have a situation where there three business owners are linked to a data quality issue- The process business owner, data-group business owner and the system owner. Who should take the ownership of that data quality Gap? 

Relevant TIPs:

• Quantifying the risk assessment of a DQ issue or lack of data quality assurance
• Quantifying the business impact of a DQ Gaps Assessment
• Quantifying the risk assessment of a DQ issue or lack of data quality assurance
• Holistic solution for Data Quality may not be always a best solution