Visualise and Analyse the Data Flashcards
Tooltips
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!
Combo charts are appropriate choice when …
you plot 2 fields that have different value ranges and you want to use a legend for one of them.
_____ highlights changes in the relative ranking of categorical items
Ribbon chart
______ shows color-coded values in a running total fashion. By default, positive values are green and negative values red.
Waterfall chart
______ is a proper choice for showing values by stages and be used for revealing bottlenecks in a process or tracking workflow.
Funnel chart
Scatter chart main purpose
- 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
Types of AI Visuals
- Key Influencers
- Decomposition Tree
- Q&A
Key influencers
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
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
Top segments tab
Decomposition tree
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
Decomposition tree is a great choice when _________________
When you want to perform root cause analysis or ad hoc exploration
Conditional Formatting Style List:
- 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
Dashboards can be created only in
Power BI Service
Cons of visuals in tiles
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.
Benefit of pinning a live report page to a dashboard
- 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