Návrh a implementace PoC pro řešení Data Lineage ve vybrané společnosti

This master’s thesis addresses the topic of data lineage in the context of its practical application within WOOD & Co. The growing volume of data, the automation of data pipelines, and the interconnection of heterogeneous systems increase the need to systematically trace the origin, flow, and transformations of data. In the company’s current environment, data lineage is predominantly reconstructed manually, which is time-consuming and dependent on the experience of individual team members. The aim of this thesis is to define WOOD & Co.’s requirements for a data lineage tool, analyze available market solutions, and verify their applicability in a real environment through a proof-of-concept implementation. The thesis applies a combination of exploratory research, frequency analysis, and multi-criteria comparison of tools. As part of this analysis, both commercial and open-source solutions were evaluated. The opensource tools did not meet key requirements, particularly with respect to integration with Azure Synapse Analytics. Microsoft Purview and CEOS Metadata (Asysta) were selected for practical evaluation, as they represent two distinct approaches to implementing data lineage. Microsoft Purview provides broader coverage of data flows within the Microsoft Azure ecosystem; however, it does not provide sufficient detail regarding transformation logic and column-level operations. By contrast, Asysta enables a more detailed analysis of transformations, particularly in the Microsoft Power BI environment, but its applicability is limited by the absence of full integration with Microsoft Azure Synapse Analytics. The results show that none of the tested tools independently satisfies all requirements defined by WOOD & Co. A combination of both approaches comes closer to meeting these requirements; however, limitations remain, especially in the tracing of transformation steps within the Synapse environment. The contribution of this thesis lies in the systematic specification of requirements for a data lineage tool, the comparison of available solutions, and the practical validation of their capabilities in a specific enterprise environment.