Higher Education Student Retention Dashboard Specification

Role: Senior Higher Education Business Intelligence Architect

Context

• Target Institution: {{institution_name}}
• Student Segment: {{target_cohort}}
• Virtual Learning Data Source: {{lms_data_source}}
• Core Student Information System: {{sis_data_source}}
• At-Risk Threshold Model: {{risk_threshold_rules}}
• User Access & Governance: {{advisor_role_permissions}}

Task

Generate a comprehensive functional and technical dashboard specification for an early intervention student retention dashboard, enabling academic advisors to identify and support struggling students prior to key census milestones.

Method

1. Map data ingestion pipelines from {{sis_data_source}} and engagement metrics from {{lms_data_source}}.
2. Define primary student risk metrics based on {{risk_threshold_rules}} (e.g., assignment latency, attendance dips, grade trajectories).
3. Establish cohort filtering parameters tailored to {{target_cohort}} across colleges and degree programs.
4. Draft layout wireframes spanning executive overview, course-level risk grids, and individual student profile views.
5. Specify row-level security and data privacy safeguards compliant with {{advisor_role_permissions}}.
6. Detail interactive component behaviors including drill-through paths, note logging, and intervention flagging.
7. Define alert notification triggers and threshold breaches for immediate advisor outreach.
8. Outline required data refresh frequencies, caching policies, and latency expectations for {{institution_name}}.

Constraints

• MUST maintain FERPA-compliant privacy rules preventing unauthorized cross-department visibility.
• MUST NOT display raw personally identifiable medical or financial aid notes on aggregate reporting cards.
• Every metric calculation must include exact numerator and denominator logic.
• Layout must account for responsive viewing on standard staff desktop and tablet viewports.

Output format

Provide a technical specification structured under these exact headers:

1. Executive Summary & KPI Architecture (under 250 words)
2. Data Ingestion & Integration Matrix (table format: Source, Field, Frequency, Join Key)
3. Visual Component Specification (detailed component breakdown by screen zone)
4. Security & Permissions Matrix (role-to-object visibility mapping)
5. Validation & Edge Case Rules (bulleted list)

Self-review

• Ensure all variables ({{institution_name}}, {{target_cohort}}, {{lms_data_source}}, {{sis_data_source}}, {{risk_threshold_rules}}, {{advisor_role_permissions}}) are referenced.
• Confirm calculations for retention indicators are mathematically unambiguous.
• Verify student privacy safeguards are explicitly documented across all screens.