Using Analytics Dashboards and Query
Analytics - Working With the Student List
Navigating the Dashboard - Using Dashboard Tools and Filters
Navigate to Aeries Analytics > Analytics Dashboard
Applying an Item Filter to an individual Dashboard graph regarding Schools, Grades or SubGroups will automatically adjust the chart data being viewed. The updated filter settings for each user are stored in the User Account Options (UAO) table, separately for each dashboard and item. Filters will be remembered and displayed each time a user accesses the Analytics Dashboard area. Filters can be modified at any time. At least one school and one grade must stay selected.
Clicking on a section of the chart will display the students associated with that specific section of the chart.
Dashboard Tools
The Dashboard has the following button options that can be found in the top right corner of the dashboard area. LCAP Dashboards will only display the Dashboard Filters button.
Dashboard Filters
Filters can additionally be applied to all charts in a Dashboard group by using the Dashboard Filters option on the top right of the page. When users apply a filter at the Dashboard level, the filter selections will be pushed down to all of the dashboard items.
In the example below, a filter was applied to only display data for Screaming Eagle High School and Grades 9-12. The data in the charts in this dashboard were updated according to the filter and a label was added to the bottom of each chart identifying the filter.
The Dashboard level filters for each user are stored in the User Account Options (UAO) table. Filters will be remembered and displayed each time a user accesses the Analytics Dashboard area. Filters can be modified at any time.
The Dashboard Filters have a Search option to help search for school name, grade or subgroup name. Typing criteria in the search box will display relevant results. Use All / None to select or clear a tab, and Apply Filters to save. When more than one SubGroup is checked, students in any of the checked subgroups are included.
Settings
The Settings button displays the Dashboard settings including the Name of the dashboard as well as the Security Groups the dashboard is shared with. The Shared checkbox and Security Groups only display for users with Admin permission to Analytics Dashboard; other users can rename the dashboard.
The Settings, Delete and Add Items buttons display on dashboards you own, or on any dashboard for users with Admin permission to Analytics Dashboard. On a shared dashboard you do not own, only Dashboard Filters and Copy display.
Copy
The Dashboard Copy button allows an existing dashboard to be copied. It provides a Copy Dashboard option box where a new name for the copied dashboard can be added. Users with Admin permission to Analytics Dashboard can also set whether the copy is Shared; copies made by other users are private. The copy includes all of the dashboard's items.
Delete
The Dashboard Delete button will delete a dashboard. The Delete button displays on dashboards you own, or for users with Admin permission to Analytics Dashboard. The below message will display before a deletion can occur.
Add Items
The Add Items button on the Dashboard allows for the quick addition of an already existing item to be added to the dashboard. To select an existing item to add to the dashboard click on the 
The Add New Item option at the bottom of the Add Dashboard Items dropdown can be used to add a new item to the Dashboard. Clicking on Add New Item first asks "Would you like to copy an existing item?" Select Yes to pick an item to start from, or No to start with a blank item. The configuration wizard then opens.
The configuration wizard allows you to set up the item.
Step 1 focuses on the visual aspects of the item.
Step 2 will ask for a name for the Item. If the type of item was designated as a Chart on Step 1 it will also ask the user to select an Analysis Indicator to be associated with the item. If on Step 1 the type of item was designated as a List Step 2 will ask how many of the students with the highest early warning points to display. If By SubGroup was selected on Step 1, Step 2 also asks for one or more Sub Groups. For Pie charts, some Step 1 options (such as count or percentage) are not asked.
Step 3 asks which schools should be associated with the item being created.
Step 4 asks which grade levels to associate with the item. Step 4 also displays a Preview and a Save button. The Save button will save the newly created item.
The Preview button can be used to preview what the newly create item will look like before saving it. Clicking on Preview will display a preview window. Clicking on the Previous button in Step 5 will take the user out of preview mode. Clicking on Save in the preview mode will save and create the new Item. Below is an example of preview mode before save.
Dashboard Item Tools
Navigate to Aeries Analytics > Analytics Dashboard > individual chart on the dashboard
The Dashboard Items can display up to 6 icons on the top right corner: Edit, Image, Link, Info, Expand and Remove (X). Edit displays for the item's owner or users with Admin permission to Analytics Dashboard, X displays if you can change the dashboard, and Link displays on charts for Analytics Dashboard Admins only. List items show an Excel icon in place of the Image icon. LCAP dashboard items cannot be edited or removed.
The Edit icon brings up an Edit Dashboard Item window where the Dashboard Item can be modified.
The Image icon allows the user to download an image of the Dashboard Item.
The Link icon (Get a Link to this chart) provides a Public URL for the chart. Anyone with this URL can view the chart without signing in to Aeries, so share it carefully.
Note: The default settings in the AeriesNetConnections.config file must point to the same database as the generated URL for the generated URL to successfully return a graph/data. Please contact Aeries Support if you need assistance checking your AeriesNetConnections.config file.
The Info icon when clicked will display the Dashboard item Threshold information.
The Expand icon when clicked will expand that Dashboard Item into a larger display.
The X icon on the individual Dashboard Items will remove that item from that particular dashboard. A warning message will display to confirm the decision before it is removed.
Dashboard Item Filters
Navigate to Aeries Analytics > Analytics Dashboard > individual chart on the dashboard
This chart shows the distribution of English Learners by grade level. Filters can be used to view the data by school and ELPAC levels in order to develop intervention strategies.
Using the Item Filters to drill down, select high school only – note the chart has adjusted to only show grades 9-12.
Apply a Subgroup filter for ELPAC - Beginning - Somewhat Developed English and a total of 48 students are found.
Click a section of the chart, or click the Students tab, to see the names of the students.
Using Analytics Dashboards and Query ↑
Navigate to Aeries Analytics > Analytics Dashboard > select a Chart or List item on a Dashboard
To run a Query navigate to Query
Aeries Analytics allows you to KEEP students that are in a List item or in a Chart. Once the students are kept queries can be run using only those kept students. In the below example the Golden Eagle students that achieved the lowest performance level of the most recent SBAC test are kept. (Texas districts would use their own state test IDs, such as STAAR or TELPAS.)
Then the following query is run in Query to create a report of these students with their most recent SBAC and ELPAC scores.
LIST STU IDN TCH TST STU.ID STU.NM STU.GR TST.ID TST.PT TST.SS TST.PL TST.OT TST.TD TST.TA TCH.TE BY TCH.TE IF ( TST.ID = "SBAC" AND TST.PT = 1 AND TST.TD > 06/30/2025 ) OR ( TST.ID = "ELPAC" AND TST.PT = 0 AND TST.TD > 06/30/2025 )
Additional conditions can be used in Query to limit results or enhance information. In the below example a KEEP query is used to limit the students that have already been kept from the Analytics chart to only include those students with Early Warning Points (STU.RP) > 10. Also, the Early Warning Point field (STU.RP) is added to the LIST query.
- KEEP STU IF RP > 10
- Add STU.RP to the Query above so that it reads:
LIST STU IDN TCH TST STU.ID STU.NM STU.GR STU.RP TST.ID TST.PT TST.SS TST.PL TST.OT TST.TD TST.TA TCH.TE BY TCH.TE IF ( TST.ID = "SBAC" AND TST.PT = 1 AND TST.TD > 06/30/2025 ) OR ( TST.ID = "ELPAC" AND TST.PT = 0 AND TST.TD > 06/30/2025 )
It is also possible to just get a list of students by grade level with Early Warning Points (STU.RP) greater than a given number
LIST STU STU.SC STU.ID STU.NM STU.GR STU.RP BY STU.GR IF STU.RP > 20
Analytics - Working With the Student List ↑
When working with the list of students, the student records can be selected and Intervention records or Supplemental Attendance records can be created for them, or the Keep Students button can be selected and a query can be run for these students.
Set Student
Alternatively, the Set button can be selected for a student. This is equivalent to “Getting” the student. Once a student is Set in Aeries Analytics, the user can navigate to a different part of the system to review that student’s records. In the below example we selected Set for Edward Cortes…
and then navigated to the Attendance page to view his attendance.
Create Supplemental Attendance Records
Analytics allows for the ability to Create Supplemental Attendance Records for students by using the Create Supp Att Rcds button on the Student List. Students can be selected in a variety of ways:
- select all students by clicking on the check mark in the header
- select individual students by clicking on the box to the left of their ID
- select specific grade levels by using the Item Filters to limit by Grade and then use the check mark in the header
All selected students must be at the same school, otherwise the message "Selected students must belong to same school for this option to work." displays. The KEEP Students, Create Intervention Rcds and Create Supp Att Rcds buttons do not display for teachers. Clicking KEEP Students replaces any students you had already kept.
Create Intervention Records
There is also the ability to Create Intervention Records for students by using the Create Intervention Rcds button on the Student List. Use the same method of selecting student as described in the Create Supplemental Attendance Records section above.
Student Groups ↑
Navigate to School Info > Student Groups
Student Groups can be linked to Aeries Analytics Indicators and will dynamically update with new students nightly or when indicators are manually processed.
To create a new dynamic student group click on the Add button, enter the Group Name, dates and Group Description if desired, and in the Dynamic Group drop-down select Analytics. Click on the Insert button to add the Student Group.
Next select the Analytics Indicator(s) and Level(s) that will be used to populate this group. Additionally, staff members can be added in the Associated Staff Members tab so they can see this group. Click on Save when all selections have been made.
The list of students will be populated based on the Analytics Indicator and levels that were selected. Every time Analytics is re-processed (either nightly or manually) the Student Group list is updated. The Use This Group button can be used to KEEP the students in this group for further review or processing.
