Home Data Lineage

Data Lineage

🔗 Data Lineage

Track dependencies between Power BI reports and Redshift source tables

📊 Key Insights

Total Reports
804
All Power BI reports
Redshift Connected
74
9.2% of total reports
Active Reports
170
21.1% used in last 90 days
Lineage Coverage
159
19.8% have lineage data
Unique Redshift Tables
220
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
170
21.1% of 804 catalog reports
% of Active on Redshift
41.8%
71 of 170 active
Personal-Workspace Reports
470
58.5% of catalog · scratch/draft, almost no usage
Dormant Redshift Reports
3
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-06-28

804
Reports in Scope
83,690
Total Views
699
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.
804
Total Reports
170
Active Reports (21.1%)
634
Zombie Reports (78.9%)
49
Stale (7.7% of zombies)
585
Never Used (92.3% of zombies)
3
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)