Section 6: Mapping & Analytics

Question 1

What are the two primary forms Geospatial data comes in?

Answer 1

Geographic fields and spatial data files.

Question 2

What are the 10 geographic fields?

Answer 2

Airport
Area Code
CBSA/MSA
City
Congressional District
Country/Region
County
NUTS Eurpoe
State/Province
Zip Code

Question 3

What data type are all geographic role fields?

Answer 3

String

Question 4

What are Spatial Data Files

Answer 4

Spatial data files are special file types that contain geospatial data using geometry fields (ex. Shape, GeoJSON).

Question 5

What special field is in spatial files?

Answer 5

Geometry field

Question 6

what happens if you only bring out the geometry field in a spatial file, and how can you fix it?

Answer 6

If you just drag the geometry field everything will show as one mark. You need to drag another geographic role field to the detail card to fix.

Question 7

Identify the name of each section in the mapping workspace and the function

Answer 7

Question 8

Describe the function of each icon in the View Toolbar

Answer 8

Thumbtack icon

Resets the map

The bottom row from left to right (starting from second from the left)

Zoom Area (bottom row second from the left) - Make a rectangular selection on the map and the view will zoom accordingly.

Pan - select the map and move it around

Rectangular selection - select marks in a rectangular pattern

Radial Selection - select marks based on a circle

Lasso - select marks based on custom shape

Question 9

How do you navigate to the map options menu and what are the available selections?

Answer 9

In the top menu navigation select Map → Map Options

Possible selections are attached

Question 10

Describe the functions of Map Layers

Answer 10

Map layers allow for cutomization of:

• Map Colors
• Map Boundaries
• Map Labels
• Built in Data Layers

Question 11

Describe the function of each section of Tableau’s Map layers

Answer 11

Question 12

What background style is the attached map?

Answer 12

Light

Question 13

What background style is the attached map?

Answer 13

Normal

Question 14

What background style is the attached map?

Answer 14

Dark

Question 15

What background style is the attached map? Note this is zoomed in

Answer 15

Outdoors (note the topography(

Question 16

What background style is the attached map (zoomed in)?

Answer 16

Street view

Question 17

What background style is the attached map?

Answer 17

Satellite

Question 18

What would washout of 100% look like on a map?

Answer 18

Question 19

Name the available data layers in the map layers section

Answer 19

Question 20

What are the four levels of detail for data layers?

Answer 20

Question 21

What are Custom terrtiories in Tableau?

Answer 21

1 - allow users to dynamically select or conslidate geographic areas using traditional Tableau grouping functionality.

Question 22

What are the steps to create a custom territory in Tableau

Answer 22

Method 1

1. Create a group off of a geographic field
2. Remove all other geographic fields except the new Geo group
3. Polygons will form automatically around the defined areas

Method 2

1. Select a group of geograhpic entities on the map itself, then click “Group Members” (screenshot attached)

Question 23

Describe the function of each of the 3 sections in the image.

Answer 23

Question 24

Describe the purpose of the 3 menu items shown

Answer 24

Question 25

How would you remove the unknowns on this map?

Answer 25

Drag another geographic field to the detail mark

Question 26

Describe what you'd expect to see for the 3 reference type lines on a bar chart

Answer 26

Question 27

Define the 5 regression models in Tableau

Answer 27

Question 28

Trend lines require _____ \_\_\_\_\_\_\_ variables

Answer 28

Trendlines require **2 continuous** variables

Question 29

1. IF you had a line chart with 2 continuous variables, describe the steps needed to show the r-squared and p-value of a trend line 2. Describe what r-squared is

Answer 29

Question 30

How would you change from a linear to a logarithmic model?

Answer 30

RIght click on the trend line → Choose Edit All Trendlines

Question 31

How do would you get to the attached screen?

Answer 31

Right click on trend line → describe trend line

Question 32

How would you get to the below screen?

Answer 32

RIght click on trendline → describe trend model

Question 33

Describe the easiest way to create a box plot

Answer 33

Select a dimension, a non aggregated measure, and your grain then use the SHOW ME module

Question 34

What's the easiest way to create a boxplot

Answer 34

Select a dimension, a non aggregated measure, and your grain then use the SHOW ME module

Question 35

For a control chart, describe the steps needed to apply a reference line with a set number of standard deviations above the mean

Answer 35

Edit Reference Line → Distribution Band → Value → Standard Deviation

Question 36

At least **\_\_\_\_\_** data points for a forecast, at least _______ seasons for seasonality and at least ____ months for a 12-month seasonal cycle

Answer 36

5, 2, 24