Ai Chat

Student Performance Dashboard with Dynamic Enrollment Segmentation

dashboard performance analysis window functions data visualization
Prompt
Design a PostgreSQL stored procedure that generates a comprehensive student performance dashboard, automatically segmenting enrollment data across multiple academic years. The procedure must calculate grade point averages, retention rates, and performance trends using window functions. Include logic to dynamically filter data by department, program, and cohort year, with output compatible with Google Sheets for visualization. Ensure the procedure handles null values gracefully and provides percentile ranking for student achievement.
Sign in to see the full prompt and use it directly
Sign In to Unlock
Use This Prompt
0 uses
7 views
Pro
SQL
Education
Mar 2, 2026

How to Use This Prompt

1
Copy the prompt Click "Copy" or "Use This Prompt" above
2
Customize it Replace any placeholders with your own details
3
Generate Paste into Ai Chat and hit generate
Use Cases
  • Monitoring student success across various demographics.
  • Identifying trends in enrollment and performance data.
  • Enhancing academic support services based on dashboard insights.
Tips for Best Results
  • Regularly update the dashboard with new data.
  • Train staff on how to interpret dashboard metrics.
  • Use visualizations to simplify complex data.

Frequently Asked Questions

What is the Student Performance Dashboard with Dynamic Enrollment Segmentation?
It's a dashboard that visualizes student performance and enrollment data.
Who can use this dashboard?
Educators and administrators looking to track student success.
How does it enhance decision-making?
By providing real-time insights into student performance trends.
Link copied!