...
Power BI reports have several features that can help you explore detailed information. Here are some of the features you can use:
...
...
Excerpt |
---|
|
Using the myBullsPath Report Filters |
Expand |
---|
title | Using the myBullsPath Report Filters |
---|
|
Use the report filters to drill down to specific populations or trends in the myBullsPath data. Tip |
---|
| 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: ![](https://usfjira.atlassian.net/wiki/download/thumbnails/11904060135/image2019-11-18_10-53-53.png?version=1&modificationDate=1574070833427&cacheVersion=1&api=v2&width=100) 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: |
|
...
...
...
myBullsPath Report Filters |
Expand |
---|
title | Using 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 |
---|
| 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) : - Show me Completion percentage by card and cohort sort and gender and ethnicity
- Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = No , cohort sort = 201908 - Fall 2019 by college
- Show me count of student UID , campus = USF Tampa , card = Attend Orientation , card status = Yes , cohort sort = 201908 - Fall 2019 sort by student UID
- Completion percentage by card and gender and ethnicity for cohort sort = 201908 - Fall 2019
- Count of Student uids by year(start date),month(start date) for cohort sort = fall 2019 as table
- Show me card, not_completed #, cohort sort = 201908 - Fall 2019 , sort by Not_Completed # as table
- Showmecountofstudent UID,campus=USF Tampa,cohort sort=201908 - Fall 2019bycollegeascolumn chart
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 - Completed # for card description = Submit Health Documents and start date > 10/31/19 and end date < 11/05/19
|
|
...
Excerpt |
---|
|
Using the myBullsPath Report Filters |
Expand |
---|
title | Reading 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 |
---|
| 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
|
|
|
|
Tip |
---|
|
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. |
...
Expand |
---|
|
Card 7: Apply for Housing Image Removed 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 shows as Completed. Calculations for this Card: - Students required to complete = Tampa students (required for Summer cohort; optional for Fall and Spring cohorts)
- Completed = Number of students completing Card
- Not Completed = Number of students not completing Card
- Completion % = Completed / Students required to complete
|
|
...
Expand |
---|
title | Select On-Campus Room |
---|
|
Card 9: Select On-Campus Room Image Removed Image Added
| Selecting an on-campus room is optional for all Tampa students. 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 |
---|
|
Card 10: Apply for Meal Plan Image Removed 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 |
---|
title | Register & Attend Classes |
---|
|
Card 12: Register to & Attend Classes ![](https://usfjira.atlassian.net/wiki/download/thumbnails/11904060135/image2019-11-5_10-35-33.png?version=1&modificationDate=1572946533641&cacheVersion=1&api=v2&height=149)
| Registering for classes is required for all students. Students register to attend classes, and once classes are accepted, the student's status changes to Completed. Calculations for this Card: - Students required to complete = All students
- Completed = Number of students completing Card / All students
- Not Completed = Number of students not completing / All students
- Completion % = Completed / All students
|
|
...
- 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 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 may be prompted to open the file, or you may see a link to the exported file (such as data.xlsx) at the bottom left of your display.
...