Domain 2: Exploring & Analyzing Data

Question 1

How do you create a bar chart?

Answer 1

1. Drag Dimension to columns
2. Drag Measure to Rows
3. Select “Bar Chart” on the marks card

Question 2

How do you create a line chart?

Answer 2

1. Drag Dimensions to Columns

2. Drag Measures to Rows

Question 3

How do you create a Scatterplot?

Answer 3

1. Drag first Measure to Columns
2. Drag second Measure to rows
3. Drag a Dimension to color or detail
4. From the Analytics Pane drag the Trendline model to add a trend line

Question 4

How do you create a map?

Answer 4

1. Drag Longitude Measure to Columns
2. Drag Latitude Measure to Rows
3. Drag Dimension to Detail or color

Question 5

How do you create a dual axis chart?

Answer 5

1. From the data pane drag Dimension to Columns or row
2. Drag Measure to row or columns
3. Drag second measure besides the first one
4. Select “dual axis” on the second measure via right-click
5. Change Mark type in the marks card when needed

Question 6

How do you create a combined axis chart?

Answer 6

1. Drag a dimension to either column or Rows
2. Drag “Measure Values” to the opposite
3. Drag out measures from the “Measure Value Card” you dont need

Question 7

How do you create a stacked bar with a seperate bar for each dimension?

Answer 7

1. Drag Dimension to columns
2. Drag Measure names to color on the marks card
3. On Color, right-click the Measure Names and select filter
4. Drag “Measure Values” to Rows
5. Change mark type in the Marks Card to “Bar”

Question 8

How do you create a stacked bar with a seperate bar for each measure?

Answer 8

1. Drag Dimension to color
2. Drag Measure Names to Columns
3. Right Click “Measure Names”, select filter
4. Drag “Measure Values” to Rows

Question 9

How do you create a density map?

Answer 9

1. Double-click on the latitude and longitude measures
2. Drag Dimension to the “Details Mark”
3. Change mark type to “density”

Question 10

What can you adjust on a density map?

Answer 10

• Color
• Intensity
• Size

Question 11

Why would you use a highlight table?

Answer 11

To compare categorical data using color

Question 12

How do you create a Highlight table?

Answer 12

1. Drag Dimension to columns
2. Drop Second and third dimension to rows
3. Drag Measure to color on the Marks card

Question 13

How do you create a crosstab (text table)?

Answer 13

1. Drag Dimension to Columns
2. Drag Second Dimension to Rows if necessary
3. Drag Measure to Text on the Marks Card

Question 14

How do you create a group by selecting data in the view?

Answer 14

In the view, select one or more data points and then click the group icon on the tooltip

Question 15

How do you create a group from a field in the data view?

Answer 15

1. In the Data Pane right click on a field
2. Select Create and then Group
3. Select the members and then click group

Question 16

How do you create a dynamic set?

Answer 16

1. In the Data pane, right-click on a dimension and click create and then set
2. Configure your sets using “General”, “Condition” or “Top”

Question 17

How do you create a fixed set?

Answer 17

1. In the visualization select one or more marks (or headers) in the view
2. Right-Click the marks and select “create set”
3. Select name for the set and configure it using “General”, “Condition” or “Top”

Question 18

How do you organize dimensions in a hierarchy?

Answer 18

1. In the data pane, drag a dimension on top of another dimension
2. Enter name of hierarchy
3. Drag additional Fields into the hierarchy as needed
4. Drill up or down using “+” or “-“ in the hierarchy

Question 19

Describe the filtering order

Answer 19

1. Extract Filters
2. Data Source Filters
3. Context Filters
4. Filters on Dimensions
5. Filters on Measures

Question 20

How to filter marks from a view?

Answer 20

1. Select one or more marks in the visualization

2. Select “Keep only” or “exclude” from the tool tip

Question 21

How to filter using headers from your data?

Answer 21

1. Select Header in the view

2. Select “Keep only” or “exclude” from the tool tip

Question 22

How do you filter dimensions or measures?

Answer 22

Drag and drop dimensions or measures from the data pane to the filters shelf.

Question 23

What options do you have when filtering a dimension?

Answer 23

• General
• Wildcard
• Condition
• Top

Question 24

What options do you have when filtering a Measure?

Answer 24

• Range of Values
• At least
• At most
• Special

Question 25

What options do you have when filtering a Date?

Answer 25

- Filter relative Dates - Filter a range of dates - Filter discrete dates - Filter individual dates - Starting to end date - Null, non-null and all dates - Latest date via checkbox

Question 26

What is the sort order of a quick sort?

Answer 26

1. Sorts ascending 2. Sorts descending 3. Clears sorts

Question 27

How do you sort specific fields?

Answer 27

1. Right click on the fields you want to sort | 2. Select sort by

Question 28

How can you configure the "sort" by option of a field?

Answer 28

- Data Source Order - Alphabetic Order - Field -> Field will be used to determine order, aggregation type can be choosed - Manual - Nested -> Field that does not have to be in the visualization is used for the order

Question 29

How do you add a reference line?

Answer 29

1. Drag "Reference Line" from the Analytics pane into the view 2. Select type of reference line 3. Select a continous field from the value field 4. Select aggregation 5. Select label 6. Select tooltip 7. Specify the line and/or confidence interval

Question 30

What options do you have when adding a reference line?

Answer 30

- Line - Band - Distribution - Box Plot

Question 31

What quick table calculations can you use?

Answer 31

- Running total - Difference - Percent difference - Percent of total - Rank - Percentile - Moving Average - YTD total - Compound growth rate - Year of growth rate - YTD growth

Question 32

How do you apply a quick table calculation?

Answer 32

On the Marks Card, right click on the Measure and select "Quick Table Calculation"

Question 33

What customizing options do you have for a quick table calculation?

Answer 33

1. Calculation type 2. How to aggregate Values 3. How to compute calculation

Question 34

How do you create a binned dimension?

Answer 34

1. In the Data pane, right click on a measure 2. Select create and then "Bins" 3. Enter Name and size of bin

Question 35

What bin range of values available for in a bin?

Answer 35

- Min - Max - Difference - Count Distinct

Question 36

How do you create a histogramm from a binned dimension?

Answer 36

1. Click the binned dimension and choose "Convert to continious" 2. Drag the bin dimension from the data pane to the Columns shelf 3. Drag an optional measure to the rows shelf 4. Change the Aggregation from the optional measure to Count

Question 37

Why should you use a calculated field?

Answer 37

- To segment data - To convert data types - To aggregate data - To filter results - To calculate ratios

Question 38

How do you creat a calculated field?

Answer 38

1. Select Analysis and then "Create Calculated Field" | 2. Enter a name and formula

Question 39

What is a parameter?

Answer 39

A parameter is a workbook variable such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.

Question 40

How do you display grand totals in a visualization?

Answer 40

1. Click the Analysis Pane | 2. Under Summarize, select Totals and drag it into the add totals dialog