Versions Compared

Old Version 107

changes.mady.by.user Lise Venning

Saved on

compared with

New Version 108

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


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



Excerpt
hiddentrue

Reading Days Elapsed Fields in the Student Details Table

...

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






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.

...