Module 6: Reporting

Visualizing the Truth

COURSE MAP

Home
M0: Orientation
M1: Fundamentals
M2: Local dbt
M3: Semantic Layer
M4: AI Assist
M5: Testing
M6: Looker Studio
M7: Governance
M8: Optimization
M9: Capstone
M10: Next Steps

Building Dashboards in Looker Studio

Connecting to the Semantic Layer

Never query raw tables! Connect Looker Studio to your gold-standard marts.

K-12 Dashboard Design

  • The Principal View: High level attendance & discipline rates.
  • The Teacher View: Roster-level details for intervention.

Performance Tuning

Pro Tip: Use BI Engine and Partitioned Tables to make your dashboards load in <1 second.

Hands-on: The Charter School Dashboard

We will build a compliant dashboard tracking Average Daily Attendance (ADA).

Copyright © 1999-2025.