LIVE ONLINE TRAINING: DATA MANAGEMENT FUNDAMENTALS COURSE
Join us for this in-depth four-day workshop on the DMBoK, CDMP preparation, and core data concepts – July 25-28, 2022.
Trusting Big Data requires understanding its Data Lineage. Without Data Lineage, Big Data becomes synonymous with the last phrase in a game of telephone. The original data from the first person (e.g. “a guppy swims in a shark tank.”) changes to something completely different when it ends with the last person (e.g. “The puppy that spins and barks, stank”). Telephone game players look perplexed with no understanding of how the original data came to be something completely different. Such is the case with bad Data Lineage as well, as an enterprise’s data assets flow through its Data Architecture.
Customers, regulators, and businesses find it less entertaining to play the telephone game upon using a businesses’ Big Data. As Stewart Bond, Research Director of IDC’s Data Integration Software Services, states, businesses need data that is secure and compliant. This data needs to be available when and where it is needed. This need for clean Big Data becomes further complicated with multiple end-users, platforms, sources in many different formats, such as: video, text, images, and audio. Upon storing Big Data remotely, in the Cloud, and it becomes less tangible as to how the data got there. Understanding Data Lineage addresses these types of problems and more.
What is Data Lineage?
Data Lineage describes data origins, movements, characteristics, and quality. According to Stewart Bond, Data Lineage has typically described where the Big Data begins and how it is changed to the final outcome. Technology projects have used this traditional approach to Data Lineage. For example, during the creation of a new clinician/patient system, at a large technology company, project members would refer to a map of tables and joins, to guide what SQL to use for selecting, summarizing or grouping the data. Programmers would update the code as to generate the needed values and QA would read this plans to anticipate ways to break the software. While this method was a start, Data Lineage needs an expanded definition.
In only applying the traditional approach to Data Lineage, data encounters roadblocks, especially Master Data: information about people, processes, and things that form the business core. For example, team members need to develop a new checking program for a large bank division handling foreign transactions. QA and software engineers run into issues obtaining a valid set of test data from other bank divisions. Had project managers included additional Data Lineage facets, such as who uses the Big Data, what does it mean, when is the data accessed, why is the data stored, and how are the data elements related makes Data Lineage more meaningful, these obstacles could have been mitigated, shortening the time frame for development and testing. Meaningful Data Lineage needs to contain multiple dimensions: who, what, where, why, and how.
Why Keep Track of the Data Lineage?
Data Lineage has many benefits, including:
- Data Governance:
According to Christian Bremeau, Data Governance requires Metadata Management. This is needed to ensure Big Data meets business standards. Bremeau states, “the mission of a Metadata Management solution is to go to the absolute source of wherever it’s coming from to the end at the other side.” A Data Lineage solution stiches Metadata together providing “understanding and validation” of data usage and risks that need to be mitigated.
Multiple different stakeholders, including customers, staff members and auditors need to trust reported data while quickly responding to ”business opportunities and regulatory challenges.” They need to know for a report, “How did the information get …[there]?” Tracking Data Lineage provides proof that the “reports properly reflect the data,” remarks Ian Rowlands, the VP of Product Marketing at ASG Technologies.
- Data Quality:
Challenges to Data Quality include data movement, transformation, interpretation, and selection through people and processes. “Businesses today are under pressure to reliably demonstrate data’s origin and transformation through the organization,” says Rowlands. A Data Lineage solution provides the ability to know when “at the end-to-end flow,” encompassing: when data has been transformed, what it means, and how the Data Quality moves from one place to another.
- Business Impact Analysis:
As specified by Bond, businesses need to understand how internal departments and users, as well as external customers, share Big Data, especially Master Data, and how this data changes. As Bremeau states, a colleague may ask why a bad decision was made some quarter in the past, e.g. Q4 2005. Likewise, businesses may wish upgrade the Data Warehouse and need to know what systems and processes could break doing this. Responding to these types of questions requires going back and forth in time with your data, which necessitates understanding the Data Lineage.
How to Create and Use Data Lineage in Your Business?
To make better decisions and respond more rapidly to business opportunities and regulations, depends on creating and using Data Lineage effectively. Good strategies include:
- Document the Where and How of Your Data:
Break down where data might live in the business including through key business processes and flow between these processes. Also, know the technical lineage or “The flow of physical data through underlying applications, services, data stores,” says Rowlands. Track where data has moved and how it has changed, in a repeatable, defensible and speedy manner.
- Investigate the 5 W’s:
As mentioned above, meaningful data needs to be multidimensional, beyond the where and how. Find out who is using the data, what does it mean, when was it captured, when is it being used and why is it stored and/or used.
- Understand Relationships:
Relationships between data need to be well understood including how data originates and moves between people, processes, services and products. Data Managers need to conceptualize this information from the internal entities (such as departments within a business), external players (buyers from and sellers to the business), and the interaction between the internal entities and external players.
As Bremeau mentions, “Maintaining semantic mapping by hand is a nightmare. What you want is a set of tools to do that automatically.” Sue Habas, in the same webinar as Bond “Subscribing Your Critical Data Supply Chains,” mentions that ASG Technologies builds out a reverse tracing methodology and baseline to get comprehensive and end to end lineage. Identifying critical or Master Data and using an automated Metadata application, to scan and gather Metadata about Data Lineage becomes essential.
Case Study: The Financial Industry and Data Lineage
Data Lineage has become essential to financial industry, especially since regulatory controls changed as a reaction of the 2007-2008 financial crisis. A case study between a prominent bank and ASG Technologies describes how one bank took a proactive strategy to, “Create a world class process and strategy to automate the data forensics and resolve regulatory requirements across the organization.” The bank’s Information Architecture (IA) team explored a range of tools and did “Proof of Concept trials with 3 vendors, including a portion of the ASG Solution,” for the Retail Banking Division.
Approaches explored included mainframe testing, a distributed environment and migrations, and conversions. The IA team concluded that ASG’s Solution provided the “speed of results and overarching ramifications” required to meet its goal. The success of ASG’s Solution, for the bank included:
- Cost Savings in completing Data Lineage on “10 Key Business Elements(KBEs) in 100 applications, from $1,480,280 to $304,140.”
- Increased efficiency by “80-fold over manual Data Lineage and analysis processes.”
- Speedier resolution of one “data element in 100 systems (40 simple, 40 medium, and 20 composite) in 180 hours vs 14,400 hours when performed manually.”
Moving forward, the bank’s IA team planned to continue with ASG’s solution executing Data Lineage, including a “second implementation stage of 1000 KBEs in 40-50 systems.” As this case study shows, the power of Data Lineage minimizes doubts, increases trust, and speeds the processes, or as explained by Ian Rowlands, “Allowing for responses to business opportunities and regulatory challenges quickly and confidently.”
Photo Credit: issaro prakalung/Shutterstock.com