Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

Student Data & Dashboards | Financial Data & Dashboards

Knowing which dashboard to use when delivering a report or which data source(s) to select when creating a new dashboard can be overwhelming, especially when the sources contain similar data with nuanced differences. We’ve included comparisons of Enterprise Resources and examples of key business questions answered within the resource.

If an Enterprise Dashboard answers your business question(s), you can use the dashboard filters and save a custom view to pre-package common report requests. You shouldn’t need to create copies of Enterprise Dashboards or design custom dashboards frequently. If you are spending significant time copying, editing, or building custom dashboards, reach out to see if we can help!

It is also important to note that the Enterprise Dashboards and Data Sources were designed with the intention of “one size fits most.” To change the Enterprise Dashboard to “one size fits me,” see the Catalogs for Student, Financial, and HR Data Sources. These pages contain details, important notes, and a listing of the fields you can add, subtract, and finagle. Then use Tableau Web Edit to create your own spin on an Enterprise Dashboard.

To smooth the transition from Cognos to Tableau, please review the tables below. The Enterprise Resources are listed with their correlating Cognos Packages that previously served similar use cases.

STUDENT DATA & DASHBOARDS

Enterprise Dashboards & Data Sources

Description & Use Cases

Migratable Cognos Report Examples

Correlating Cognos Package(s)

Active Student

Dashboard Quick Start | Data Source Details

Released: May 2023

 Description

The Active Student Dashboard provides a summary of current “active students” (students are de-activated after 3 terms of inactivity). Use this dashboard to view a breakdown of students by program or degree, generate contact lists, or identify students with outstanding service indicators.

 Key Business Questions

  • How many students are currently enrolled across each of the majors offered in my school?

  • Which advisor(s) have the lowest / highest number of assigned students?

  • Who are the students assigned to a specific advisor? What are their demographics / test scores / grades?

  • Which students matriculated for the current term have not yet enrolled?

  • Which students have outstanding holds that will block enrollment?

  • What are the demographics of students associated with a specific school / degree program?

  • Which active students have not yet enrolled in the current / upcoming term?

  • Can I get a student mailing list?

  • Report of Majors and Departments

  • Report of Advisor Load

  • Report of Undeclared Students

  • Mailing List for Scholarship-eligible Students

  • Student Enrollment Status & Holds

  • Active Students Not Enrolled

ST Active Student

Decommissioned: November 8, 2024 *(announcement)

Class Schedule

Dashboard Quick Start | Data Source Details

Released: March 2023

 Description

The Class Schedule Dashboard offers a summary of University classes, including information on number and frequency of offerings, enrollment capacity, waitlist capacity, and assigned instructors so that users can analyze trends in class demand and instructor load.

 Key Business Questions

  • What Accounting undergraduate classes are offered in the Fall 2023?

  • What classes are offered by School of Education?

  • How many students are enrolled in my classes? How full are classes compared to enrollment capacity?

  • Which classes are listed as online classes?

  • Which classes have less than 50% enrollment capacity?

  • What are the meeting days/times for my classes?

  • Which instructors have the highest/lowest course loads last semester?

  • Class Enrollment Caps, Totals, & Waitlists

  • Instructor Assignment Report

  • Report of Instructor Course Load

  • Class Seat Reserve Dates

  • Term Schedule-by campus

ST Class Schedule

Decommissioned: November 8, 2024 (announcement)

Student Enrollment

Dashboard Quick Start | Data Source Details

Released: July 2023

 Description

The Student Enrollment Dashboard offers academic and enrollment information for students enrolled in a selected term. You can review students’ academic information, performance indicators, assigned advisors, generate contact lists, review summarized enrollment demographics, or look at tuition and enrollment summaries and trends.

 Key Business Questions

  • How many students are currently enrolled in each plan/subplan offered by my school?

  • Who are these students? What are their demographics/grades/credits?

  • What students are assigned to a specific advisor?

  • What are the overall enrollment demographics of my school?

  • Can I have a contact list of first-time students enrolled in my school in the fall?

  • What is the full-time enrollment at my school, and what is the tuition credited?

  • FTE Headcount & Tuition

  • Course Enrollment Trends

  • Student Enrollment Trends

  • CGPA for Graduation Honors List

  • Promotions Report

  • Undergraduate Dean's List

ST Enrollment and Tuition

Decommissioning: early Spring Term 2025

Student Enrollment & Tuition Forecasts

Dashboard Quick Start | Data Source Details

Released: July 2023

 Description

The Student Enrollment and Tuition Forecasts and Actuals 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.

 Key Business Questions

  • How many students are enrolled in a particular term? What is the tuition amount?

  • What were the enrollment and tuition projections and what is the variance?

  • What is the enrollment/tuition for online programs?

  • What is the full-time enrollment at my school, and what is the tuition credited?

  • Enrollments, Tuition, Credits Compared to Forecast

  • Student Tuition Actual vs Budget

ST Enrollment and Tuition Budgeting

Decommissioning: early Spring Term 2025

Student Graduation

Dashboard Quick Start | Data Source Details

Released: September 2023

 Description

The Graduation Dashboard provides academic and degree information for students who graduated in a selected Fiscal Year/Academic Term. Use this dashboard to view the graduation numbers by degrees and academic plans or demographic metrics or generate a list of students with their respective graduation addresses. Users may also use this dashboard as a template to build or customize their own versions of the dashboards.

 Key Business Questions

  • How many students graduated in my School/Program/Plan in a selected Academic Term?

  • How many degrees were received by each Degree Type?

  • How many students graduated in a particular Academic Plan?

  • What is the average and median term GPA for an undergraduate degree?

  • How many years did it take a freshman cohort of students to graduate?

  • What are the graduation demographics of students associated with a specific program/plan?

  • Graduated Student Count

  • Graduation Trends by Demographics

  • New Alumni Mailing List

ST Graduation, ST Graduation Census

Decommissioning: early Spring Term 2025

Admissions

In Development Stage

  • First-year Matriculation List

  • Applications & Most Recent Status

  • Admissions Inspector

  • Tuition Deposit Validation

  • Report of Students with Prog Action DEIN

  • Transfer Enrollment Funnel

  • Current Applicants

  • Current Admits: Test Optional

  • Application by Admit Type

  • Applicant Test Results

ST Admissions

Decommissioning: 2-3 months after release

Class Enrollment & Grades

In Development Stage

  • Tutoring Grade Report

  • Course Completion Rates

  • Student Grade Trend

  • Class Grade Distributions (DFW)

  • Grade Rosters Not Approved

  • Course Repeats

ST Class Enrollment

Decommissioning: 2-3 months after release

Retention and Graduation

In Development Stage

  • First-year to Sophomore Retention Rate

  • 4-year Graduation Rate

  • 6-year Graduation Rate

ST Cohort (Persistence and Graduation)

Decommissioning: 2-3 months after release

FINANCIAL DATA & DASHBOARDS

Enterprise Dashboards & Data Sources

Description & Use Cases

Correlating Cognos Package(s)

Fiscal Panther: Entity 02, 03 Operating

Dashboard Quick Start | Data Source Details

Released: October 2022

 Description

Fiscal Panther: Operating is a tool for reviewing and managing operating (02/03 account) funding, spending, and projections. Encumbrances from the Operating Funds Forecasting or PantherExpress applications are also included.

 Key Business Questions

  • Does my department have an account that is over balance, or projected to be over balance?

  • What is the budget and actual spend on an account by Subcode?

  • What SPAR distributions are on an account?

  • What are the invoice, check, PO or Concur details of a transaction?

  • What transactions have hit an account, and which are projected to hit?

  • Which purchase orders have an encumbrance?

  • How does my spending this year compare to previous years?

  • Which employees' salaries come from the account I manage?

GL Aggregate Query Pkg

Decommissioning: xx

Fiscal Panther: Grants Administration

Dashboard Quick Start | Data Source Details

Released: June 2021

 Description

Fiscal Panther Grant Administration is a tool for reviewing and managing grant funding, spending, and projections for active grants. It pulls together data across PRISM, PBCS, and PERIS to provide account administrators a unified view of their budgets vs. actual spend and encumbrances at the RC, Department, and individual project level.

 Key Business Questions

  • What is the current remaining balance on a PI’s grant? What is the remaining balance after PBCS projections?

  • Does my department have any projects that are over balance, or projected to be over balance?

  • What is the budget and actual spend on a grant by Subcode?

  • What SPAR distributions are on a grant?

  • How many awarded and proposed grants does a department or PI have?

  • What is the actual and projected spend of all Subawards in a project?

  • What are the invoice, check, PO or Concur details of a transaction?

  • What transactions have hit a grant, and which are projected to hit?

  • Which purchase orders have an encumbrance?

GL Aggregate Query Pkg

Decommissioning: xx

Fiscal Panther: Grants by End Date

Dashboard Quick Start | Data Source Details

Released: March 2023

 Description

The Grants by End Date dashboard is for reviewing active project by the award end date, to quickly find projects that are past then end date or ending in the next 30, 60, 90 days and beyond. It pulls together data across PRISM, PBCS Grants Forecasting to provide account administrators a unified view of their budgets vs. actual spend and encumbrances at the individual project level by Department,

 Key Business Questions

  • What projects have past the award end date?

  • Does my department have any projects ending soon that are over balance, or projected to be over balance?

  • What projects are ending in the next 60 days?

  • What projects are over budget?

GL Aggregate Query Pkg

Decommissioning: TBA

Fiscal Panther: Purpose-Based (02/04/06/09)

Dashboard Quick Start | Data Source Details

Released: October 2022

 Description

Fiscal Panther Purpose-based is a tool for reviewing and managing 02/04/06/09 accounts with non-zero purpose codes. Spending, revenue, and projections can be tracked.

 Key Business Questions

  • What is the actual spend on an account by Subcode?

  • What SPAR distributions are on an account?

  • What are the invoice, check, PO or Concur details of a transaction?

  • What transactions have hit an account, and which are projected to hit?

  • Which purchase orders have an encumbrance?

  • How does my spending or revenue this year compare to previous years?

  • Which employees' salaries come from the account I manage?

GL Aggregate Query Pkg

Decommissioning: TBA

Fiscal Panther: Transaction Review

Dashboard Quick Start | Data Source Details

Released: August 2022

 Description

Fiscal Panther Transaction Review is a tool for reviewing and searching GL and PO transactions. All entities are included.

 Key Business Questions

  • What are the invoice, check, PO or Concur details of a transaction?

  • What transactions have hit an account, and which are projected to hit?

  • Which purchase orders have an encumbrance?

GL Transaction Query Pkg

Decommissioning: TBA

Fiscal Panther: Actual & Projected Labor

Dashboard Quick Start | Data Source Details

Released: March 2023

 Description

This dashboard contains four visualizations to provide visibility into historical labor
distribution expenses, current SPAR and TEAM data for salaried and bi-weekly employees, respectively, historical SPAR distributions and individual employee labor expenses and SPAR/TEAM information.

 Key Business Questions

  • Which employees' salaries come from the account I manage?

  • What SPAR/TEAM distributions are on an account?

  • What was the historical effort on my accounts?

  • Which compensation expenses are forecasted for my accounts?

  • How much overtime has been charged to my accounts?

PY Transaction Query Pkg

Decommissioning: TBA

Fiscal Panther: Purchase Order Review

Dashboard Quick Start | Data Source Details

Released: August 2023

 Description

Fiscal Panther Purchase Order Review is a tool for reviewing and searching purchase order transactions. The University’s purchasing system is PantherExpress. POs approved the day before are imported nightly into PRISM and then into the data warehouse for reporting.

 Key Business Questions

  • What are the invoice and check details for a PO transaction?

  • What PO transactions have hit an account, and which are projected to hit?

  • Which purchase orders have an open encumbrance?

Purchase Order Pkg

Decommissioning: TBA

error-message.png
* Note: After a Cognos Package is decommissioned, you will not be able to run a report that used the package as its data source. In this case, you should review the correlating Enterprise Dashboard and Data Source to ensure you are able to recreate report criteria.
  • No labels