Versions Compared

Key

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

Include Page
_DraftNote
_DraftNote

...

Expand
titleUsing the Ask a Question Feature


Power BI has an Ask a Question Feature that allows you to ask a question of the report data using your own words. The feature lets you explore your data using multiple presentations.

Tip
titleHelpful Hints

The results are interactive and typically displays suggestions as you type the question.

The basic formatting of the question is (Show me) count or percentage of element by element for element as display.

The filters already selected in the report are applied to the results of the questionAny filters you have selected in the report are applied to the results, e.g., if you have filtered for the College of Engineering, only Engineering students display in the results.

You can add elements to an existing question, e.g., you can add "by gender" at the end of the question "Count of student UID , campus = USF Tampa, Card = Attend Orientation, Card Status = No" and the display updates automatically.

You can select an existing question and modify the options; the Q&A displays suggestions as you type.You can choose different ways to display the data. Some of the typical ways to display are "as table," "as matrix" or "as bar chart."

Refer to Power Bi Tips and tricks for help in phrasing your own questions: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-q-and-a-tips


Here are some examples of questions you can ask (try to copy/paste these into the field) :

  1. Show me Completion percentage by card and cohort sort and gender and ethnicity
  2. Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = No , cohort sort = 201908 - Fall 2019 by college
  3. Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = Yes , cohort sort = 201908 - Fall 2019 sort by student UID
  4. Completion percentage by card and gender and ethnicity for cohort sort = 201908 - Fall 2019
  5. Count of Student uids by year(start date),month(start date) for cohort sort = fall 2019 as table
  6. Show me card, not_completed #, cohort sort = 201908 - Fall 2019 , sort by Not_Completed # as table
  7. Showmecountofstudent UID,campus=USF Tampa,cohort sort=201908 - Fall 2019bycollegeascolumn chart
  8. Show me student UID for who has card status = Yes for card description = Submit Health Documents and start date > 10/31/19 and end date < 11/05/19 sort by student UID

  9. Completed # for card description = Submit Health Documents and start date > 10/31/19 and end date < 11/05/19


...

tip
Expand
titleUsing the myBullsPath Report Filters


Use the report filters to drill down to specific populations or trends in the myBullsPath data.

Tip
titleHelpful Hints

Filters are listed on both the top and left side of the report.

  • The top filters pertain to the university settingsclassifications, such as campus or department.
  • The side filters pertain to student demographics, such as residency and student type.
  • The Student Details tab of the report has two additional filters on the top: Card Description & Card Status.
To select
  • , and two on the side: UID & Student Name.

To select more than one option in a filter, hold the Ctrl key as you click each item.

The filters you select on one tab of the report are retained when you move to the other tab of the report.

Select "Reset to Default" for an easy way to remove all filters:

Once an item in ONE filter is selected, the selections in other filters may change. For example, if you select College = Business, then Department shows only the departments in the College of Business.


Here are some examples using filters in the myBullsPath report:

May not include




Expand

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 time to complete the cards in calendar days

If you click on a Card, the workspace expands the Card to display both sets of calculations.

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:

Submitting Health Documents is required for all students.

All students are required to submit medical history and immunization records; international students must also submit proof of medical insurance. Once all documents are received, the student's status shows as
Expand
titleContact Information

Card 1: Contact Information

Image Removed

The Contact Information Card is required for all students.

Students must submit at least three contacts in myBullsPath to have this Card completed: emergency contact, local mailing address, and permanent mailing address.

Calculations for this Card are:

  • Students required to complete = All students
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete
Expand
titleFAFSA Submission

Card 2: FAFSA Submission

Image Removed

FAFSA submission is optional for domestic students. International students are not included in this population since they are not eligible for financial aid.

Students indicate in the Portal if they have submitted the FAFSA to be considered for financial aid. Student names do not display for FAFSA completion on the Student Details tab; instead, the Card Summary displays the number of students submitted and the days-to-complete calculations.

Calculations for this Card are:

  • Students eligible to complete = All students except those whose Citizenship is Foreign National (does not display on Card)
  • Submitted = Number of students optionally completing Card (of those eligible)
  • Not Submitted = Number of students not completing Card (of those eligible)
  • Submitted % = Submitted / Students eligible to complete
Expand
titlePay Admissions Deposit

Card 3: Pay Admissions Deposit

Image Removed

The Pay Admissions Deposit Card is required for all FTIC students.

All FTIC students are required to pay the admissions deposit. When the full deposit is recorded, the Card updates to Completed.

Calculations for this Card:

  • Students required to complete = Students whose Student Type is FTIC
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete
Expand
titleSubmit Health Documents

Card 4: Submit Health Documents

Image Removed

titleData Refresh

To provide the most current data for all users, the reports are refreshed four times daily:

  • Data tables refresh at 8:00 am, 12:00 pm, 2:30 pm, and 1:30 am. The Data Refreshed On value in the bottom left of your view displays the most recent database refresh.
  • The reports refresh at 9:00 am, 1:00 pm, 3:30 pm, and 2:30 am. The exact day and time displays in the report Header when you click "Data updated mm/dd/yyImage Removed".

The report refresh typically takes around 10 minutes.

Read below for information on working with the report, or click on the Report Elements Glossary link in the Table of Contents to view definitions for the report filters and elements. 

...

Report : Card Summary Report

Reading Days elapsed fields in the Student Details tab


The myBullsPath report has two fields calculating Days elapsed on the Student Details tab: Time to Completion (Days) and Time In Progress (Days).

Tip
titleHelpful Hints

Days are measured as calendar days.

For both calculations, the report uses a student's Start Date, which is the later of:

  • The student's Admit Date
  • The date the Card became interactive in the Portal

Time In Progress (Days) increments each day from the student's Start Date until the student completes the Card.

Time To Completion (Days) calculates the number of calendar days that have elapsed from the student's Start Date to when the student completed the Card. These numbers will vary from student to student, depending on when they were admitted to USF.

A student's Time To Completion is:

  • Zero (0) if completed before the Start Date
  • One (1) if completed the day of the Start Date


Here are some examples using the dates in the myBullsPath report:

May not include





Tip
titleData Refresh

To provide the most current data for all users, the reports are refreshed four times daily:

  • Data tables refresh at 8:00 am, 12:00 pm, 2:30 pm, and 1:30 am. The Data Refreshed On value in the bottom left of your view displays the most recent database refresh.
  • The reports refresh at 9:00 am, 1:00 pm, 3:30 pm, and 2:30 am. The exact day and time displays in the report Header when you click "Data updated mm/dd/yyImage Added".

The report refresh typically takes around 10 minutes.


...

Read below for information on working with the report, or click on the Report Elements Glossary link in the Table of Contents to view definitions for the report filters and 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 time to complete the cards in calendar days

If you click on a Card, the workspace expands the Card to display both sets of calculations.


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:


Expand
titleContact Information


Card 1: Contact Information

Image Added

The Contact Information Card is required for all students.

Students must submit at least three contacts in myBullsPath to have this Card completed: emergency contact, local mailing address, and permanent mailing address.

Calculations for this Card are:

  • Students required to complete = All students
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete



Expand
titleFAFSA Submission


Card 2: FAFSA Submission

Image Added

FAFSA submission is optional for domestic students. International students are not included in this population since they are not eligible for financial aid.

Students indicate in the Portal if they have submitted the FAFSA to be considered for financial aid. Student names do not display for FAFSA completion on the Student Details tab; instead, the Card Summary displays the number of students submitted and the days-to-complete calculations.

Calculations for this Card are:

  • Students eligible to complete = All students except those whose Citizenship is Foreign National (does not display on Card)
  • Submitted = Number of students optionally completing Card (of those eligible)
  • Not Submitted = Number of students not completing Card (of those eligible)
  • Submitted % = Submitted / Students eligible to complete



Expand
titlePay Admissions Deposit


Card 3: Pay Admissions Deposit

Image Added

The Pay Admissions Deposit Card is required for all FTIC students.

All FTIC students are required to pay the admissions deposit. When the full deposit is recorded, the Card updates to Completed.

Calculations for this Card:

  • Students required to complete = All studentsStudents whose Student Type is FTIC
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete



Expand
titleStudent Visa RequirementsSubmit Health Documents


Card

5: Student Visa Requirements

Image Removed

The Student Visa Requirements Card

4: Submit Health Documents

Image Added

Submitting Health Documents is required for

International

all students

only

.

Students

All students are required to

provide documents for the visa requirements. Once documents are validated

submit medical history and immunization records; international students must also submit proof of medical insurance. Once all documents are received, the student's status shows as Completed.

Calculations for this Card:

  • Students required to complete =
Students whose Citizenship is Foreign National
  • All students
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete



Expand
titleTranscripts, Test Scores, Exam CreditsStudent Visa Requirements


Card

6: Transcripts, Test Scores, Exam Credits

Image Removed

Submitting transcripts, test scores, and exam credits

5: Student Visa Requirements

Image Added

The Student Visa Requirements Card is required for

all

International students only.

Students

send all required test scores, exam credits, and transcripts. Once the

are required to provide documents for the visa requirements. Once documents are validated, the student's status shows as Completed.

Calculations for this Card:

  • Students required to complete =
All students
  • Students whose Citizenship is Foreign National
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete



Expand
titleApply for HousingTranscripts, Test Scores, Exam Credits


Card

7: Apply for Housing

Image Removed

Applying for Housing is required for Tampa Summer term students and optional for Tampa Fall and Spring term students.

Students submit a housing application. Once the application is on file

6: Transcripts, Test Scores, Exam Credits

Image Added

Submitting transcripts, test scores, and exam credits is required for all students.

Students send all required test scores, exam credits, and transcripts. Once the documents are validated, the student's status shows as Completed.

Calculations for this Card:

  • Students required to complete =
Tampa students (required for Summer cohort; optional for Fall and Spring cohorts)
  • All students
  • Completed = Number of students completing Card
  • Not Completed = Number of students not completing Card
  • Completion % = Completed / Students required to complete



Expand
titleAttend OrientationApply for Housing


Card

8: Attend Orientation

Image Removed

Attending orientation is required for FTIC and transfer students.

Students sign up for and attend one of the on-campus orientation sessions. Once the orientation session is complete

7: Apply for Housing

Image Added

Applying for Housing is required for Tampa Summer term students and optional for Tampa Fall and Spring term students.

Students submit a housing application. Once the application is on file, the student's status

changes to

shows as Completed.

Calculations for this Card:

  • Students required to complete =
Students whose Student Type is FTIC or Transfer
  • Tampa students (required for Summer cohort; optional for Fall and Spring cohorts)
  • Completed = Number of students completing Card
/ Number of students required
  • Not Completed = Number of students not completing
/ Number of students required
  • Card
  • Completion % = Completed /
Number of students
  • Students required to complete



Expand
titleSelect On-Campus RoomAttend Orientation


Card

9: Select On-Campus Room

Image Removed

Selecting an on-campus room is optional for all Tampa

8: Attend Orientation

Image Added

Attending orientation is required for FTIC and transfer students.

Students

complete X before being eligible for their housing assignment.

sign up for and attend one of the on-campus orientation sessions. Once the orientation session is complete, the student's status changes to Completed.

Calculations for this Card:

  • Students required to complete =
Selection is optional for all Tampa students, and all Tampa students are eligible
  • Students whose Student Type is FTIC or Transfer
  • Completed = Number of students completing Card / Number of students
eligible
  • required
  • Not Completed = Number of students not completing / Number of students
eligible
  • required
  • Completion % = Completed / Number of students
eligible
  • required



Expand
titleApply for Meal PlanSelect On-Campus Room


Card

10: Apply for Meal Plan

Image Removed

Applying for a meal plan on campus

9: Select On-Campus Room

Image Added

Selecting an on-campus room is optional for all Tampa students.

Coding IP / Notes here

Students complete X before being eligible for their housing assignment.

Calculations for this Card:

  • Students required to complete = Selection is optional for all Tampa students, and all Tampa students are eligible
  • Completed = Number of students completing Card / Number of students eligible
  • Not Completed = Number of students not completing / Number of students eligible
  • Completion % = Completed / Number of students eligible



Expand
titlePre-Orientation AdvisingApply for Meal Plan


Card

11: Pre-Orientation Advising

Image Removed

The Pre-Orientation Advising Card is required for Tampa Transfer students and optional for

10: Apply for Meal Plan

Image Added

Applying for a meal plan on campus is optional for all students.

Coding IP / Notes here

Calculations for this Card:

  • Students required to complete =
  • Completed = Number of students completing Card /
  • Not Completed = Number of students not completing /
  • Completion % = Completed /



Expand
titlePre-Orientation Advising


Card 11: Pre-Orientation Advising

Image Added

The Pre-Orientation Advising Card is required for Tampa Transfer students and optional for Sarasota and St. Pete Transfer students.

Students sign up for and attend a pre-orientation advising session. Once the advising session is complete, the student's status changes to Completed.

Calculations for this Card:

  • Students required to complete = Number of students whose Student Type is Transfer (J, U)
  • Completed = Number of students completing Card / Number of students required
  • Not Completed = Number of students not completing / Number of students required
  • Completion % = Completed / Number of students required


...

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 by any column by clicking on 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 Details table lists the students in the College of Education at the Tampa campus. 

In the Student Details tab, you can select from four additional filters: Card Description, Card Status, 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.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 by any column by clicking on 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 Details table lists the students in the College of Education at the Tampa campus. You can select from four additional filters on this tab: Card Description, Card Status, 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.

You can export the contents of the table to Excel for additional analysis and sorting:

  1. 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 be able to click on the ellipses option for the table).
  2. Select Export data.
  3. Click the Export button in the Export data dialog box.
  4. Click Open in the dialog box to work with the spreadsheet.
    Note: Depending on your browser and your settings, your system may open the spreadsheet automatically or may show the downloaded file at the bottom left of your display. 


Filters 

The myBullsPath Report

...