Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: The Retail Data Nightmare: Coming to a Store Near You!
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
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
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

IBM will leverage its global technology capabilities to manage…
More Data Drives Deeper Consumer Understanding
Hadoop Toolbox: When to Use What
Data Visualization: Why (1 of 2)
Marketing Execs VS Market Research Execs

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
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Napoleonic Wars – Timely and Near Enough was Good Enough

5 Min Read

Missed It By That Much

6 Min Read

The Only Thing Necessary for Poor Data Quality

3 Min Read

Words at Work: Defining “Business Analytics”

4 Min Read

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

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

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

Sign in to your account

Username or Email Address
Password

Lost your password?