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:
