Section 6: Mapping & Analytics Flashcards
What are the two primary forms Geospatial data comes in?
Geographic fields and spatial data files.
What are the 10 geographic fields?
Airport
Area Code
CBSA/MSA
City
Congressional District
Country/Region
County
NUTS Eurpoe
State/Province
Zip Code
What data type are all geographic role fields?
String
What are Spatial Data Files
Spatial data files are special file types that contain geospatial data using geometry fields (ex. Shape, GeoJSON).
What special field is in spatial files?
Geometry field
what happens if you only bring out the geometry field in a spatial file, and how can you fix it?
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.
Identify the name of each section in the mapping workspace and the function
Describe the function of each icon in the View Toolbar
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
How do you navigate to the map options menu and what are the available selections?
In the top menu navigation select Map → Map Options
Possible selections are attached
Describe the functions of Map Layers
Map layers allow for cutomization of:
- Map Colors
- Map Boundaries
- Map Labels
- Built in Data Layers
Describe the function of each section of Tableau’s Map layers
What background style is the attached map?
Light
What background style is the attached map?
Normal
What background style is the attached map?
Dark
What background style is the attached map? Note this is zoomed in
Outdoors (note the topography(
What background style is the attached map (zoomed in)?
Street view
What background style is the attached map?
Satellite
What would washout of 100% look like on a map?
Name the available data layers in the map layers section
What are the four levels of detail for data layers?
What are Custom terrtiories in Tableau?
1 - allow users to dynamically select or conslidate geographic areas using traditional Tableau grouping functionality.
What are the steps to create a custom territory in Tableau
Method 1
- Create a group off of a geographic field
- Remove all other geographic fields except the new Geo group
- Polygons will form automatically around the defined areas
Method 2
- Select a group of geograhpic entities on the map itself, then click “Group Members” (screenshot attached)
Describe the function of each of the 3 sections in the image.
Describe the purpose of the 3 menu items shown
How would you remove the unknowns on this map?
Drag another geographic field to the detail mark
Describe what you’d expect to see for the 3 reference type lines on a bar chart
Define the 5 regression models in Tableau
Trend lines require _____ _______ variables
Trendlines require 2 continuous variables
- 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
- Describe what r-squared is
How would you change from a linear to a logarithmic model?
RIght click on the trend line → Choose Edit All Trendlines
How do would you get to the attached screen?
Right click on trend line → describe trend line
How would you get to the below screen?
RIght click on trendline → describe trend model
Describe the easiest way to create a box plot
Select a dimension, a non aggregated measure, and your grain then use the SHOW ME module
What’s the easiest way to create a boxplot
Select a dimension, a non aggregated measure, and your grain then use the SHOW ME module
For a control chart, describe the steps needed to apply a reference line with a set number of standard deviations above the mean
Edit Reference Line → Distribution Band → Value → Standard Deviation
At least _____ data points for a forecast, at least _______ seasons for seasonality and at least ____ months for a 12-month seasonal cycle
5, 2, 24