SSRA Year to Year Admissions Report
- Glendalis Gonzalez
- Maham Khan
- Kevin Meleedy
Year to Year Current Week Admissions Snapshot Report
This operational report provide admissions cycle funnel by Ethnicity, Gender, Origin and Academic Profile for the year to year of cycle. The historical data is available for the past 2 years. These reports enable leadership to report, track, and plan admissions on a weekly basis.
Data Source: ADM
Refresh schedule: Data is refreshed every week. The “Data Refreshed” field on the top right of the page indicates when the data was extracted from ADM.
Below are the tabs for the report:
- Year to Year Current Week Admissions Snapshot – Homepage presents Ethnicity, Gender (Female/Male), Origin (In-State/Out-Of-State/International) and Academic Profile (High School GPA/SAT/ACT) Admissions cycle for the current week based on the most current year displayed of each year cycle.
Filters included: Term (Summer/Fall/Spring), Campus, College, Applicant Level (Graduate/Undergraduate) and Applicant Type (Freshmen/Masters/PhD Professional/PhD Research/Transfer/FCS Lower Lever/Transfer FCS Upper Level/Transfer FSR).
Data Element | Data Source (underlying data field) | Description |
Term | SQLDWPRO.mart.Term_DIM | The Summer, Fall and Spring |
Campus | SQLDWPRO.mart.Campus_DIM | The campus in which student applied |
College | SQLDWPRO.mart.applicant_dim | The college in which student applied |
Applicant Level | SQLDWPRO.mart.APPL_Admit_Type_DIM | Applicant Level such as Undergraduate and Graduate |
Applicant Type | SQLDWPRO.mart.APPL_Admit_Type_DIM | Applicant Type such as Freshman, Masters, PhD Professional, PhD Research, Transfer FCS Lower Level, Transfer FCS Upper Level, Transfer FSR, Transfer Other Lower Level, Transfer Other Upper Level and Transfer Second Bachelor |
Filter Panel
Filters are listed on top 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.
- 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 dropdown 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 
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: 