Student dashboard metrics

Prompt:
"Create an interactive dashboard for a student application, displaying key performance and engagement metrics. The metrics should be presented in a clear and visually intuitive way, using graphs, tables, and key indicators.

The metrics to be included are:

Student Retention Rate: Percentage of students who continue using the platform over time. Data is obtained from login and access records.

Course Completion Rate: Percentage of students who successfully complete courses, extracted from the course/student relationship table.

Student Satisfaction Rate (NPS): Average values from the satisfaction survey conducted on the platform.

Course Dropout Rate: Percentage of students who start a course but do not complete it, comparing start and completion records.

Resource Utilization Rate: Frequency of usage of platform resources, tracking interactions and clicks.

Student Progress Rate: Average percentage of student progress in ongoing courses.

Content Update Rate: Frequency of new content being published or updated on the platform.

Visitor-to-Student Conversion Rate: Percentage of visitors who enroll in courses, based on access logs and registrations.

Page Load Time: Average time taken for platform pages to load.

Page Abandonment Rate (Content & Performance): Percentage of users who leave without completing an action, indicating engagement or usability issues.

User Return Rate: Percentage of users who return after their first visit.

Live Event Registration Retention Rate: Comparison between clicks on the registration form and confirmed sign-ups.

Course Progress (Student View): Individual representation of student progress in enrolled courses.

The data will be extracted from specific tables and interaction logs, ensuring automatic updates and actionable insights for platform administrators."

Dashboard Features

This student analytics dashboard provides a comprehensive view of all the requested metrics:

Student Retention Rate: Displayed as a key metric card and as a time series chart showing the trend over months.

Course Completion Rate: Shown as a key metric and broken down by course category in a pie chart.

Student Satisfaction Rate: Presented as a key metric with trend indicator.

Course Dropout Rate: Displayed as a key metric with positive trend when decreasing.

Resource Utilization Rate: Visualized in a dedicated bar chart showing usage across different resource types.

Student Progress Rate: Available in the detailed student progress table with visual progress bars.

Content Update Rate: Tracked in the performance metrics section with daily update frequency.

Visitor-to-Student Conversion Rate: Shown in the engagement metrics section with trend analysis.

Page Load Time: Displayed in the performance tab with improvement metrics.

Page Abandonment Rate: Tracked in the performance section with positive trend when decreasing.

User Return Rate: Shown in the engagement metrics with trend analysis.

Live Event Registration Retention Rate: Displayed in the engagement section with comparative analysis.

Dashboard Structure

The dashboard is organized into four main tabs:

Overview: Shows the most important metrics at a glance

Engagement: Focuses on student interaction metrics

Performance: Displays technical and content performance metrics

Students: Shows individual student progress data

Each section provides both high-level summaries and detailed breakdowns of the relevant metrics, with interactive charts and tables for deeper analysis.