...
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:  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 |
|---|
|
Using the myBullsPath Report FiltersAsk a Question Feature |
| 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 FiltersReading Days Elapsed Fields in the Student Details Table |
| 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
|
|
|
|
...