Overview

Ed-Fi dashboard integration projects cover a wide range of data. This broad information base is what makes the dashboards so useful – but for complex technology environments, implementation projects can be correspondingly broad. Developers and implementers often start by populating a "thin slice" of data as a first step. This article focuses on a thin slice of interesting data – the Attendance Metrics – and may be of use to early stage implementers looking for a practical way to get started. 

What Interchanges and ETL Packages power the Attendance metrics?

The following Ed-Fi Interchanges and Domain Entities are necessary to power the Student, School, and Local Education Agency levels for Student Attendance. Click here to learn more about the Ed-Fi Interchanges. The Domain Entities are complex types that can be found within the Ed-Fi-Core.xsd schema that can be found in the Ed-Fi-Standard repository at https://github.com/Ed-Fi-Alliance/Ed-Fi-Standard/tree/master/v1.2/Schemas. The Ed-Fi Interchange can be found in this location as well.

• EducationOrganization

  • School
  • LocalEducationAgency

• EducationOrgCalendar

  • Session
  • GradingPeriod
  • CalendarDate

• Master Schedule

  • CourseOffering
  • Section

• StudentParent

  • Student

• StudentEnrollment

  • StudentShoolAssociation
  • StudentSectionAssociation

• Staff Association

  • Staff
  • StaffEducationOrgAssignment
  • Teacher
  • TeacherSectionAssociation
  • TecherSectionAssociation

• StudentAttendance

  • AttendanceEvent

Examples of the above Ed-Fi Interchanges can be found in the Ed-Fi-Standard repository at https://github.com/Ed-Fi-Alliance/Ed-Fi-Standard/tree/master/v1.2/Samples. These files can be executed with the corresponding XML Loader ETL Package.

The ETL packages that should be executed to power the metrics are:

XML Loader

The XML Loader ETL packages can be found in the Ed-Fi-Core repository at https://github.com/Ed-Fi-Alliance/Ed-Fi-Core/tree/master/Etl/EdFi.Etl.EdFi.

• EducationOrganization
• EducationOrgCalendar
• MasterSchedule
• StudentParent
• StudentEnrollment
• StaffAssociation
• StudentAttendance

Dashboard Packages

The Dashboard Metric ETL packages can be found in the Ed-Fi-Core repository at https://github.com/Ed-Fi-Alliance/Ed-Fi-Core/tree/master/Etl/EdFi.Etl.Dashboard.

Student Level

• StudentInformation
• StaffInformation
• StudentSchoolInformation
• TeacherSection
• SchoolInformation
• StudentAttendanceMetrics
• StudentContextContainerMetrics

School Level

Note: All student level packages should be executed before running school level packages.

• SchoolAttendanceMetrics
• SchoolContextContainerMetrics
• SchoolFootnoteContainerMetrics

LocalEducationAgency

Note: All school level packages should be executed before running Local Education Agency level packages.

*LocalEducationAgencyInformation *LocalEducationAgencyContextContainerMetrics

After executing the listed ETL packages (if using the sample xml files), the dashboard would be similar to the below images.

This is the Student Overview page: 

This is the Attendance Metric Tab: