Skip to content
Dataventra

Data lineage & impact analysis

Dataventra Impact

Know what breaks before you change it.

Impact maps every dependency from source system to report, so you can see exactly which tables, views, datasets and reports are affected when a table, column or pipeline changes.

Impact analysis · dw.DimCustomer
Illustrative demo data

Proposed change

Column CustomerSegment renamed → SegmentCode

Views
2
Datasets
2
Reports
3
Illustrative impact analysis: changing dw.DimCustomer affects 7 downstream objects.SOURCE SYSTEMSOURCE TABLESTAGINGWAREHOUSEVIEWDATASETREPORTCRMSource system: CRMERPSource system: ERPcrm.AccountSource table: crm.Accounterp.CustomerSource table: erp.Customerstg.CustomerStaging: stg.Customerdw.DimCustomerWarehouse: dw.DimCustomer (changed)dw.FactSalesWarehouse: dw.FactSalesvw_CustomerRevenueView: vw_CustomerRevenue (impacted)vw_SegmentMarginView: vw_SegmentMargin (impacted)vw_OrderLinesView: vw_OrderLinesSales PerformanceDataset: Sales Performance (impacted)Customer 360Dataset: Customer 360 (impacted)Regional SalesReport: Regional Sales (impacted)Segment MarginReport: Segment Margin (impacted)Account ReviewReport: Account Review (impacted)Order OperationsReport: Order Operations

Impacted objects

  • View: vw_CustomerRevenue
  • View: vw_SegmentMargin
  • Dataset: Sales Performance
  • Dataset: Customer 360
  • Report: Regional Sales
  • Report: Segment Margin
  • Report: Account Review
  • Changed object
  • Impacted downstream
  • Not affected

Owners to notify: Finance BI, Sales Operations

The problem

A column is renamed in the warehouse. Two days later, finance asks why a board report is blank. Nobody knew they were connected.

Questions Impact answers

  • If we change dw.DimCustomer, which Power BI reports are affected?
  • Which source systems ultimately feed this executive dashboard?
  • Which staging tables have no downstream consumers and can be retired?
  • Who needs to sign off before this migration goes live?

Capabilities

What Impact does

  • 01

    End-to-end lineage

    Source systems → source tables → staging → warehouse → views → datasets → reports, mapped as one connected graph.

  • 02

    Downstream impact analysis

    Select any table, column or pipeline and see every downstream object and business asset it feeds.

  • 03

    Change risk before deployment

    Review the blast radius of a schema change during design, not after a failed refresh.

  • 04

    Ownership & accountability

    Attach owners to reports and datasets so the right people are informed when an upstream object changes.

Works withSQL ServerSSISAzure SQLPower BI

See Impact against your own environment.

We'll walk through how it maps to your systems, what setup involves and what you'd see in the first weeks.