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
    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
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Do You Know Your Data?
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Inside Companies > Do You Know Your Data?
Inside Companies

Do You Know Your Data?

MIKE20
MIKE20
4 Min Read
SHARE

Contents
Dealing with the SuboptimalFeedback

Midway through Michael Lewis’ excellent book The Big Short, the author makes an astonishing assertion: many financial institutions didn’t understand the complex derivatives and products that they were selling. And here’s the really scary part: He was absolutely right. Lewis shows that once-storied banks such as Merrill Lynch, Morgan Stanley, and Deutsche Bank could not even answer basic questions about what specific bonds comprised their CDOs, credit default swaps (CDSs), and other opaque financial instruments.

More Read

Are Data Scientists Overpaid?
I Tweet Therefore I Am
What are the Benefits of Data Annotation?
Aiding an Analytics Enthusiast
Information-Driven Business

While most organizations don’t deal in such complexity, the book make me wonder:

  • To what extent do organizations lack a fundamental understanding of their data?
  • What are the potential legal and financial effects caused by such ignorance?
  • How can organizations understand their data better–and mitigate risks in the process?

These are questions worth considering over the course of a number of posts.

Dealing with the Suboptimal

I often work with organizations in the midst of some type of data migration project. Unearthing data from a variety of sources typically manifests some inconsistencies, to put it mildly. For example, on my current project, I have been surprised to learn that a mid-sized bank has no fewer than nine operational systems. There are several financial systems, additional trading systems, and some old GL legacy systems that have never been properly integrated with the others. And this is just on the domestic side. On the foreign side: Don’t ask.

As expected extracts from these systems often produce inconsistent results. Now, because I have only been on this project for three weeks, this is news to me. My de facto boss has been with the company for a very long time and, as a result, can spot these issues in seconds. Institutional knowledge has its benefts.

However, what if he were to leave–by his choice or otherwise? Who would be able to explain to me–or another consultant–all of the intricacies and exceptions to relatively arcane rules? I’m honestly not sure. At least there’s a comprehensive data dictionary and an ERD, right? Think again.

While my boss would agree that better documentation is necessary, it’s certainly not imperative right now. He’s being pressured to provide a consolidated look at the data and that’s why I’m there–not to pine for a idyllic state.

Not every organization or industry has the ability to stall the world credit markets and cause the worst economic crisis in 70 years. Let’s hope that we never have to experience anything like what we have seen over the last three years. While “one system” may be impossible at large organizations for one reason or another, consider the dangers with not having one version of the truth or at least a complete version–even if it needs to be derived from multiple sources. We’ve recently seen what can happen when this happens.

Feedback

What say you?

TAGGED:data management
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive
AI and data mining
What the Rise of AI Web Scrapers Means for Data Teams
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Data, data everywhere, but where is data quality?

9 Min Read
IoT Security
Internet of Things

IoT Security: What Kind of Data Is Compromised by Poorly Protected IoT Devices?

6 Min Read
benefits of data lakes
Big DataData LakeExclusive

The Business And Technological Benefits Of Data Lakes

6 Min Read
big data scientist skills
AnalyticsBig DataHadoopMapReduce

Is Hadoop Knowledge a Must-Have for Today’s Big Data Scientist?

3 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 is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

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?