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)

Gotchas & Pitfalls

Content coming soon...

Suggested Topics

• Using a read-write user for Grafana: risk of accidental data modification from dashboard queries
• Firewall and network issues: Azure PostgreSQL not accessible from Grafana due to missing firewall rules
• Slow dashboard queries: missing indexes or unoptimized SQL causing timeouts in Grafana
• Misleading visualizations: wrong chart type, truncated axes, missing units or labels
• Stale data on dashboards: not understanding when the underlying data was last refreshed
• Too many panels: dashboards that try to show everything end up communicating nothing
• Undefined metrics: presenting numbers without explaining how they are calculated
• Grafana time zone issues: dashboard showing UTC while users expect local time

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.