Skip to end of metadata
Go to start of metadata

Overview

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

Installation

Install using the option code "QEWS"

.\EdFi.AnalyticsMiddleTier.Console.exe -c "..." -o QEWS

For more information, see the AMT Deployment Guide.

Configuration

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 analytics_config.QuickSightEWS table.

ColumnData TypeDefault ValueDescription
​GradeAtRiskdecimal​65.0Threshold for a grade to flag the student as At risk​
GradeEarlyWarningdecimal72.0Threshold for a grade to flag the student for Early warning
AttendanceAtRiskdecimal80%Threshold for attendance to flag the student as At risk
AttendanceEarlyWarningdecimal88%Threshold for attendance to flag the student for Early warning
OffenseAtRiskdecimal0*Threshold for state offenses to flag the student as At risk (Note that there is no definition for "early warning")
ConductAtRiskdecimal5Threshold for student code of conduct violations to flat the student as At risk
ConductEarlyWarningdecimal2Threshold for student code of conduct violations to flag the student for Early warning

Contents

  • No labels