...
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 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." 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: - 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
|
|
...
The Card Summary tab displays the individual onboarding Cards in a series of tiles. The tiles display information on two sides:
Side ONE: provides provides Card completion calculations:
...
- Required % = # students with Card Status = Y / # students required to complete Card
- Submitted % = # students with Card Status = Y / # students eligible to complete Card
Side TWO: provides provides statistics on the completion times for students:
...