enrollment-analytics

Analyze Fall 2025 enrollment data with DISTINCT student counts and prefixed SQL columns.

38|6|Updated Jan 15, 2026
One-click install
npx skills add https://github.com/aws-samples/sample-agentic-ai-with-claude-agent-sdk-and-amazon-bedrock-agentcore --skill enrollment-analytics
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: enrollment-analytics
Source: https://github.com/aws-samples/sample-agentic-ai-with-claude-agent-sdk-and-amazon-bedrock-agentcore/tree/main/.claude/skills/enrollment
Command: npx skills add https://github.com/aws-samples/sample-agentic-ai-with-claude-agent-sdk-and-amazon-bedrock-agentcore --skill enrollment-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyzes student enrollment data to provide actionable insights into enrollment trends, course loads, and changes over time for academic planning and reporting.

Core Features & Use Cases

  • Enrollment tracking: compute counts of enrolled students per course and overall counts to support capacity planning.
  • Student-level metrics: derive per-student course loads and enrollment status summaries for cohort analysis.
  • Use Case: generate a Fall 2025 enrollment dashboard showing enrollments by course, by student major, and year-over-year changes.

Quick Start

Ask the AI to generate Fall 2025 enrollment analytics queries that return student counts by course and per-student course loads.

Frequently Asked Questions about enrollment-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate student enrollment counts and per-student course loads for Fall 2025?

You can generate Fall 2025 enrollment analytics by requesting SQL queries that return student counts by course and per-student course loads. The Skill enforces current semester filters and uses DISTINCT for accurate student counts.

What is the best way to build an enrollment dashboard with year-over-year cohort trends?

Building an enrollment dashboard requires analyzing enrollment data to produce course-level counts, student major breakdowns, and year-over-year changes. This Skill structures SQL with prefixed columns to support cohort trend reporting.

How does DISTINCT enforce accurate student counts in SQL enrollment queries?

Using DISTINCT in SQL enrollment queries prevents duplicate student records from inflating headcounts. This Skill applies DISTINCT to compute accurate per-course and overall enrolled student counts for academic capacity planning.

Can I use enrollment analytics for cohort analysis and student major breakdowns?

Yes, enrollment analytics derives student-level metrics like course loads and enrollment status summaries for cohort analysis. It generates views showing enrollments by course and by student major for academic planning.

Do I need existing enrollment data to generate Fall 2025 cohort trend reports?

Yes, you need existing enrollment data to analyze trends and changes over time. The Skill processes this data to produce Fall 2025 enrollment counts, per-student course loads, and year-over-year cohort trend reports.