By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
    benefits of data analytics for financial industry
    Fascinating Changes Data Analytics Brings to Finance
    7 Min Read
    analyzing big data for its quality and value
    Use this Strategic Approach to Maximize Your Data’s Value
    6 Min Read
    data-driven seo for product pages
    6 Tips for Using Data Analytics for Product Page SEO
    11 Min Read
    big data analytics in business
    5 Ways to Utilize Data Analytics to Grow Your Business
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Five Attributes for the Data Quality Analyst
Share
Notification Show More
Latest News
cloud-centric companies using network relocation
Cloud-Centric Companies Discover Benefits & Pitfalls of Network Relocation
Cloud Computing
construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security
DevOps on cloud
Optimizing Cost with DevOps on the Cloud
Development
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Five Attributes for the Data Quality Analyst
Data Mining

Five Attributes for the Data Quality Analyst

DataQualityEdge
Last updated: 2009/03/05 at 9:46 PM
DataQualityEdge
6 Min Read
SHARE
- Advertisement -

In my years working in data quality I have seen many skills and attributes of what a good data quality analyst must have under their belt.

As a result I believe a data quality analyst must…

- Advertisement -

Be proactive: Many times the media catches a snip-it of some disastrous event which was the result of bad data quality. Or the masses that are your company’s customers have congregated on Facebook to strike down the corporate beast you work for, because of bad billing or bad customer service.

One must ask…why is there bad billing or bad customer service? One fundamental reason is…

More Read

data mining helps with offsite SEO

Can Data Mining Aid with Off-Page SEO Strategies?

3 Data Mining Tips for Companies Trying to Understand their Customers
5 Data Mining Tips to Leverage the Benefits of Surveys
Perform Data Mining With Web Scrapers to Track Prices
Data Mining Vital Statistics Yields Fascinating Societal Insights


In my years working in data quality I have seen many skills and attributes of what a good data quality analyst must have under their belt.

As a result I believe a data quality analyst must…

Be proactive: Many times the media catches a snip-it of some disastrous event which was the result of bad data quality. Or the masses that are your company’s customers have congregated on Facebook to strike down the corporate beast you work for, because of bad billing or bad customer service.

- Advertisement -

One must ask…why is there bad billing or bad customer service? One fundamental reason is the fact that the data is not quality data. Ultimately, if you bill someone more then they should be billed, you will have a bad reputation and be considered to have poor customer service. It’s all about perception. So what to you do to prevent such things. Be proactive, don’t sit back and wait for someone to say “I think the order provisioning system has bad data?” or “We billed the Smith family $3000.00 when we should have billed them $30.00!” You don’t want those statements to come to you. You want to be proactive and look for the bad data, you want to trend the data so when it finally breaks the trend you know you have something worth looking into. You want to look at the ETL that project ABC is bringing into your data warehouse. You want to review the data dictionary and ensure that all the “t’s” are crossed and “i’s” dotted. You want to establish quality checks up front, before the data is loaded. You want to be proactive.

Be relentless: When a data issue emerges tackle it. Be ruthless, be relentless, when the developers say they don’t know the business and the business says they don’t know the script or code. Bring the two together and resolve the issue. They’ll be a time when someone passes the buck or tries to brush you off. Don’t take no for an answer. Escalate if you want to get answers. Be relentless.

Be technically savvy: Knowing basic SQL in a data warehouse environment is worth your weight in gold. At the least you must know a little SQL so that you can look at the data in different patterns and omit specific values to perform a better analysis of the data to ensure it’s quality. You do not want to rely entirely on a predefined report that someone created before your arrival. Data is always changing and you must be able to adapt and change with it. You must have some basic SQL skills and be technically savvy. Eventually your expertise will increase.

Be personable: You might ask why if I worked with data do I have to be personable? Let’s face it. You are a data quality analyst, if you are questioning the data coming into the data warehouse from the orders department, do you think they want to correct the issue for you. No they want you to fix the problem. So be personable! Scratch a few backs and someone will scratch yours. It’s all about being a team, no matter how large of an organization you are working in, you are all part of the same team, with the same goal and that is to succeed.

Know the business: A data quality analyst who isn’t business oriented would be someone who really reads reports and says, “Ah! Bad data again! We’d better fix it.” An analytical data quality expert would be intimate with the data. They can look at the trends, outliers and more and have an understanding of what the data is saying about the business. So when there’s a quality threshold spike on a data object, you immediately know it’s related to what the business is doing. This will save you investigation time and money.

- Advertisement -
DataQualityEdge March 5, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share
- Advertisement -

Follow us on Facebook

Latest News

cloud-centric companies using network relocation
Cloud-Centric Companies Discover Benefits & Pitfalls of Network Relocation
Cloud Computing
construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

data mining helps with offsite SEO
Data Mining

Can Data Mining Aid with Off-Page SEO Strategies?

10 Min Read
using data mining to learn more about customers
Big Data

3 Data Mining Tips for Companies Trying to Understand their Customers

6 Min Read
surveys data
Data Mining

5 Data Mining Tips to Leverage the Benefits of Surveys

11 Min Read
data mining is game changer for small businesses
Data Mining

Perform Data Mining With Web Scrapers to Track Prices

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
ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

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?