Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The dashboard excludes Pitt-Outlier (UOUT) Academic Program and Semester at Sea.

The Enrollment Actual, Tuition Actual, and FTE Enrollment Actual are only calculated for students' primary plans and account for students with split joint degrees.

...

Expand
titleWhat data fields are available in the table?

The list below shows fields visible in the dashboard. The Tableau Data Source offers many additional fields. Users can utilize Tableau’s Web Edit feature to customize the table and add new fields for their own purpose(s). When you need to report new columns vs applying filters, this needs to be done with Web Edit and cannot be done using the a custom view functionality. Filter settings can be saved using a custom view.

  • Academic Group

  • Academic Program

  • Academic Plan

  • Academic Sub Plan

  • Career Level

  • Tuition Division

  • Full of Part Time (Load)

  • Residency

  • Enrollment Actual

  • Tuition Actual

  • Number of Students

  • Credits Billed

  • Tuition Credited

  • FTE Enrollment Actual

...

Expand
titleHow to use the dashboard's prebuilt Academic Group/Program/Plan/Sub Plan hierarchy?

Academic hierarchy is prebuilt in Enrollment and Tuition Forecast and Actuals Data Source and can be used in Web Edit, or manipulated in a preexisting dashboard.

This is the view of hierarchy in data source:

this is the view of hierarchy in data sourceImage Removedthis is the view of hierarchy in data sourceImage Added

You can modify the depth of a hierarchy you see in a preexisting dashboard.

Here you can expand Academic Plan to also show Academic Sub Plan. Hover over Academic Plan column and click on ➕ sign

This will be the resulting view

To remove the Academic Sub Plan, click on the ➖ sign that appears on the Academic Plan heading.

In this dashboard, you can completely remove Academic Plan by collapsing the hierarchy by clicking the ➖ sign when you hover over Academic Group

Then, again, you can expand the Academic Group up to Academic Sub Plan. Please note that the newly added categories (Program, Plan, Sub Plan) will appear next to each other, in the order of their hierarchy

To collapse the hierarchy, click on the ➖ sign.

You can reset the dashboard to the original view (original layout of columns and original selection of filters) by clicking on a Revert button.

The dashboard has measures that have word Actual, such as Enrollment Actual, Tuition Actual, and FTE Enrollment Actual. These calculations account for students with split joint degrees and students' primary plans. For example, Enrollment Actual has the following calculation:

IF Student JD Split Ratio is empty THEN count students whose Primary Plan Student Count is set to 1
IF Student JD Split Ratio is not empty THEN sum up Student JD Split Ratio

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.

...

Back to Top

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, as well as incorporates Online groups into Tuition Division categories. Online groups are current student groups where student group code starts with ‘O' (excluding 'OPIT’)

The Enrollment and Tuition, as well as Number of Students are counted for all the similar categories, plus the Tuition Credited.

It does not have budgeted numbers, just the actual enrollment. Please see the documentation for Enrollment and Tuition by Academic Plan for more details.

...

Back to Top

Enrollment and Tuition Compared to Forecast - by School

...

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.

Back to Top

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 is also provides a breakdown by Tuition Attribute and Tuition Credited, as well as incorporates Online groups into Tuition Division categories. Online groups are current student groups with student group code starting with ‘O' (excluding 'OPIT’)

The Enrollment and Tuition, as well as Number of Students are counted for all the similar categories, plus the Tuition Amount (Tuition Credited is used).

It does not have budgeted numbers, just the actual enrollment.

...

Back to Top

Enrollment Tuition and Counts

...