The Analytics Middle Tier is a set of denormalized analytics views over the Ed-Fi ODS database tables, satisfying the user story: "As a district data analyst, I want to build intelligent reporting on the Ed-Fi ODS with minimal learning curve and low risk of breaking changes, so that I can deliver timely data to educators and administrators."
As an Early Warnings System Analytics Data Modeler, I want to import a Student Early Warning Fact Table from the ODS, so that I can create aggregations across the Early Warning System indicators.
h1. Acceptance Criteria
Must include the following columns:
StudentKey
DateKey
SchoolKey
IsEnrolled
IsInAttendanceSchool
IsAbsentFromSchoolExcused
IsAbsentFromSchoolUnexcused
IsTardyToSchool
IsInAttendanceHomeroom
IsAbsentFromHomeroomExcused
IsAbsentFromHomeroomUnexcused
IsTardyToHomeroom
IsInAttendanceAnyClass
IsAbsentFromAnyClassExcused
IsAbsentFromAnyClassUnexcused
IsTardyToAnyClass
CountByDayOfStateOffenses
CountByDayOfConductOffenses
AvgGradePriorProgressReportsMath
AvgGradePriorProgressReportsEnglish
AvgGradePriorProgressReportsOverall
h1. Implementation Notes
The nature of this table is to record either a single event of interest to the early warning system, or all of the events of interest that occur on a particular day. Which alternative it follow depends on implementation.
Will need to create union of several different queries. Might want to create query as a TVF in order to reduce complexity. Study the QuickSight views carefully but also look at the requirements from the original PowerBI project.
{panel:title=Hard-Coded Values|borderColor=#f2dede|titleBGColor=#f2dede}
(!)
The QuickSight queries include hard coded values from type and/or descriptor tables, which can be manipulated through the API. There is no guarantee that these values will be present.
{panel}
Jira Metadata
Created: 2018-07-19T13:59:38.000-0500
Reporter: Stephen Fuqua
Jira Description
h1. Story
As an Early Warnings System Analytics Data Modeler, I want to import a Student Early Warning Fact Table from the ODS, so that I can create aggregations across the Early Warning System indicators. h1. Acceptance Criteria
Must include the following columns:
h1. Implementation Notes
The nature of this table is to record either a single event of interest to the early warning system, or all of the events of interest that occur on a particular day. Which alternative it follow depends on implementation.
Will need to create union of several different queries. Might want to create query as a TVF in order to reduce complexity. Study the QuickSight views carefully but also look at the requirements from the original PowerBI project. {panel:title=Hard-Coded Values|borderColor=#f2dede|titleBGColor=#f2dede} (!) The QuickSight queries include hard coded values from type and/or descriptor tables, which can be manipulated through the API. There is no guarantee that these values will be present. {panel}
Jira Metadata
Created: 2018-07-19T13:59:38.000-0500 Reporter: Stephen Fuqua