By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data-driven white label SEO
    Does Data Mining Really Help with White Label SEO?
    7 Min Read
    marketing analytics for hardware vendors
    IT Hardware Startups Turn to Data Analytics for Market Research
    9 Min Read
    big data and digital signage
    The Power of Big Data and Analytics in Digital Signage
    5 Min Read
    data analytics investing
    Data Analytics Boosts ROI of Investment Trusts
    9 Min Read
    football data collection and analytics
    Unleashing Victory: How Data Collection Is Revolutionizing Football Performance Analysis!
    4 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: The Retail Data Nightmare: Coming to a Store Near You!
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > The Retail Data Nightmare: Coming to a Store Near You!
Business Intelligence

The Retail Data Nightmare: Coming to a Store Near You!

DataQualityEdge
Last updated: 2009/04/29 at 2:25 AM
DataQualityEdge
5 Min Read
SHARE

Not too long ago, I visited a retail store to purchase numerous items. Now this is no small local store: it has a large presence, with outlets across Canada and the United States.

You would think they would be in the 21st Century with their data warehouse methodologies and CRM apps, but they aren’t.

What I discovered as the clerk punched in our telephone number was that there where not one, not two, not even three records with the same unique telephone number — but seven records. This is what they had:

1) One past owner of the phone from over 15 years ago;
2) Three versions of my name;
3) Two versions of my wife’s name; and,
4) One record that was a joint name account.

More Read

analyzing big data for its quality and value

Use this Strategic Approach to Maximize Your Data’s Value

7 Data Lineage Tool Tips For Preventing Human Error in Data Processing
Preserving Data Quality is Critical for Leveraging Analytics with Amazon PPC
Quality Control Tips for Data Collection with Drone Surveying
3 Huge Reasons that Data Integrity is Absolutely Essential

This is master data at its worse. Being curious I started asking questions! Smart, right! You ask data warehousing, MDM and DQ questions to a sales clerk and see what responses you get, and then you’ll realize just how smart of a move that is!

What I found out was that all my records had the same address content, phone numbers and postal code information, excluding the older record. I told the sales rep they should delete the other records and keep just one; it would be better for their record and data management…

Not too long ago, I visited a retail store to purchase numerous items. Now this is no small local store: it has a large presence, with outlets across Canada and the United States.

You would think they would be in the 21st Century with their data warehouse methodologies and CRM apps, but they aren’t.

What I discovered as the clerk punched in our telephone number was that there where not one, not two, not even three records with the same unique telephone number — but seven records. This is what they had:

1) One past owner of the phone from over 15 years ago;
2) Three versions of my name;
3) Two versions of my wife’s name; and,
4) One record that was a joint name account.

This is master data at its worse. Being curious I started asking questions! Smart, right! You ask data warehousing, MDM and DQ questions to a sales clerk and see what responses you get, and then you’ll realize just how smart of a move that is!

What I found out was that all my records had the same address content, phone numbers and postal code information, excluding the older record. I told the sales rep they should delete the other records and keep just one; it would be better for their record and data management. The clerk said they cannot delete the duplicate records. So I gave my elevator speech about data quality and uniqueness of the record and that she should, or her manager, contact their IT department and fix those records.

I’m sure she’ll hop right on that request. Deer in headlights…mean anything to you!

Purchase complete. My extended warranty is somewhere under one of those records. The way I see it. In the future if I do call in for service, they may not be able to find my warranty, or they’ll ask me which record it’s under. In either case it will equal one frustrated customer and a new blog all about it. Next time I’ll make sure to mention the store name.

And to sum it all up, I now know why I get six calls a year for carpet cleaning service and another six for air-duct cleaning.

By the way, I never mentioned the other two records at my old address, different phone number!!!

Let’s face it, this is an excellent example of a company operating with a lack of process, and poor, poor governance.

TAGGED: data quality
DataQualityEdge April 29, 2009
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data and IP laws
Big Data & AI In Collision Course With IP Laws – A Complete Guide
Big Data
ai in marketing
4 Ways AI Can Enhance Your Marketing Strategies
Marketing
sobm for ai-driven cybersecurity
Software Bill of Materials is Crucial for AI-Driven Cybersecurity
Security
IT budgeting for data-driven companies
IT Budgeting Practices for Data-Driven Companies
IT

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
data lineage tool
Big Data

7 Data Lineage Tool Tips For Preventing Human Error in Data Processing

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
data collection with drone use
Data Collection

Quality Control Tips for Data Collection with Drone Surveying

9 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 and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?