Week 12 - Dashboarding

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

Built with ❤️ by the HackYourFuture community · Thank you, contributors

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

Introduction to Dashboarding

Grafana Setup and Azure PostgreSQL Connection

Pipeline Health Dashboard

Data Quality Dashboard

Presenting Metrics and Definitions

Gotchas & Pitfalls

Practice

Assignment

Week 12 Lesson Plan (Teachers)

Week 12 - Dashboarding

Welcome to Week 12! This is the culmination of the data pipeline you have been building. You will connect Grafana to your Azure PostgreSQL database, build dashboards that visualize pipeline health and data quality, and present your metrics to the class. This week ties together ingestion, validation, modeling, and visualization into a complete end-to-end system.

Learning goals

• Connect Grafana to Azure PostgreSQL and configure a read-only database user for dashboard access
• Build a pipeline health dashboard that visualizes metrics from the pipeline_runs table
• Build a data quality dashboard that visualizes results from dq_results and mart tables
• Design clear, actionable dashboard panels with proper titles, units, and thresholds
• Distinguish between operational dashboards (monitoring) and analytical dashboards (insights)
• Present metrics and their definitions clearly to a non-technical audience in a 5-minute presentation
• Explain the full data flow from ingestion through modeling to dashboard visualization

Prerequisites

• Access to HYF-managed Grafana instance (or instructions for Azure-managed Grafana)
• Azure PostgreSQL database with populated tables from Week 10 dbt project
• Read-only database user credentials

Chapters

1. Introduction to Dashboarding
2. Grafana Setup and Azure PostgreSQL Connection
3. Pipeline Health Dashboard
4. Data Quality Dashboard
5. Presenting Metrics and Definitions
6. Practice
7. Assignment
8. Gotchas & Pitfalls

• Teachers

Lesson plan