Visualise and Analyse the Data Flashcards

1
Q

Tooltips

A

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!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Combo charts are appropriate choice when …

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

_____ highlights changes in the relative ranking of categorical items

A

Ribbon chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Waterfall chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Funnel chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Scatter chart main purpose

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Types of AI Visuals

A
  • Key Influencers
  • Decomposition Tree
  • Q&A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Key influencers

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Top segments tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Decomposition tree

A

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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Decomposition tree is a great choice when _________________

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Conditional Formatting Style List:

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dashboards can be created only in

A

Power BI Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Cons of visuals in tiles

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Benefit of pinning a live report page to a dashboard

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Purpose of configuring bookmarks

A

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

Bookmarks let you save the states of your pages

17
Q

What is cross highlighting

A

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

18
Q

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

A
  • 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
19
Q

Difference between the layer order and tab order

A
  • 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
20
Q

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

A
  • 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
21
Q

How to detect outliers

A

Ways: data profiling, quick insights and scatter chart

22
Q

Treemap visualization displays data as a set of

A

nested rectangles

23
Q

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

A
  • 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.
24
Q

Cross report drillthrough

A

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

25
Q

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

A

Performance analyzerpane

26
Q

Purpose of paginated reports

A

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.