Introduction to Dashboarding

Grafana Setup and Azure PostgreSQL Connection

Pipeline Health Dashboard

Data Quality Dashboard

Presenting Metrics and Definitions

Practice

Assignment

Gotchas & Pitfalls

Week 11 Lesson Plan (Teachers)

Data Quality Dashboard

Content coming soon...

Suggested Topics

• What data quality metrics to track: null rates, duplicate counts, row count trends, test pass rates
• Querying dq_results tables: aggregating test outcomes over time
• Querying mart tables: row counts, freshness timestamps, value distributions
• Visualizing data quality trends: are things getting better or worse over time
• Building a "data quality scorecard" panel with pass/fail indicators
• Combining pipeline health and data quality: correlating failures with quality drops
• Using Grafana annotations to mark known incidents or deployments
• When to alert on data quality: thresholds for null rates, duplicate spikes, missing data

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.