Visualize & Analyze the Data Flashcards
What visualization is good to use when measuring multiple measures that have different scales?
Combination Charts
What is a slicer
A slicer is an on-canvas visual filter that allows report users to segment the data by a specific value.
Examples of filters include by year or by geographical location.
When would you use a basic area chart?
To see & compare the volume trend across a time series
for an individual series representing a physically countable set
What visual can be created using the report editor or Q&A?
Card
What visual is best used to compare a particular value section to the whole?
Doughnut chart
What visual is good for showing how values increase and decrease over time?
Waterfall chart
What visual would you use to compare 2 different measures or highlight outliers?
Scatter Chart
What does the play axis allow you to do on a chart?
Animate a chart over time
What visual would you use to measure progress or distance to a goal or to compare a value against one or 2 targets?
KPI
What map visual would you use to compare regions on a map using color?
Shape Map
What map visual is only available in Power BI Desktop?
The shape map is only available in power bi desktop and not in Power Bi service or mobile
What map must be enabled before you use it?
The shape map is only in preview and must be enabled before you can use it.
How do you enable the shape map?
File
Options & Settings
Options
Preview Features
Select Shape map visual
What are the field wells of the variations of bar charts offered?
Axis - columns to be placed on the horizontal or vertical axis. (when using more than 1 column users can drill down)
Legend - The categorical column used to color items
Values - one or more numerical fields to be plotted (if you use a legend, you can put only one field into this field well)
Tooltips - additional fields that users can see in the tooltip when they hover over a bar or column. The default tooltips will be shown when you hover over the bars or columns
When are bar charts best used?
When comparing values across categories.
What are the field wells of the line and area charts offered?
Axis - Columns to be placed on the horizontal axis (when using more than 1 column users can drill down)
Legend - The categorical column used to color items
Values - one or more numerical fields to be plotted (if you use a legend, you can put only one field into this field well)
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column
When are line & area charts best used?
When you want to show historical trends or compare values across time.
What are the field wells of the combo charts offered?
Shared Axis - columns to be placed on the horizontal axis (when using more than 1 column users can drill down)
Column series - Similar to a legend; one column may be used
Column values - one or more numerical fields to be plotted (if you use a legend, you can put only one field into this field well)
Line values - One or more numerical values to be plotted as lines
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column
When are combo charts best used?
when you have a line chart and a column chart with the same X-axis.
to compare multiple measures with different value ranges.
to illustrate the correlation between two measures in one visualization.
to check whether one measure meet the target which is defined by another measure
to conserve canvas space.
What are the field wells of the ribbon charts offered?
Axis - Columns to be placed on the horizontal axis (when using more than 1 column users can drill down)
Legend - The categorical column used to color items
Values - one or more numerical fields to be plotted (if you use a legend, you can put only one field into this field well)
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column. *When you hover over the ribbons between columns you will see how the values changed between two columns
When are ribbon charts best used?
When you want to show the progression of ranking changes between different categories.
What are the field wells of the Waterfall charts offered?
Category - Columns to be placed on the horizontal axis. (when using more than 1 column users can drill down)
Breakdown - You can use 1 column here to show changes between categories
Values - One numerical field to be plotted
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column. *When using the breakdown field, hovering over a breakdown item will show the change between two categorical items
What are the field wells of the Funnel charts offered?
Group - For one or more categorical columns, where each item is a stage. (when using more than 1 column users can drill down)
Values - One numerical field to be plotted
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
*When you hover over a categorical item in a funnel chart, you’ll see a tooltip with the proportion that category makes up of the first & previous items. It also shows the size of the last item relative to the first one.
When are funnel charts best used?
Funnel charts can be a proper choice for showing values by stages
What are the field wells of the scatter charts offered?
Details - you can use one or more categorical columns in this field well to plot points.
Legend - The categorical column used to color items
X-axis - one field to be placed on the horizontal axis
Y-axis - one field to be placed on the vertical axis
Size - For one numerical field to be used for relative bubble sizing
Play Axis - You can use a column here, which is usually a time-series column such as Year or Date
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
What are the field wells of Pie & Donut charts offered?
Legend - For 1 or more categorical columns used to color items. When using more than one column, you can drill down.
Details - Each slice may be split by a categorical column used here
Values - YOu may use one or more numerical fields here; if you show Details, you are limited to only one field
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
When are Pie & Donut charts best used?
When comparing a section to a whole.
Both charts are not considered best practice in data visualization with one exception: you may use a Pie & Donut chart when there are only two categories
What are the field wells of the Treemap visual offered?
Group - For one or more categorical columns that will define the relative size of rectangles. When using more than one column, you can drill down.
Details - Each rectangle may be split by a categorical column used here
Values - One or more numerical fields to be plotted; if you show details; you are limited to one field only.
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
When are Treemaps best used?
When you want to show proportions between each part and the whole, as well as highlight the most important contributions and outliers
What are the field wells of the variations of map visuals offered?
Location - For one or more categorical columns that contain locations to be plotted. When using two or more, you can drill down.
Legend - you can use a column here to color items
Latitude - one field can be used here
Longitude - one field can be used here
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
Size field - for different bubble sizes based on a numerical field.
What are the field wells of the gauge visuals offered?
Value - For a numerical field; displayed in the center
Min value - A numerical field may be used as the start of the scale
Max value - A numerical field may be used at the end of the scale
Target value - you can use one numerical field here, which is displayed as a line/needle on the gauge
Tooltips - Additional fields that users can see in the tooltip when they hover over the bar or column.
When are gauges best used?
When tracking KPIs or targets; especially those with known maximum values such as proportions
What are the field wells of the KPI visual?
Indicator - for a numerical field; displayed in the center
Trend axis - for a column, preferably one that contains time-series data (like year or date)
Target goals - For one or two numerical fields against which the indicator is compared
When is the card visual best used?
when there’s only one value to display
When is the multi-row card best used?
When you want to display several metrics across a category. It’s good for displaying several unrelated metrics at once.
What happens with performance if you have a lot of visuals on one page?
It slows the performance down.
What are the common formatting options for visuals?
General - Height, width, alt text, title, header icons, tooltips, effects (background color and transparency)
Title - Title text, word wrap, font color, background color, alignment, text size, & font family)
Background - background color and transparency
Lock aspect - when you adjust the size of a visual manually, its aspect will be locked
Border - border color and radius
Shadow - Shadow color position and preset
Tooltips, where you choose to use the default tooltip or to use a specific report page as a tooltip.
Visual Header - where you hide the whole visual header or some of its element
Slicers accept only ____ as fields to filter by
Columns
In what ways can slicers be displayed?
List
Drop Down
How can you search on a slicer visual?
You can add a search bar to a list or dropdown slicer by hovering over it and selecting more options
What options are available in the selection control of a slicer?
Force a single selection
Select whether the CTRL key is required for multiple selections
Show the select all option
What is required to create a hierarchial slicer?
Multiple columns from one or more related tables
What filter options are available for slicers that use a numeric column?
Between
Less than or equal to
Greater than or equal to
What options are available for slicers that use a date/time column?
Between
Before
After
Relative Date - can filter one or more periods such as days or months before or after today’s date. It can also filter for the current period
Relative Time - For time periods such as minutes or hours
What does filter on this visual filter option do?
These filters apply to a specific visual you select and this is visible only when you select a visual. You can use both measures and columns on the visual.
*Fields that are in the field well, usually automatically appear in the “filters on this visual” section
What does the filter on this page filter option do?
These filters will apply to all visuals on the currently selected page
What does the filter on all pages filter option do?
These filters will apply to all visuals across all pages.
you can’t make specific filters ignore these filters and you can only use columns to filter on
How do you add fields into the fields pane?
Drag & drop
Right-click the field and select add to filters & the select the section you want to add the field to
