Visualize and Analyze the Data

Question 1

Waterfall Chart

Answer 1

Displays a running total as values are added or subtracted
The initial values and final values must start on horizontal axis
The intermediate values must be floating columns

Question 2

Combo Chart

Answer 2

a chart that combines a column chart and a line chart and can have 1 0r 2 Y axis

Question 3

Funnel Chart

Answer 3

a chart that has sequential connected stages. Items flow from one stage to the next

Question 4

Scatter Chart

Answer 4

a chart with 2 value axes, one set of numerical data on the horizontal and another set of numerical data on the vertical, normally used for showing a relationship between 2 variables and there categoruical distribution between each other

Question 5

Slicer Visual

Answer 5

avaible in different formats like list, drop-down and buttons

Question 6

Treemap visualzation

Answer 6

displays data as a set of nested rectangles. they are used when you need to display large amounts of hierarchy data, and parts of a whole

Question 7

To use the R visual what do you need to do?

Answer 7

1. install R on your computer
2. configure the global r scripting options (this enables the script visuals options)

Question 8

Which two types of interaction behavior can you change between visuals?

Answer 8

Highlight and Filter

Question 9

Drill-through

Answer 9

A page navigation experience that takes you from one page to another plus applies a set of filters on the new page

Question 10

Expand

Answer 10

A way to navigate down a level using hierarchy controls

Question 11

Ribbon Chart

Answer 11

it places the highest ranked value at the top of the stacked column each month and shows those rank changes overtime

Question 12

Clustered Bar Chart

Answer 12

Horizontial Bar Chart

Question 13

Clustered Column Chart

Answer 13

Vertical Bar Chart

Question 14

Stacked Bar Chart

Answer 14

Horizontal Bar with Portions

Question 15

Stacked Column Chart

Answer 15

Veritcal Bar with Portions

Question 16

What’s the difference between bar and column charts?

Answer 16

Bars charts run horizontal, columns chart run vertically

Question 17

What 2 visuals support conditional foramtting?

Answer 17

Tables and matrix

Question 18

What is needed to make sure a slicer is synced between multiple slicers on other report pages?

Answer 18

It has to be using the same column

Question 19

What two data types are supported in bin-based grouping?

Answer 19

Only Date/Time and Numeric

Question 20

What is Grouping data in Power BI Visuals?

Answer 20

Grouping is used for categories of data like grouping 3 states, 3 products, 3 top customers together to see how they compare to the rest of the categories

Question 21

What are the 2 group types in power bi?

Answer 21

List and Binning

Question 22

What data types can use List grouping and Binning?

Answer 22

Number and Date/Time fields can use binning or list grouping
Text can only use list grouping

Question 23

What is Binning data in Power BI visuals?

Answer 23

Binning data is like grouping but instead you use it to group continuous fields like numbers and dates. It allows you to right-size the data.

Question 24

Why would you use grouping and binning in power bi?

Answer 24

when you want to analyze data and see trends for groups that don’t naturally exist in the source data with a lookup table or an attribute to identify them. So for example grouping Countries by Continet or binning customer ages

Question 25

How do you create a new bin or group?

Answer 25

In the data pane right click the column and select New Group

Question 26

What are the 2 bin types?

Answer 26

Size of Bins and Number of Bins

Question 27

What is size of bins?

Answer 27

this is where you set the size or the interval for the bins and power BI will create how ever many bins are needed. So if you had 10 ages from 60-80 and you wanted to have them binned every 10 years it would create have 3 bins 60, 70, 80

Question 28

What is number of bins?

Answer 28

you select the number of bins you want and it auto sets the bin size. so if you only want 2 bins and had 10 ages from 60-80 it will figure out how to bin the values so that they fall in the first bin or the second bin

Question 29

What is clustering

Answer 29

A way to identify segments of data (called a cluster) that are similar to each other and different from the rest.

Question 30

What 2 resources do you need to create a histogram of a range of numbers?

Answer 30

a bin group type and a numeric column

Question 31

What DAX function would you use to create a formula that will list the top 10 best-selling products sorted by their total sales?

Answer 31

TOPN

Question 32

What does RANKX do?

Answer 32

It returns the ranking of a number in a list of numbers for each row in a table

Question 33

If you need to add a new visual to a power bi dashboard and the visual does not exist on a report in the workspace what should you do first?

Answer 33

Ask a question about your data since the Q&A feature lets you create a visual by asking a question then pinning it to the dashboard