Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Data Quality Analysis

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

When you’re making plans to join the modern business race, you should analyze various details that may affect your results. Nowadays, millions of businesses are trying to grow into established and appreciated professional enterprises.
Read about why it is more lucrative for an IT company to participate in government projects.
Simple Linear Regression
Introduction to Processes

715 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