Examples
Here are example queries to get you started. Feel free to copy these and change what you need.
Persistence and Completion Prediction Queries
- Average Persistence and Completion Scores by Origin
- Average Persistence and Completion Scores by GPA Band
- Average Persistence and Completion Scores by Term
- Dropped Students with Low Persistence and Completion Scores
- Student Predictions by Credit Load
- Average Persistence and Completion Scores by Transfer Credit Band
- Financial Aid Impact Analysis
- Student Predictions by Course
Completion Prediction Queries
- Student Completion Prediction by Years in College and Awards
- Student Completion Predictions
- Daily Completion Score Shifts
- Weekly Completion Score Shifts
Engagement Scores Queries
Persistence Prediction Queries
- High GPA Students with Low Persistence Scores
- Percentile Binned Students by Persistence Score
- Student Persistence Predictions
- Student Persistence Prediction by Age
- Student Persistence Prediction by Location
- Student Persistence Score Shift
- Student Persistence Risk Indicators
- Student Persistence Prediction by College
- Student Persistence Prediction by Financial Aid
- Discovering Term Names and Continuation Patterns
- Students Who Continued from One Term to Another
- Summary Count by Career Type
- All Continuation Patterns from a Specific Term
Student Feature Queries
- Latest Student Feature Values
- Single Student Ranked Features
- Top and Bottom Percentile Section LMS Features Values
- Student Feature Peer Comparison (Avg & Z-Score)
Academic Queries
- First-Generation College Student Academic Performance Analysis
- Developmental Education Effectiveness Analysis
- Course Modality Performance Comparison
- Cohort Progression Milestone Tracking
- Academic Standing Recovery Patterns
- Academic Outcomes
- FTPT (Full-Time Part-Time) Risk Analysis
Data Freshness Queries
- Latest Full Data Warehouse Load Complete Time
- Full Data Warehouse Load History
- Per-Table Freshness
- All Table Freshness Timestamps