Role Hierarchy - ANSWER ADMN, Member, Contributor, Viewer
Admin Role - ANSWER All responsibilities
Member Role - ANSWER Same as Admin but cannot assign roles, delete workspaces, or
change metadata
Contributor Role - ANSWER Can create, update, and publish and set refreshes for content
and reports but cannot publish apps, delete reports change metadata or assign roles
Viewer Role - ANSWER Can only view information
Auto Date Hierarchy - ANSWER Day, Month, Quarter, Year
Lineage View - ANSWER Shows last refresh and can identify stale data
How to format for mobile view? - ANSWER Resize visuals and set slicers to be responsive.
Adjusting page size only affects laptop layout
Why should you switch off interactions between visuals? - ANSWER To prevent data to
filter when selecting certain values and visuals. Useful when there are multiple visuals in the
same view and they create performance issues
Best visual to show the factors that affect the outcome of sales opportunities - ANSWER
Key influencers
1
, Best visual to show progress of sales opportunities won against target - ANSWER KPI-
shows target and how much above or below we were relative to goal
Best visual to show outliers - ANSWER Scatter
How to optimize complex Dax? - ANSWER Rewrite expression using variables
How to show different context in matrices or filters - ANSWER REMOVEFILTERS()
Can excel workbooks be edited in power bi - ANSWER No, but power query can edit the
data imported from excel workbooks
When changing data, does the excel workbook need to have the same file path? - AN-
SWER No, each file has a different file path
When changing to different data, does the excel workbook need to have the same structure?
- ANSWER Yes, otherwise there will be missing columns or different names
Can you teach Q&A to understand certain key works - ANSWER Yes, you can refer to cer-
tain synonyms for keywords
Can you teach Q&A certain terms? - ANSWER No, you can only provide synonyms to cer-
tain terms to provide context
Do you have to create aggregations to help power bi recognize certain terms - ANSWER
No, only synonyms help the software to understand certain terms, aggregations have noth-
ing to do with natural language
2
Admin Role - ANSWER All responsibilities
Member Role - ANSWER Same as Admin but cannot assign roles, delete workspaces, or
change metadata
Contributor Role - ANSWER Can create, update, and publish and set refreshes for content
and reports but cannot publish apps, delete reports change metadata or assign roles
Viewer Role - ANSWER Can only view information
Auto Date Hierarchy - ANSWER Day, Month, Quarter, Year
Lineage View - ANSWER Shows last refresh and can identify stale data
How to format for mobile view? - ANSWER Resize visuals and set slicers to be responsive.
Adjusting page size only affects laptop layout
Why should you switch off interactions between visuals? - ANSWER To prevent data to
filter when selecting certain values and visuals. Useful when there are multiple visuals in the
same view and they create performance issues
Best visual to show the factors that affect the outcome of sales opportunities - ANSWER
Key influencers
1
, Best visual to show progress of sales opportunities won against target - ANSWER KPI-
shows target and how much above or below we were relative to goal
Best visual to show outliers - ANSWER Scatter
How to optimize complex Dax? - ANSWER Rewrite expression using variables
How to show different context in matrices or filters - ANSWER REMOVEFILTERS()
Can excel workbooks be edited in power bi - ANSWER No, but power query can edit the
data imported from excel workbooks
When changing data, does the excel workbook need to have the same file path? - AN-
SWER No, each file has a different file path
When changing to different data, does the excel workbook need to have the same structure?
- ANSWER Yes, otherwise there will be missing columns or different names
Can you teach Q&A to understand certain key works - ANSWER Yes, you can refer to cer-
tain synonyms for keywords
Can you teach Q&A certain terms? - ANSWER No, you can only provide synonyms to cer-
tain terms to provide context
Do you have to create aggregations to help power bi recognize certain terms - ANSWER
No, only synonyms help the software to understand certain terms, aggregations have noth-
ing to do with natural language
2
