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.