Build a Mini Dashboard

Simulate a dashboard with counts, stats, and rankings.

Dashboards help summarize your data into quick insights. In this lesson, you’ll simulate a basic stats dashboard using counts, averages, and filters.

Goal

You’ll aim to:

  • Create summary queries for key metrics.

  • Display counts, averages, rankings, and missing data.

Tables

Use the same students and grades tables:

  • One student can have many grades (by subject)

The students table