Enrollment Dashboard - Old - Not Applicable
- Sangita Singh
- Kevin Meleedy
- Shruti Kumar
Enrollment Dashboard
These reports provide headcount information at a glance as well as detail level across the benchmarks. The historical data is available for the past 10 years and is at the Final bench. The data for all the benches is available for past 5 year. These reports enable leadership to visualize, slice and dice the data and facilitate with strategic planning.
Data Source: SID
Refresh schedule: Data is refreshed every benchmark. The “Data Refreshed” field on the bottom right of the page indicates when the data was extracted from SID. The "Data Updated" field on the top of the report indicates when the report was published. These two dates are often different.
- Quick Facts → This tab displays the enrollment information at a glance for any given term. The driver for this tab is Semester and Term filters. Term filter is dependent on the Semester filter. This report will be blank, when the Semester filter and Term filter are out of sync.
- College Level → This tab displays the summary of enrollment information for any given term for any college. To see the college data at a detail level, click on the "Details" button at the bottom of the tab.
- College Enrollment Details → Provides the detailed information for 5 terms for the college selected in the Parent tab. This tab also shows the difference in enrollment numbers from the previous semester. Changing the College filter on this tab will also change the College on the Parent page. To go back to Parent page, click on the back arrow at the bottom of the tab.
- Five Year Trend → Provides a summary of enrollment by student level, student type and new/returning student status for a given semester for 5 years. Clicking on "Fall Enrollment" will provide more information on fall enrollment.
- Five Year Fall Enrollment → Detailed level information for Lower Level, Upper Level, Grad I and Grad II for five years. To go back to Parent page, click on the back arrow at the bottom of the tab.
- Ten Year Trend → This report displays the ten year trends of student headcounts for undergraduate and graduate students. This tab has two unique filters "Age Over 25" and "Budget Entity".
- By Benchmark → A visual representation of the headcount information for different benches for a given term. Five years of data is available for these set of reports. There are three detail level reports for all benchmarks. To see the detail reports, click on the "Details" button at the bottom of the tab. There are three child tabs that provides detailed information on enrollment for all four benchmarks.
- Enrollment By Student Level → Provides enrollment information for a given semester and given benchmark for 5 years.
- Enrollment By Benchmark → This report displays enrollment for a given semester at different benches for 5 years in a tabular form.
- Enrollment For Final Benchmark VS Another Benchmark → This report displays the comparison of headcount enrollment between Final bench and any other bench for a given semester.
To go back to Parent page, click on the back arrow at the bottom of the tab.
Data Element | Data Source (underlying data field) | Description | Report Pages |
| Age Over 25 | SID → SID_PERSON_DEMO → BIRTH_YYYYMM_DT | Indicator if a student is above 25 years of age | Ten Year Trend |
| Benchmark | SID → SID_ENROLLMENTS → BENCH | Benchmark such as Preliminary or Final | By Benchmark |
| Budget Entity | SID → SID_ENROLLMENTS → BE_CD | Budget entity such as E & G or Health Sciences | Ten Year Trend |
| Campus | SID → SID_ENROLLMENTS → HOMECAMPUS | The Campus at the time of Enrollment | All Pages |
| Cip | SID → SID_ENROLLMENTS → CIP_STUDENT | College level and Five Year Trend | |
| College | SID → SID_ENROLLMENTS → GLOBAL_COLLEGE | The Global College at the time of Enrollment | All Pages |
| Department | SID → SID_ENROLLMENTS → GLOBAL_DEPT | The Global Department at the time of Enrollment | All Pages except Quick Facts |
| Ethnicity | SID → SID_ENROLLMENTS→ETHNIC | The Ethnicity at the time of Enrollment | All Pages |
| Full Time Indicator | SID → SID_ENROLLMENTS → CURR_TERM_CRS_LOAD | If the student is full time or part time based on the credit hours for the term. For Fall and Spring terms, UG students enrolled in >= 12 credits are considered full-time and GR students enrolled >= 9 credits are considered full-time. For Summer term, UG students enrolled in >= 9 credits are considered full-time and GR students enrolled >= 6 credits are considered full-time. | All Pages except Ten Year Trend |
| Gender | SID → SID_ENROLLMENTS → GENDER | The Gender at the time of Enrollment | All Pages |
| Honors | SID → SID_ENROLLMENTS → HONORS | The Honors Student Status | By Benchmark |
| New/Returning | SID → SID_ENROLLMENTS → STU_RECENT_ADM_DT | If the student is a New student or Returning from the previous term. If the Recent admit date is same as the Termid, then student is New else the student is Returning. | Five Year Trend, Ten Year Trend, By Benchmark |
| Residency | SID → SID_ENROLLMENTS →ETHNIC and FEE_CLASS_RES | The Residency Status at the time of Enrollment. The logic is below: When Ethnic = 'O' Then 'International' | All Pages |
| Semester | SID → SID_TERMID → MONTH | Semester such as Fall, Spring or Summer | All Pages |
| Student Classification | SID → SID_ENROLLMENTS → STU_CLASS_LEVEL | Student Classification such as Lower Level, Upper Level, Grad I and Grad II. The logic is below: When Stu_Class_Level = 'A' Then 'Grad II' | Five Year Trend |
| Student Level | SID → SID_ENROLLMENTS → STU_CLASS_LEVEL | Student level such as Undergraduate or Graduate. The logic is below: When STU_CLASS_LEVEL ='N' Then 'Non-Degree Seeking' | All Pages |
| Student Type | SID → SID_ENROLLMENTS → STU_RECENT_ADM_TYP | Student Type such as FTIC or Masters | All Pages except Student Type |
| Term | SID → SID_ENROLLMENTS → TERMID | Term such as Fall 2020 or Spring 2018 | All Pages |
Filter Panels
Filters are listed on top or on side panel of the report.
Notes:
- Click the down arrow to select from options in the filters and narrow down your results.
- To deselect an item, click on the option again.
- Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons
. - Some filters allow multiple selections. To select multiple values in a filter, hold the Ctrl key as you check the square boxes
.
- Filters for the report may not have Blank as an option.
Data Panel
This panel displays the filtered results. To work with data in this panel:
- Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
- You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears
, you can sort that column in ascending or descending order by clicking on your mouse.
Options for the Data Panel
Export Data to Excel
To export the data results to Excel, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar 
will pop up. Click the 
in the top right corner .
A drop down menu will appear with 'Export data' as one of the options. Select Export Data to work with the data in Excel.
Note : The exported data in Excel may not look exactly like the screen.
Focus Mode
To see the data in Focus Mode, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar will pop up. Click the option for Focus Mode 
It allows the visual to take the entire space in the report canvas. Full screen mode will persist until you exit out or click on 
on the top left hand side.
When in Focus Mode, click the in the top right corner and a drop down menu will appear with the following options:
You can export data, or see the data in a table by selecting the appropriate option.
Spotlight
Spotlight causes all other visuals on the page to fade so the selected visual is highlighted. To highlight a visual, click on more action and select 
Drill Up and Drill Down
If the visual has the hierarchy, the 
menu will appear when you hover on the top left side of the visual. Turn on drill down first by selecting the downward arrow. The grey background 
lets you know that drill down is active. Selecting 
will expand another level of hierarchy. Selecting the double arrow 
drill-down icon takes you to the next level in the hierarchy. Selecting 
will take you one level up in hierarchy. The arrows will be greyed out if the option is not available.
Reset to Default
If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image above the report in the Report Header: 