By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Getting to the Root Cause of Data Quality Issues.
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Quality > Getting to the Root Cause of Data Quality Issues.
Data Quality

Getting to the Root Cause of Data Quality Issues.

MIKE20
Last updated: 2011/05/11 at 5:28 PM
MIKE20
4 Min Read
SHARE

As a marketing manager, my primary responsibility is to build marketing campaigns that make people want to use our products.  To do this I need to have solid data to work from, such as contact information, needs, and levels of interest about our prospects and clients. For this reason, my marketing database (or CRM in this case) is as valuable to me as any campaign I can dream of, as the strength of my campaign is only as good as the quality of data used to design it.

As a marketing manager, my primary responsibility is to build marketing campaigns that make people want to use our products.  To do this I need to have solid data to work from, such as contact information, needs, and levels of interest about our prospects and clients. For this reason, my marketing database (or CRM in this case) is as valuable to me as any campaign I can dream of, as the strength of my campaign is only as good as the quality of data used to design it.

Locating and addressing the root cause of data quality issues is paramount in conducting efficient business operations in any organizational department.  Here’s a quick framework of how I do it:

More Read

analyzing big data for its quality and value

Use this Strategic Approach to Maximize Your Data’s Value

Niche Data Tactics to Take Your Business to the Next Level
Preserving Data Quality is Critical for Leveraging Analytics with Amazon PPC
What Tools Do You Need To Manage Unstructured Data?
3 Massive Cost-Saving Benefits of Smart Data for Businesses

1) Define the problem. Without trying to solve it, I make a statement as to what the problem is. What is wrong with what and include the frequency and isolation of occurrence if possible.

2) Gather facts. Again, without trying to solve the problem, I collect as much data ABOUT the problem as I can, asking other team members for input and looking for patterns as I go.

3) Compare and relate. Do any of the facts I’ve gathered relate exclusively to the problem I’ve described? If yes, list them.

4) Determine probable causes. Use deductive reasoning to weed out possibilities and identify your probable root causes, keeping in mind you’ll likely have more than one.

5) Test and check. Test each probable cause and check results to see which causes the problem to occur.

Root Cause Analysis in Practice

Here’s the theory in practice.  Imagine I need to build a contact information report for my sales team that is based on geographic territories. I set up the report and hit run, but the report only shows 10% of records with a state field.

1) Problem: Contact information report is missing state field on 90% of records.

2) Facts: There are no known performance issues with the database. The contract information report is built correctly (pulling the desired data fields with the desired filters). State fields were imported recently and this is the first time I’ve ran a report using State as a field.

3) Exclusive Facts: The contract information report is built correctly (pulling the desired data fields with the desired filters). State fields were imported recently and this is the first time I’ve ran a report using State as a field.

4) Probable cause: State fields were not imported correctly.

5) Test: Create a file to import with test data where state should be. Import the file and check results. Still not imported correctly? This is your likely root cause.

For more assistance with locating, and more importantly, addressing data quality issues, MIKE2.0 offers an open source solution to help address and correct them. Check it out when you have a moment.

 

MIKE20 May 11, 2011
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

analyzing big data for its quality and value
Big Data

Use this Strategic Approach to Maximize Your Data’s Value

6 Min Read
niche data tactics for business success
Big Data

Niche Data Tactics to Take Your Business to the Next Level

6 Min Read
data quality and role of analytics
Data Quality

Preserving Data Quality is Critical for Leveraging Analytics with Amazon PPC

8 Min Read
What Tools Do You Need To Manage Unstructured Data?
Data CollectionData QualityUnstructured Data

What Tools Do You Need To Manage Unstructured Data?

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?