Skip to content

Attendance Query Guide#

Coming Soon: Spring 2026

This guide is under active development. Check back soon for a complete walkthrough of querying attendance data in EDU, including:

  • Overview of attendance-related tables (fct_student_daily_attendance, msr_student_attendance, and related dimensions)
  • When to use the daily fact table vs. the pre-aggregated measure table
  • Common attendance query patterns (chronic absenteeism, day-of-week analysis, period-over-period trends)
  • Joining attendance data to student demographics, schools, and calendar dates
  • Handling edge cases (partial days, excused vs. unexcused absences, dual-enrolled students)