Home Data Lineage

Data Lineage

🔗 Data Lineage

Track dependencies between Power BI reports and Redshift source tables

📊 Key Insights

Total Reports
923
All Power BI reports
Redshift Connected
141
15.3% of total reports
Active Reports
234
25.4% used in last 90 days
Lineage Coverage
372
40.3% have lineage data
Unique Redshift Tables
276
Connected to reports

🎯 Migration Steering KPIs

Stable KPIs for the Snowflake-migration steering committee. Strips out personal workspaces and dormant reports so the percentages reflect the report base that actually matters.
Active Reports
234
25.4% of 923 catalog reports
% of Active on Redshift
43.2%
101 of 234 active
Personal-Workspace Reports
535
58% of catalog · scratch/draft, almost no usage
Dormant Redshift Reports
40
Redshift-connected but not used in 90d

📂 All Power BI Reports

Catalog-wide overview: every report in Power BI with its dataset, workspace, data sources, and connection flags for Redshift and Dataflow
No Results

📊 Reports & Redshift Tables — Activity Metrics

Combined view: every report (with its data-source dependencies) and every Redshift table (with its connected reports) — both filtered by the same date range and Redshift connection toggle below

📅 Reflects: 2026-01-01 to 2026-10-25

923
Reports in Scope
137,639
Total Views
809
Unique Users

📋 Reports

One row per Power BI report with data-source dependencies and activity metrics
No Results

🗄️ Redshift Tables

One row per Redshift table with usage metrics aggregated across all reports that use it (this section is empty when "Other Sources" is selected, since the grain is inherently Redshift-only)
No Results

🧟 Catalog Cleanup & Activity

Reports split into Active (consumed in the last 90 days) and Zombie (no activity in 90+ days). Zombies further break down into Stale (used at some point, dormant 90+ days) and Never Used (no activity ever recorded). Uses a fixed 90-day window, independent of the date filters above.
923
Total Reports
234
Active Reports (25.4%)
689
Zombie Reports (74.6%)
68
Stale (9.9% of zombies)
621
Never Used (90.1% of zombies)
40
With Redshift Dependency

📋 Zombie Report List
No Results

✅ Active Report List

Reports with at least one consumption event in the last 90 days, sorted by most recent activity first
No Results

💡 Understanding Data Lineage

Use Cases:

  • Impact Analysis: Before dropping or modifying a Redshift table, check which reports depend on it
  • Dependency Tracking: Understand the complete data flow from Redshift → Power BI → Reports
  • Optimization: Identify heavily-used tables that might need performance optimization
  • Compliance: Track data sources used in reports for governance and auditing

Key Metrics:

  • Report Count: Number of reports using this Redshift table
  • Power BI Table Count: Number of Power BI tables that reference this source
  • View Count: Total report views for all reports using this table (indirect usage metric)