Map layers in Tableau - Dashboard Guide

Dashboard Mode - Map layers

Business Question

Where are our store locations, and how do sales vary by region and customer density?

Sample Data

Store ID	Store Name	Latitude	Longitude	Region	Sales	Customer Count
1	Central Market	40.7128	-74.0060	East	150000	1200
2	Westside Shop	34.0522	-118.2437	West	130000	900
3	North Point	41.8781	-87.6298	Midwest	90000	700
4	South Plaza	29.7604	-95.3698	South	110000	850
5	East End	39.9526	-75.1652	East	120000	1000
6	West Bay	37.7749	-122.4194	West	140000	1100

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 740000
• Map Layer 1: Store Locations
  Plot points using [Latitude] and [Longitude]
  Each point labeled with [Store Name]
• Map Layer 2: Sales by Region
  Color regions by total sales
  Formula: { FIXED [Region] : SUM([Sales]) }
• Map Layer 3: Customer Density Heatmap
  Heat intensity based on [Customer Count] at each store location
• Table: Store Details
  Columns: Store Name, Region, Sales, Customer Count

Dashboard Layout

+----------------------+--------------------------+
|      KPI Card        |       Map (Layers)       |
|  Total Sales: 740000 | +----------------------+ |
|                      | | Store Locations (dots) | |
+----------------------+ | Sales by Region (color)| |
|       Table          | | Customer Density (heat)| |
| Store Details        | +----------------------+ |
|                      |                          |
+----------------------+--------------------------+
  

Interactivity

Region Filter: Selecting a region updates the map layers, KPI card, and table to show only stores in that region.

Hover on Map Points: Shows store details tooltip.

Click on Map Region: Filters the table and KPI card to that region.

Self Check

Add a filter for Region = 'West'. Which components update?

• KPI Card updates to show total sales for West region (270000).
• Map layers update to show only West region stores and color.
• Table updates to list only West region stores.

Key Result

Dashboard showing store locations on layered maps with sales and customer density by region.

Practice

1. What is the main purpose of Map Layers in Tableau?

easy

A. To combine different types of data on a single map

B. To create bar charts from map data

C. To export maps as images

D. To filter data in tables

Solution

1. Step 1: Understand the role of Map Layers

   Map Layers allow you to add multiple data types like points, colors, or shapes on one map.

2. Step 2: Differentiate from other features

   Map Layers are not for charts, exporting, or filtering tables but for combining map data visually.

3. Final Answer:

   To combine different types of data on a single map -> Option A

4. Quick Check:

   Map Layers = Combine data on map [OK]

Hint: Map Layers = multiple data types on one map [OK]

Common Mistakes:

• Confusing Map Layers with chart creation
• Thinking Map Layers export maps
• Assuming Map Layers filter tables

2. Which Tableau pane do you use to control the background details of a map?

easy

A. Filters shelf

B. Data pane

C. Marks card

D. Map Layers pane

Solution

1. Step 1: Identify the pane for background map control

   The Map Layers pane lets you toggle streets, borders, and other background details on or off.

2. Step 2: Differentiate from other panes

   The Data pane holds data fields, Marks card controls data visualization marks, and Filters shelf filters data, not background map details.

3. Final Answer:

   Map Layers pane -> Option D

4. Quick Check:

   Background control = Map Layers pane [OK]

Hint: Background map details = Map Layers pane [OK]

Common Mistakes:

• Using Data pane for map backgrounds
• Confusing Marks card with background control
• Trying to filter background layers

3. Given a Tableau map with a filled map layer and a point layer added via the Marks card, what will happen if you remove the point layer from the Marks card?

medium

A. The filled map layer will disappear

B. Only the point markers will disappear, filled map remains

C. Both layers will remain unchanged

D. The map will switch to a table view

Solution

1. Step 1: Understand layers added via Marks card

   Each layer added via the Marks card is independent; removing one removes only that layer.

2. Step 2: Effect of removing point layer

   Removing the point layer removes only the points; the filled map layer remains visible.

3. Final Answer:

   Only the point markers will disappear, filled map remains -> Option B

4. Quick Check:

   Remove point layer = points gone, fill stays [OK]

Hint: Removing one Marks layer removes only that layer [OK]

Common Mistakes:

• Assuming all layers disappear together
• Thinking map switches to table view
• Believing filled map depends on points

4. You added a polygon layer to your Tableau map but it does not display. What is the most likely cause?

medium

A. The Map Layers pane is turned off

B. You forgot to add a filter to the polygon layer

C. The polygon data is not properly connected or lacks geographic roles

D. Tableau does not support polygon layers

Solution

1. Step 1: Check data connection and geographic roles

   Polygon layers require properly connected data with geographic roles assigned to draw shapes.

2. Step 2: Eliminate other causes

   Map Layers pane controls background, not polygon visibility; filters are optional; Tableau supports polygons.

3. Final Answer:

   The polygon data is not properly connected or lacks geographic roles -> Option C

4. Quick Check:

   Polygon missing = data or geographic roles issue [OK]

Hint: Polygon layers need geographic roles assigned [OK]

Common Mistakes:

• Turning off Map Layers pane expecting polygons to show
• Assuming filters are mandatory for polygons
• Believing Tableau can't show polygons

5. You want to create a map showing sales by state with colored filled areas and overlay customer locations as points. Which steps correctly use Tableau's Map Layers feature?

hard

A. Use the Marks card to create a filled map for sales, then add a point layer for customers; adjust Map Layers pane for background details

B. Create two separate worksheets, one for sales and one for customers, then combine them in a dashboard

C. Use only the Map Layers pane to add both sales and customer data layers

D. Add sales data as points and customer data as filled areas using the Filters shelf

Solution

1. Step 1: Use Marks card for multiple layers

   Create a filled map layer for sales by state, then add a point layer for customer locations on the same map using the Marks card.

2. Step 2: Adjust background with Map Layers pane

   Use the Map Layers pane to control background map details like streets or borders for better visualization.

3. Final Answer:

   Use the Marks card to create a filled map for sales, then add a point layer for customers; adjust Map Layers pane for background details -> Option A

4. Quick Check:

   Marks card layers + Map Layers pane = correct layering [OK]

Hint: Marks card for data layers, Map Layers pane for background [OK]

Common Mistakes:

• Trying to add data layers only via Map Layers pane
• Using separate worksheets instead of layers
• Misusing Filters shelf for map layers