Visualise and Analyse the Data

Question 1

Tooltips

Answer 1

An additional field users can the tooltip when they hover over a bar or a column. It is a clever way of providing more contextual information and detail to data points on a visual.

By default, without any changes to the tooltip, it will show the value on the chosen visual!

Question 2

Combo charts are appropriate choice when …

Answer 2

you plot 2 fields that have different value ranges and you want to use a legend for one of them.

Question 3

_____ highlights changes in the relative ranking of categorical items

Answer 3

Ribbon chart

Question 4

______ shows color-coded values in a running total fashion. By default, positive values are green and negative values red.

Answer 4

Waterfall chart

Question 5

______ is a proper choice for showing values by stages and be used for revealing bottlenecks in a process or tracking workflow.

Answer 5

Funnel chart

Question 6

Scatter chart main purpose

Answer 6

• Visualize two or more metrics for categorical items.
  -Can be used for clustering!
  -Can be an effective way to show a relationship between 2 metrics or to highlight outliers

Question 7

Types of AI Visuals

Answer 7

• Key Influencers
• Decomposition Tree
• Q&A

Question 8

Key influencers

Answer 8

Goal: helps users understand the main drivers behind a metric and compare the importance of the drivers
- Analyze: the metric you wanna analyse by, which can be continuous or categorical
- Explain by: factors you want to check in terms of influence
- Expand by: when analyse a measure or a summarised field you can increase the detail level without considering these factors as influences

Question 9

Whereas the Key influencers tab in the Key influencers visual show how each factor individually affects a metric, the ______ shows how a combination of factors influences a measure

Answer 9

Top segments tab

Question 10

Decomposition tree

Answer 10

allows users to perform the root cause analysis or interactive drill down

• Analyze: the measure or aggregated field you want to analyze
• Explain by: the dimensions you want to analyze by
• Tooltips: the measures or aggregated fields you want to show when hovering over a bar

Question 11

Decomposition tree is a great choice when _________________

Answer 11

When you want to perform root cause analysis or ad hoc exploration

Question 12

Conditional Formatting Style List:

Answer 12

• Gradient: suitable for continuous color gradients. Enter the minimum and maximum values for the field and set the corresponding colors
• Rules: suitable for colors with no gradients between them. Assign colors to value ranges, specific numbers or blank values
• Field value: when you have a field that returns a color code, use this option

Question 13

Dashboards can be created only in

Answer 13

Power BI Service

Question 14

Cons of visuals in tiles

Answer 14

Visuals in tiles aren’t as interactive as report visuals although you may see tooltips, you can’t cross filter one tile by selecting an item in another tile.

Question 15

Benefit of pinning a live report page to a dashboard

Answer 15

• Pinning a live report page overcome the limitation of not being able to cross filter and being able to interact, and pinning only one visual at a time
• The visuals become interactive

Question 16

Purpose of configuring bookmarks

Answer 16

Main purpose: highlight a certain visual with applied filters that show an interesting insight.

Bookmarks let you save the states of your pages

Question 17

What is cross highlighting

Answer 17

selecting a data point in a visual will highlight portions of other visuals

Question 18

To change cross highlight, go to the Format ribbon where there are 3 buttons

Answer 18

• Filter: only show values that related to the selected data point
• Highlight: highlights portions of visuals that relate to the selected data point
• None: ignores any selections

Question 19

Difference between the layer order and tab order

Answer 19

• The Tab Order is a simple technique that allows users to more easily navigate across our report using the keyboard shortcuts alone.
• The layer order of a visual determines which visual gets selected when you click in an area where two visuals overlap

Question 20

Explain the different types of drill:
- Drill down
- Show next level
- Expand to next level
- Drill up

Answer 20

• Drill down: goes to the next level of the hierarchy within the selected point. Drilling down to Quarter from Year 2020 will show quarters for the year 2020 only
• Show next level: goes to the next level with no filter on the previous level. Selecting this option to go from Year to Quarter will show all quarters for all years without showing years
• Expand to next level: combines the current and next levels. When you select this option from year to quarter, you’ll see quarters for each year separately.
• Drill up: goes back up one level

Question 21

How to detect outliers

Answer 21

Ways: data profiling, quick insights and scatter chart

Question 22

Treemap visualization displays data as a set of

Answer 22

nested rectangles

Question 23

Web Content Accessibility Guidelines (WCAG) help make web content accessible to people with disabilities. The key principles of the guidelines are:

Answer 23

• Perceivable - Information and user interface components must be presentable to users in ways that they can perceive.
• Operable - User interface components and navigation must be operable.
• Understandable - Information and the operation of the user interface must be understandable.

Question 24

Cross report drillthrough

Answer 24

TheCross-report drillthroughfeature allows you to contextually jump from one report to another report in the same Power BI service workspace or app.

Question 25

If you find that visuals are not causing the performance issues, you should assess the DAX query results that are displayed in the

Answer 25

Performance analyzerpane

Question 26

Purpose of paginated reports

Answer 26

Paginated reports allow report developers to create Power BI artifacts that have tightly controlled rendering requirements. Paginated reports are ideal for creating sales invoices, receipts, purchase orders, and tabular data.

Paginated reports give a pixel-perfect view of the data. Pixel perfect means that you have total control of how the report renders.