Versions Compared

Old Version 109

changes.mady.by.user Lise Venning

Saved on

compared with

New Version 110

changes.mady.by.user Lise Venning

Saved on

Key

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

Include Page
_DraftNote
_DraftNote

...

Power BI reports have several features that can help you explore detailed information. Here are some of the features you can use: 

...



true
true

Using the myBullsPath Report Filters

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 classifications, 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 four additional filters – two on the top: Card Description & Card Status, 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:

Excerpt
hidden





Using the Ask a Question Feature

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.

Any 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 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. Show me count of student   UID , campus = USF   Tampa , cohort   sort = 201908   -   Fall   2019 by college as column   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
Excerpt
hiddentrue
Reading Days Elapsed Fields in the Student Details Table
  1. 11/05/19



Expand
titleReading Days Elapsed Fields in the Student Details Table


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




...

Element

Source

(System->Table->Column)

DescriptionFrequency of Report Refresh (Data tables refresh 1 hour prior)

Anchor
Campus
Campus
Campus

MBP_Report_Master > Campus_TitleIdentifies the campus of the student.

9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Card Description
Card Description
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:

  • Apply for Housing
  • Apply for Meal Plan
  • Attend Orientation
  • Complete Student Visa Requirements
  • Confirm Your Residency Status
  • Pay Admissions Deposit
  • Register & Attend Classes
  • Review Financial Aid and Scholarships
  • Schedule Pre-Orientation Advising
  • Select On-Campus Room
  • Submit Required Health Documents
  • Submit FAFSA
  • Submit Transcripts, Test Scores, Exam Credits
  • Use VA Education Benefits & Military Tuition Assistance
  • View Contact Information
  • View Tuition & Fees
 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Card Status
Card Status
Card Status

MBP_Report_Master > Card_StatusA flag (Y, N) that indicates the completion status for an orientation Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Citizenship
Citizenship
Citizenship

MBP_Report_Master > Citizenship_TitleIndicates whether the student is a US citizen for the purpose of determining the requirement for international students.9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Cohort
Cohort
Cohort

MBP_Report_Master > Term_TitleIdentifies the cohort or term to which the student is assigned at acceptance. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
College
College
College

MBP_Report_Master > College_TitleIdentifies the college of the student. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Completed #
Completed #
Completed #

CalculatedSum of the students with Card Status = Y for those students that are required to complete the Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Completion %
Completion %
Completion %

CalculatedCalculated as the number of students with Card Status = Y divided by the number of students required to complete the Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Department
Department
Department

MBP_Report_Master > Department_TitleIdentifies the student's college department. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Distinct Student Count
Distinct Student Count
Distinct Student Count

CalculatedIndicates the number of students listed in the report (table) based on the filters selected. Students appear more than once when multiple Cards are displayed.9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Email
Email
Email

MBP_Report_Master > EMAILThe email address of the student. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Gender
Gender
Gender

MBP_Report_Master > Gender_TitleIdentifies the gender of the student as Male or Female.9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Ethnicity
Ethnicity
Ethnicity

MBP_Report_Master > Ethnicity_TitleIdentifies the ethnicity of the student, such as Hispanic, White Non-Hispanic, Asian/Pacific Islander, or Black Non-Hispanic.9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Major
Major
Major

MBP_Report_Master > Major_TitleThe student's major. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Not Completed #
Not Completed #
Not_Completed #

CalculatedSum of the students with Card Status = N for those students that are required to complete the Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Not Submitted #
Not Submitted #
Not_Submitted #

CalculatedSum 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. 9:00 am
12:00 pm
3:30 pm
2:30 am
Required #CalculatedCalculated as the number of students that are required to complete the Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Residency
Residency
Residency

MBP_Report_Master > Residency_TitleIndicates where the student lives when not attending school: Florida resident, non-Florida resident, or non-USA resident. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Special Population
Special Population
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.

9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Student Name
Student Name
Student Name

MBP_Report_Master > FIRST_NAME

MBP_Report_Master > LAST_NAME

First Name joined with Last Name. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Student Type
Student Type
Student Type

MBP_Report_Master > StudentType_Title

The type of incoming student, used in determining onboarding requirements. The options are:

  • 1 - First Time in College (FTIC)
  • 2 - Transfer
  • 3 - Former Student Returning (FSR)
9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Student UID
Student UID
Student UID

MBP_Report_Master > UIDThe unique University Identification number of the student. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Submitted #
Submitted #
Submitted #

CalculatedSum of the students with Card Status = Y for those students who are able (but not required) to submit the information to complete the Card. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Submitted %
Submitted %
Submitted %

CalculatedCalculated 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. 9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Time In Progress
Time In Progress
Time In Progress (Days)

CalculatedCalculated as the number of calendar days since the Card became available in the Portal for the student to complete the task.9:00 am
12:00 pm
3:30 pm
2:30 am

Anchor
Time to Completion
Time to Completion
Time To Completion (Days)

Calculated

Calculated as the number of calendar days it has taken took a student to complete the Card. Note that:

  • If student completes a task prior to the Card being available in the myBullsPath Portal, this field displays a zero (0). This time is not included in the Time-to-Completion metrics in the Card Summary.
  • If a student completes a task on a date that equals the student's Start Date, which is the later of his or her Admit Date or the date the Card became available in the Portal, this field displays a one (1). This time is included in the Time-to-Completion metrics in the Card Summary.
  • If a student completes a task using the Card in the Portal, the number displays as the number of calendar days it took to complete the task since the Card became available.
9:00 am
12:00 pm
3:30 pm
2:30 am

...