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.