Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Data Quality Analysis

Posted on 2009-04-15
3
Medium Priority
?
389 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 375 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

It was Monday morning and while heading to work those familiar feelings of frustration began to rise: How was I ever going to get my yard work done?! At the end of every weekend I discovered that I spent more time trying to decide what to work on th…
In Agile (http://en.wikipedia.org/wiki/Agile_software_development), time and again people ask this question "How would you estimate a release for a product?". When it comes from management they want to know the following: Calculate the man hours wh…
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…
Integration Management Part 2

886 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