Versions Compared

Old Version 104

changes.mady.by.user Lise Venning

Saved on

compared with

New Version 105

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 get to explore detailed information. Here are several some of the features you can use to target results to your needs: 

...

Anchor
Using the myBullsPath Report Filters
Using the

...

myBullsPath Report Filters
Using the myBullsPath Report Filters

Reading Days elapsed fields in the Student Details tab

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

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

    Expand
    titleUsing the myBullsPath Report Filters
    title


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

    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

    Expand
    titleUsing the myBullsPath Report Filters
    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 two additional filters 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: Image Removed

    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

    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: Image Added

    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:




    Anchor
    Using the Ask a Question Feature
    Using the Ask a Question Feature
    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. 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


    Anchor
    Reading Days Elapsed Fields in the Student Details Table
    Reading Days Elapsed Fields in the Student Details Table
    Reading Days Elapsed Fields in the Student Details Table

    Expand
    titleReading Days Elapsed Fields in the Student Details Table


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

    May not include

    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






    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.

    ...