Solved

Data Quality Analysis

Posted on 2009-04-15
3
376 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
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Metrics and trend analysis 2 289
open source software similar to visual paradigm 1 1,290
Terminology for project management 2 347
Functionality:  Waterfall vs. Agile 1 144
Documentation is a big contentious issue in Agile. There is a reason for this. When you start your presentation on Agile you start by going through the 4 statements of agile manifesto (https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&…
Transparency shows that a company is the kind of business that it wants people to think it is.
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

816 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now