Solved

Data Quality Analysis

Posted on 2009-04-15
3
382 Views
Last Modified: 2013-11-25
Hi there,

Can anyone please point me to a document for standard data quality analysis steps process.  I have standard steps / process that I follow but wanna to find out if there is a comprehensive list / steps out  there that i can use.

thx.
0
Comment
Question by:khanzada19
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 9

Accepted Solution

by:
Suveer Patil earned 125 total points
ID: 24148964
Hi,
Please check the attached file
and also check the below link for my comments on similar question
http://www.experts-exchange.com/Software/Quality_Assurance/Q_24124916.html 

qa-guide.pdf
0
 

Author Comment

by:khanzada19
ID: 24150152
These are great source for software specific planning / quality control etc.  I am looking for Data Quality Analysis steps like what are all the steps to validate the data; missing First name, have commas in names etc etc.  

thx
0
 

Expert Comment

by:egkumpe
ID: 24344235
A broadly accepted definition for data / information quality is that quality is determined by the fitness of use which depends on the consumer of the data. Because of this, it is a challenge to develop standardized steps. This is because the "standard" may be too rigorous in one context and too weak in another, thus it can't be called a standard.

The first step of an data quality project should be an assessment. During the assessment phase, it is the DQ analyst responsibility to develop a common understanding with the data consumer on the appropriated definition of quality for the business context.

In your second post, you indicated you are interested in address management data. In the name and address data domain, the quality of the first name may be adequate (even when missing) when it is for the use of to targeting a retail catalog to a roof top. We've all received a mail addressed to "current resident" or "current occupant." If you use of the name and address data is to send a credit card bill or acknowledge the death, receipt of a donation, or another use, then the acceptable quality of the first name field should be higher.

I can refer you to a couple of links that may be of use to you.

This book gives very good detail about the differing phase of a DQ project which should include assessment, improvement, prevention, DQ metadata, and monitoring.

http://www.amazon.com/Data-Quality-Assessment-Maydanchik-Arkady/dp/0977140024

In terms of standards, the Federal government's Office of Management and Budget (OMB) has a DQ framework. Note that it is a framework and not a standard.

http://www.whitehouse.gov/omb/assets/fea_docs/OMB_EA_Assessment_Framework_v3_0_Dec_2008_Revised.pdf
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
A simple overview of the possibilities of using technology for project management.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Starting up a Project

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question