Description
| Excerpt | ||
|---|---|---|
| ||
The Student Enrollment and Tuition Forecasts and Actuals Basic dashboard Dashboard offers summary level aggregation of student enrollment, tuition, and credits, as well as budgets (forecasts). The data is budgeted for school, career level, load, residency, and tuition attributes. |
You may use this dashboard as a template to build or customize your own versions of the dashboards for your needs. Read here for custom views.
The Student Enrollment and Tuition Forecast and Actuals
...
Dashboard captures the following data:
recent data for 15 years, as of a previous business day
term census data, captured for the last 5 years.
monthly snapshots, going back for 5 years. Monthly snapshots are captured at last day of a month, from the beginning of enrollment for a term and capped at the census date for that particular term.
This dashboard in NOT to be used for individual student enrollment analysis.
Key Business Questions
This dashboard can be used to answer different enrollment-related business questions, such as:
| Excerpt | ||
|---|---|---|
| ||
|
| Anchor | ||||
|---|---|---|---|---|
|
The Student Enrollment and Tuition Basic Dashboard has four separate tabs, which can be accessed from the top of the view:
...
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Enrollment and Tuition by Academic Plan
This dashboard reports enrollment, tuition, and credits. It does not have budgets (forecasts). It reports by school, career level, academic plan, tuition division, residency, and load. You can also expand this report to report by Academic Sub Plan and Academic Program, if needed.
...
IF Student JD Split Ratio is empty THEN count students whose Primary Plan Student Count is set to 1IF Student JD Split Ratio is not empty THEN sum up Student JD Split Ratio
How to download report?
...
You can download your report by clicking on Download button
...
It was noted before that you can bring new fields from the Enrollment and Tuition Forecast and Actuals data source by using the Web Edit. When you use Web Edit to create or modify an enrollment and tuition report which does not report budget data, use any of the columns in the data source, except for columns in folders “x-Budgeted Info” and “xx-Budget Raw Data”. These two folders are reserved for reports of budgeted (forecasted) data.
...
Enrollment and Tuition by Tuition Division with Online Groups and Tuition Amount
This dashboard is similar to Enrollment and Tuition by Academic Plan dashboard. The difference is that it also provides a breakdown by Tuition Attribute and Tuition Credited, and also incorporates Online groups into Tuition Division categories. Online groups are current student groups where student group code starts with ‘O' (excluding 'OPIT’defined by budgeted attribute of ‘OLP’ ‘Online Program’ (previously online groups were defined in student groups; changed to use budgeted attribute on 5/16/2024)
The Enrollment, Tuition, and Number of Students are counted for all the similar categories, in addition to the Tuition Credited.
This tab does not have budgeted numbers, just the actual enrollment. Please see the documentation for Enrollment and Tuition by Academic Plan for more details.
...
Enrollment and Tuition Compared to Forecast - by School
This dashboard is similar to Enrollment and Tuition by Academic Plan dashboard. The difference is that it reports actual enrollment and tuition numbers, as well as budgets (forecasts) and variance.
...
Folder ‘xx-Budget Raw Data’ is the raw budget data and should not be used. It is reserved for an Analytics team for a narrow set of uses.
...
Enrollment and Tuition Trends
This dashboard shows student enrollment and tuition trend over years, and can be filtered for your school (Academic Group). The dashboard excludes Pitt-Outlier (UOUT) Academic Program and Semester at Sea. The student data is counted only for primary plans and accounts for joint degree split ratio.
...
What is the source of this information?
The primary source of data is the PeopleSoft Student system. The data is copied, transformed, and loaded into the data warehouse nightly, and subsequently brought to Tableau Server into Enrollment and Tuition Forecast and Actuals Basic data source. Data available today reflects yesterday’s PeopleSoft data. New data entered in PeopleSoft today will be in student mart, data source, and dashboard tomorrow.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
For Cognos Users: this data source is similar to the existing Cognos “St Enrollment, Tuition, budget Report Pkg” package and is built from the student data mart (UD_DATA). |
| Anchor | ||||
|---|---|---|---|---|
|
Anyone with access to Student Mart (ST) will have access to the Enrollment and Tuition Forecast and Actuals Basic Dashboard. Users will only see their RC, unless otherwise approved on their Federated Authorization form.
...