Versions Compared

Old Version 96

changes.mady.by.user Lise Venning

Saved on

compared with

New Version 97

changes.mady.by.user Lise Venning

Saved on

Key

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

Include Page
_DraftNote
_DraftNote

...

Expand
titleUsing the Ask a Question Feature


To provide the most current data for all users

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 as you type the question.

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."


Here are some examples of questions you can ask:

  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
Tip
titleData Refresh

  1. 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

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




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/yy".

The report refresh typically takes around 10 minutes.

...

Report Visualizations

The myBullsPath Report

UID

The myBullsPath Report

Student Email

The myBullsPath Report

The myBullsPath Report

The myBullsPath Report

The myBullsPath Report

Campus Title

College Title

Department Title

Major TitleThe myBullsPath Report

The myBullsPath Report

Time To Completion (Days)

Time In Progress (Days)



...


Anchor
Report Elements Glossary
Report Elements Glossary
Report Elements Glossary

...

takes Card since it became available.If a student has not completed the task, the number increments for each day since it became available in the Portal
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 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 days it

has taken 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 the task using the Card in the Portal, the number displays as the number of days it took to complete the
  • task since the Card became available.
9:00 am
12:00 pm
3:30 pm
2:30 am