Description
Active Student Basic dashboard is a “Basic” dashboard, meaning it’s a starter dashboard that answers most popular questions about active students, and it can be used as a starting point to create other reports by using Tableau’s Web Edit.Active Student Basic dashboard is about active students. Students need to be active (students are de-activated after 3 terms of inactivity), and may not necessarily be currently enrolled. Active Student data has no history; it’s the current data about active students.
The dashboard has active students summary data, such as student contact and demographic info, student academic info, last enrolled summary info and performance indicators, advisors, enrollment status in current and two next terms (indicators only), milestones, transferred credits, appointment info, etc. The dashboard does not have enrollment details, nor has historical enrollment data, or class enrollment data.
Basic Usage
Active Schedule Basic dashboard has three separate dashboards/tabs
Active Student with Advisor
This dashboard provides a list of active students with academic and enrollment information, advisors, and performance indicators, admit and expected graduation terms. There may be more than one record per student, as some students are enrolled in multiple programs/plans.
Sample questions answered by this dashboard:
I need a list of students in our program(s)/plan(s)/subplan(s), and be able to see their performance indicators
For outreach, I need a list of students who are not enrolled
I need a list of students assigned to a specific advisor
What is the advisor load in my school?
How many students are enrolled in a Plan of interest?
How many students pursuing a specific degree, say BS in Nursing?
Analysis of a program/plan enrollment including gender, ethnicity, and citizenship
Users can limit the data by using the drop-down filters: campus, program, advisor, etc., or by clicking on a blue bar in a visualization.
“Students per Program/Plan” and “Advisor Load” visualizations can expand to show summaries by Academic Plan and Academic Subplan, in addition to Academic Program. To do that, you’ll need click on a “+” sign which appears when you point your cursor over Academic Program words. In a similar manner, click on a “-” sign to remove Academic Plan/Academic Subplan from the visualization:
We strongly recommend applying at least one of the filters to optimize performance. You can reset the filters by clicking on a Revert button:
The “Number of Students” display counts each student only once, even though you’ll see some students having multiple lines in the data table, as a student may be active in different Programs/Plans.
Active Student Mailing List
This dashboard provides a list of active students, with their contact information, address data, and gender, ethnicity and first generation description. It will list each student once, even if a student is enrolled in multiple programs/plans. It can be used for mailing purposes, or for getting a list of students for different parameters.
Service Indicators
This dashboard shows students with service indicators. The dashboard is defaulted to Service Indicators that block enrollment. You can change the values in the drop-down Service Indicator filter to a different set of service indicators, per your needs.
Sample questions answered by this dashboard:
I need a list of students with service indicators on, who are not able to enroll because of them
I need a list of students in my Program(s) who are on an Academic Hold
The “Number of Students” display counts each student only once, even though you’ll see some students having multiple lines in the data table, as a student may have multiple active Service Indicators (like seen in the screenshot above).
What is the source of this information?
Active Student Basic Dashboard is using the Tableau Active Student data source. This data source is a close replica of an existing Cognos “St Active Student Query” package and is built from the student data mart (UD_DATA). Student data mart, in turn, pulls data from PeopleSoft and is a day behind: the data available today in data mart and Active Student data source is yesterday’s PeopleSoft data. New data entered in PeopleSoft today will be in student mart and Active Student data source and dashboard tomorrow.
How do I get access?
Anyone with access to Student Mart (ST) will have access to the Active Student Basic Dashboard. Users will only see their RC, unless otherwise approved on their Federated Authorization form. To request access to the Student Mart, please fill out Student Mart Federated Authorization form.
Special permission is required to see restricted fields: performance indicators, student demographics, student identifiers. To request access to the restricted fields, make sure you check the box for restricted data access and select what restricted data is needed:
