October
AI Reporting (Beta)
Release Date: October 21, 2026
Introducing AI Reporting, a new way to create custom reports in ampEducator using everyday language.
Instead of manually selecting tables, columns, filters, and calculations, simply describe the information you're looking for. AI Reporting interprets your request, generates a report, and displays a preview of the results.
What's New:
- Natural Language Reporting: Describe the report you need without writing SQL or manually configuring report fields.
- Quick Answers: Get information about enrollment, attendance, student balances, prospects, and other institutional data.
- Refine Your Reports: Make adjustments using follow-up requests, such as adding filters, changing columns, or sorting results.
- Advanced Reporting: Generate reports involving calculations, grouping, totals, averages, and data from multiple areas of ampEducator.
- Reusable Reports: Convert AI-generated reports into standard Report Builder reports to save, edit, share, and reuse.
For example, you could ask: "Show active students in the current session with attendance below 75%, ordered from lowest attendance to highest."
Getting Started: Navigate to Home → Reports → AI Reports.
AI Reporting is currently available in Beta as an optional add-on. We recommend reviewing AI-generated reports for accuracy before relying on them for important decisions.
Watch the AI Reporting Webinar on our YouTube Channel, or check out ourAI Reporting Documentation.
Report Builder: Calculated Columns and Enhanced Reporting
Release Date: October 21, 2026
We've expanded the capabilities of Report Builder, making it easier to create more advanced custom reports without writing SQL.
What's New:
- Calculated Columns: Create new report columns using existing data. Use conditional logic (Simple Case) to display values based on specific conditions, or perform mathematical calculations such as addition, subtraction, multiplication, and division.
- Enhanced Grouping: Group reports by selected columns, including calculated values and transformed data, such as the month or year of a date.
- Advanced Filtering: Apply Having conditions to selected columns, allowing you to filter grouped or calculated results.
- Flexible Sorting: Sort reports by any selected column, including calculated values, counts, totals, averages, and other aggregated results.
These enhancements provide greater flexibility when building reports, allowing you to calculate, group, filter, and sort data to better meet your institution's reporting needs.
Learn More: Report Builder Documentation
Data Warehouse: New Reporting Tables
We've expanded the ampEducator Data Warehouse with two new tables, providing additional flexibility for reporting and analysis.
What's New:
- Programs (dw_programs): Access program-level information, including program structure, status, duration, credentials, grading, and other program attributes.
- Date Dimension (dw_date_dimension): Analyze data across continuous date periods, including days or months with no recorded activity.
The Date Dimension table is particularly useful for reports that need to display periods with zero results, such as monthly prospect counts.
These additions bring the Data Warehouse to 21 reporting tables, providing more options for building custom reports and dashboards.
Learn More: Data Warehouse Documentation