What's Data Lineage?
Data Lineage explains how data moves from one place to another, and what happens to it as it moves. It allows you to follow your data as it flows through systems, processes and teams, from producer to consumer.
Keep track of your most important information
Make sure data is coming from authoritative sources
Trace data through calculations and transformations
Support root-cause analysis of data quality issues
Give your business users confidence in their data
Why Ortecha?
We know how complex Data Lineage can get: data landscapes with dozens of departments and hundreds of systems can result in thousands of data flows. It’s a huge task that can be difficult to manage, but it’s worth getting it right.
We understand the complexities of defining data flows
We know how to tackle lineage to derive value quickly
We’ll teach you how to document lineage at the right level
We can help you automate your lineage gathering
We’re experts at using lineage tools like Solidatus
How we can help you
Lineage Strategy
Do you know how you’ll be tackling your Data Lineage? Have you agreed the level at which you’ll be documenting it? We can help you to define a Data Lineage Strategy that brings value to your business.
Lineage Harvesting
Are you avoiding Data Lineage because it’s too much manual effort? We can help you automate your Data Lineage harvesting so you reap the benefits of having it without spending all your time working on it.
Lineage Visualisation
Can you visualise the data flows that you may already be maintaining in tools like Collibra? As a Solidatus Partner, we can bring your Data Lineage to life and make it easy to analyse and share.
Lineage Consulting
Wherever you are with Data Lineage we can support you. Whether you need high-level one-off advice or regular ongoing guidance, we can help you to efficiently manage your Data Lineage and mapping.
CASE STUDY 1
ESG Data at a LUXURY GOODS COMPANY
The Challenge
A global luxury goods company had been producing a Climate Report as part of their ESG (Environmental, Social & Governance) reporting suite since 2020.
Unfortunately, the manual effort to gather and combine all the source information from 450 individual sites, as well as upstream and downstream supply chains, meant that the report could only be compiled annually.
They wanted to streamline and automate the process so they could track progress throughout the year, allowing them to course-correct if they were in danger of missing their targets.
What we did
Loaded spreadsheets from regional manager surveys into a Solidatus model
Connected each element of the Climate Report with its applications and sources
Identified which regions needed to adopt data from an authorised source
Tagged transitions between layers to indicate automated and manual data flows
Filtered to identify Climate Report elements for which no data was being sourced
The Benefits
Recommended changes to reduce the number of applications needed
Found ways to automate 68% of the company’s Climate Report
CASE STUDY 2
Solidatus at a Big 4 UK Bank
The Challenge
A Big 4 UK Bank had decided to implement a new General Ledger fed by strategic accounting data feeds.
However, a disparate team of Business Analysts working at speed and in parallel were having to use spreadsheets to define the feeds, and the formats were starting to diverge.
It was complex and time-consuming to look across the strategic feeds to verify consistency and alignment to the original business requirements, and they realised they needed a better approach.
What we did
Loaded the various feed specification spreadsheets into a Solidatus model
Showed the Lead Business Analyst how to interrogate and filter the model
Discovered that feeds were being inconsistently mapped
Identified critical accounting data items that had been incorrectly mapped
Caused the Lead Business Analyst to exclaim “Why have we done that?!”
The Benefits
Discovered issues far earlier than otherwise possible, with little overhead
Enabled the team to harmonise and review their work across multiple feeds
Provided an easier way to share mapping information with stakeholders
Gave the bank far greater confidence in the mappings being delivered
Using Solidatus you've found issues we would not have found ourselves.
Get in touch
If you need some guidance with your Data Lineage, we’d love to help! Arrange a Discovery Call with our experts now.
