The myBullsPath Reports
Overview: myBullsPath
The myBullsPath Portal, supported by the USF Office of Orientation, provides newly admitted USF undergraduate students access to onboarding activities in an online graphical interface. Students can navigate through the various pre-registration tasks, which are called "Cards," to complete their individual requirements. These Cards include activities such as applying for housing, submitting transcripts and medical history, paying admissions deposit, and attending orientation.
The two myBullsPath reports, for orientation staff and USF student services providers, pull data from the student Card activity to provide a snapshot of students' progress in completing the onboarding tasks. The two reports displaying the following:
- Card Summary report: composed of a dashboard summarizing each of the Card statuses and a table presenting details on each admitted student's progress
- Card Details report: composed of a table that drills down into the separate requirements for the Health, Pre-Orientation Advising, and Student Visa Cards. These three Cards have multiple requirements that must be satisfied before the Card can be considered complete, thus this report displays all requirements and the students' progress in meeting them.
Using this report, staff can view metrics relating to student progression in meeting the onboarding requirements. For example, staff can:
- Drill down to view select student populations, such as a student type (e.g., transfer, FTIC) or gender.
- Select the status of a particular Card, such as Submit Health Documents or Apply For Housing.
- View the progress made on individual requirements for particular Cards.
- Reach out to students currently in the pipeline to provide individual assistance on completing tasks.
- Track the overall onboarding process for efficiencies, and create targeted campaigns to improve the business process.
For a Quick Reference Guide with helpful tips on using the Power BI myBullsPath Report, click here >> My Bulls Path QRG.pdf
Power BI reports have several features that can help you explore detailed information:
Data Refresh
To provide the most current data for all users, the reports are refreshed four times daily:
- Data tables refresh at 8:00 am, 1:00 pm and 5:00 pm. The Data Refreshed On value in the bottom right of your view displays the most recent database refresh.
- The reports refresh at 7:30 am, 11:00 am and 4:00 pm. The exact day and time displays in the report Header when you click "Data updated mm/dd/yy ".
The report refresh typically takes around 10 minutes.
Read below for information on working with the Card Summary and Card Details reports, or click on the Report Elements Glossary link in the Table of Contents above to view definitions for the report filters and display elements.
Report: Card Summary Report |
---|
The Card Summary report showcases the metrics related to newly admitted students in meeting their onboarding requirements. The report presents the data in two tabs: The Card Summary tab displays an interactive dashboard with a series of tiles representing the individual Cards of the myBullsPath Portal. The Student Details tab displays a list of the newly admitted students with their completion statuses for each Card as well as demographics, such as campus/college, email, and major.
Using this report:
- Orientation staff can view Card statuses, completion percentages, and average completion times. Staff can drill down to individual Cards to spot efficiencies or hurdles in completing tasks and provide onboarding assistance.
- Staff at USF Student Services Providers can select the Card(s) pertaining to their specific onboarding requirements and view the completion percentages and statuses. In addition, staff can view details for the students to include student name, email address. and department/major to reach out and provide direction.
Note that when you select one or more filters in the report, the filters apply to both the Card Summary statistics and the Student Details display.
Tab 1: Card Summary |
---|
The Card Summary tab displays the individual onboarding Cards in a series of tiles. The tiles display information on two sides:
Side ONE provides Card completion calculations:
- "REQUIRED" in Card title: If the Card is required by at least a portion of the admitted student population, the tile shows "REQUIRED" in the title.
- Required # (if Required)
- Completed # (if Required) or Submitted # (if not Required)
- Not Completed # (if Required) OR Not Submitted (if not Required)
- Completion % (if Required) OR Submitted % (if not Required)
Note that if a Card is not required, the percentages are based on those eligible to submit rather than required to complete:
- Required % = # students with Card Status = Y / # students required to complete Card
- Submitted % = # students with Card Status = Y / # students eligible to complete Card
Side TWO provides statistics on the completion times for students:
- Average, maximum, and minimum days to complete the cards (calendar days)
If you click on a Card, the workspace expands it to display the required or submitted calculations and expands on the card descriptions to detail what students are included in the counts, such as international students, all admitted FTIC, or all students. To close the expanded display, click the Close icon located in the upper right hand corner.
Details of the required student population and completion calculations for each Card are shown below; select the Card title for details on the particular onboarding task:
Filters
The myBullsPath Reports#Campus
The myBullsPath Reports#College
The myBullsPath Reports#Department
The myBullsPath Reports#Cohort
The myBullsPath Reports#Orientation Session
The myBullsPath Reports#Gender
The myBullsPath Reports#Ethnicity
The myBullsPath Reports#Citizenship
The myBullsPath Reports#Special Population
Report Visualizations
This report displays individual tiles representing the Card statuses for onboarding activities.
Tab 2: Student Details |
---|
The Student Details tab displays a table listing all incoming students and their statuses on completing each of the myBullsPath Cards. The table is sorted by Student UID, but you can sort in any column by clicking the column heading.
The table display retains the filters selected in the Card Summary tab. For example, if you select Campus = "USF Tampa" and College = "Education" in the Card Summary tab, the Student Details table lists the students in the College of Education at the Tampa campus. You can select from five additional filters on this tab: Card Description, Card Status, Completion Date, UID, and Student Name. For example, in addition to the College of Education at the USF Tampa campus, you can select "N" in the Card Status filter and "Attend Orientation" in the Card Description filter to list Education students in Tampa who have NOT attended orientation.
Notes:
- You can select a specific set of dates using the Completion Date selection (called a Slider). Adjust the dates by either sliding the end points or by entering specific dates in the start and end fields.
- You can select All Cards under the Card Description filter, and in each, you can select Yes or No to narrow the filter to select students, for example, what students have completed a specific Card while not completing another.
- For the Health, Pre-Orientation Advising, and Student Visa Cards, each student has a link symbol in the Link column. You can click the symbol to open a separate Card Details report for that student, which breaks down these Card requirements into their individual components. Refer to the Card Details Report below.
To export the contents of the table to Excel for additional analysis and sorting:
- Hover over the table, then click the ellipses in the top right corner of the table (note that you may have to click in the table first to see the ellipses option for the table).
- Select Export data.
- Click the Export button in the Export data dialog box.
Note: Depending on your browser and your settings, you either are prompted to open the file, or you see a link to the exported file (such as data.xlsx) at the bottom left of your display.
Filters
The myBullsPath Reports#Campus
The myBullsPath Reports#College
The myBullsPath Reports#Department
The myBullsPath Reports#Cohort
The myBullsPath Reports#Card Description
The myBullsPath Reports#Card Status
The myBullsPath Reports#Completion Date
The myBullsPath Reports#Orientation Session
The myBullsPath Reports#Student Name
The myBullsPath Reports#Gender
The myBullsPath Reports#Student Type
The myBullsPath Reports#Residency
The myBullsPath Reports#Ethnicity
The myBullsPath Reports#Citizenship
The myBullsPath Reports#Special Population
Report Visualizations
The myBullsPath Reports#Distinct Student Count
The myBullsPath Reports#Student Name
The myBullsPath Reports#Card Description
The myBullsPath Reports#Card Status
The myBullsPath Reports#Campus
The myBullsPath Reports#College
The myBullsPath Reports#Department
Report: Card Details Report |
---|
The Card Details report presents a table listing the incoming students who are required to complete or submit one of the following Cards:
- Attend Orientation
- Pre-Orientation Advising
- Health Documents
- Student Visa
These four requirements are composed of two or more independent activities, or in the case of Attend Orientation, provides additional details. The Card Details report shows the student's status of each activity for the Card separately. If none of the activities for the Card are completed, this report does not display a record for the student. If the student has completed at least one of the activities for the Card, the report shows a record for that student with his or her completion status of the underlying activities. These individual components of the Cards are shown here:
Attend Orientation Card:
Students display in the Card Details report to show their status on their orientation session. The table displays the student, their status for attending orientation, such as Attended, Reserved, or Completed Online, and the specific session they attended/will attend.
Pre-Orientation Advising Card:
Students display in the Card Details report when they have completed the Attended Pre-Orientation Card. The student is recorded in the database with either Code A (attended Pre-Orientation) or Code T (attended both Pre-Orientation and Orientation). You can filter the report by code to show students who have attended both orientations or Pre-Orientation only.
Health Documents Card:
Students display in the Card Details report if they have completed one of the following requirements, even though they have not completed the Card itself (by satisfying all requirements). The individual requirements are:
- Submit documents on immunizations
- Submit documents on medical history
- Submit proof of medical insurance (required of international students only)
Student Visa Card:
Students display in the Card Details report if they have completed one of the individual requirements, even though they have not completed the Card itself (by satisfying all that is required of them). Requirements for the Student Visa Card are many and vary by each student, so the individual requirements won't be listed here. See the report for details.
Users can access the Card Details report in one of two ways:
- Directly in Power BI by selecting myBullsPath - Card Details.
- Clicking the link icon (shown here) in the Student Details tab of the Card Summary report.
After clicking one of the links shown above, Power BI opens the Card Details report in a new window. When accessing this report from the Card Summary, it displays only the details for that student and that Card. You cannot expand the report to show other students or other Cards.
Report Elements Glossary
The table below lists all of the elements used in the report.
Element | Source (System->Table->Column) | Description |
---|---|---|
Campus | MBP_Report_Master > Campus_Title | Identifies the campus of the student. |
Card Description | MBP_Report_Master > Card_Description | The title of the orientation or onboarding Card or task as identified in the MyBullsPath Portal. The onboarding task can be either required or optional prior to registration and can vary by student population. For example, all students are required to submit transcripts, but not all will need housing assignments or meal plans, and only international students schedule pre-orientation advising meetings. The following Cards are shown in this report:
|
Card Status | MBP_Report_Master > Card_Status | A flag (Y, N) that indicates the completion status for an orientation Card. |
Citizenship | MBP_Report_Master > Citizenship_Title | Indicates whether the student is a US citizen for the purpose of determining the requirement for international students. |
Cohort | MBP_Report_Master > Term_Title | Identifies the cohort or term to which the student is assigned at acceptance. |
College | MBP_Report_Master > College_Title | Identifies the college of the student. |
Completed # | Calculated | Sum of the students with Card Status = Y for those students that are required to complete the Card. |
Completion % | Calculated | Calculated as the number of students with Card Status = Y divided by the number of students required to complete the Card. |
Completion Date | A field used to narrow the student completion dates to a range. Completion dates that fall outside of the window expressed in this filter do not appear on the report. This field is used only in the Student Details tab of the report. | |
Department | MBP_Report_Master > Department_Title | Identifies the student's college department. |
Distinct Student Count | Calculated | Indicates the number of students listed in the report (table) based on the filters selected. Students appear more than once when multiple Cards are displayed. |
MBP_Report_Master > EMAIL | The email address of the student. | |
Gender | MBP_Report_Master > Gender_Title | Identifies the gender of the student as Male or Female. |
Ethnicity | MBP_Report_Master > Ethnicity_Title | Identifies the ethnicity of the student, such as Hispanic, White Non-Hispanic, Asian/Pacific Islander, or Black Non-Hispanic. |
Link to Card Details | Link | A link icon displays in this column of the table for the following Cards:
When clicked, a separate report displays (Card Details), which provides a breakdown of the individual components that make up the Card. |
Major | MBP_Report_Master > Major_Title | The student's major. |
Not_Completed # | Calculated | Sum of the students with Card Status = N for those students that are required to complete the Card. |
Not_Submitted # | Calculated | Sum of the students with Card Status = N for those students who are able to (but not required to) submit the information to complete the Card. |
Orientation Session | A filter displaying the list of orientation sessions available for students to attend prior to attendance. | |
Required # | Calculated | Calculated as the number of students that are required to complete the Card. |
Residency | MBP_Report_Master > Residency_Title | Indicates where the student lives when not attending school: Florida resident, non-Florida resident, or non-USA resident. For existing FL resident/ pending FL resident, confirmation is not stored in Archivum, but status in application in Banner is used. |
Special Population | [MBP_Attributes] > Uid [MBP_Attributes]>Termid [MBP_Attributes] >Attribute_code | Indicates that the student has a special status, such as Athlete, Active Duty, International Student, INTO Program, STEM, or Veteran/Veteran Dependent. |
Student Name | MBP_Report_Master > FIRST_NAME MBP_Report_Master > LAST_NAME | First Name joined with Last Name. Note that you have an option on this filter to clear previous selections by hovering over the filter heading and selecting the Clear Selections icon. |
Student Type | MBP_Report_Master > StudentType_Title | The type of incoming student, used in determining onboarding requirements. The options are:
|
Student UID | MBP_Report_Master > UID | The unique University Identification number of the student. Note that you have an option on this filter to clear previous selections by hovering over the filter heading and selecting the Clear Selections icon. |
Submitted # | Calculated | Sum of the students with Card Status = Y for those students who are able (but not required) to submit the information to complete the Card. |
Submitted % | Calculated | Calculated as the number of students with Card Status = Y divided by the number of students who are eligible to submit the information to complete the Card. |
Time In Progress (Days) | Calculated | Calculated as the number of calendar days since the Card became interactive in the Portal for the student to complete the task. |
Time To Completion (Days) | Calculated | Calculated as the number of calendar days it took a student to complete the Card. Note that:
|