/
Powering Dashboard Attendance Metrics

This version of the Ed-Fi Dashboards is no longer supported. See the Ed-Fi Technology Version Index for a link to the latest version.

 

Powering Dashboard Attendance Metrics

Aug 13, 2015

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: