These views were created to support the QuickSight Starter Kit. The views are analogous to the data model and calculations in the PowerBI Starter Kit's Tabular Data Model, accounting for limitations in QuickSight. The views could be used with other business intelligence tools, not just QuickSight. However, because they query from the regular Analytics Middle Tier views, the performance would be very poor when directly running these views. If these views are of interest, then it is recommended that the regular Analytics Middle Tier views be "materialized" into real tables on a schedule. See the AMT-DataMart.sql sample script for copying view output to tables.
Although they may not prove to be of practical value, studying the views may prove useful for those who wish to build their own metrics in another data modeling tool (e.g., Tableau).
Views in this Collection
- qews_SchoolRiskTrend View
- qews_StudentAttendanceTrend View
- qews_StudentEnrolledSectionGradeTrend Views
- qews_StudentEnrolledSectionGrade View
- qews_StudentIndicatorsByGradingPeriod View
- qews_StudentIndicators View
- qews_UserSchoolAuthorization View
Install using the option code "QEWS"
For more information, see the AMT Deployment Guide.
Some of the views below rely on configuration information to determine what threshold values indicate a student is "At risk of dropping out of high school" or should be flagged for "early warning" before they become "at risk." These values can be configured by the end-user through the
|Column||Data Type||Default Value||Description|
|GradeAtRisk||decimal||65.0||Threshold for a grade to flag the student as At risk|
|GradeEarlyWarning||decimal||72.0||Threshold for a grade to flag the student for Early warning|
|AttendanceAtRisk||decimal||80%||Threshold for attendance to flag the student as At risk|
|AttendanceEarlyWarning||decimal||88%||Threshold for attendance to flag the student for Early warning|
|OffenseAtRisk||decimal||0*||Threshold for state offenses to flag the student as At risk (Note that there is no definition for "early warning")|
|ConductAtRisk||decimal||5||Threshold for student code of conduct violations to flat the student as At risk|
|ConductEarlyWarning||decimal||2||Threshold for student code of conduct violations to flag the student for Early warning|
- No labels