Map layers in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a map visualization showing store locations with sales performance and customer density layers to identify high-performing areas with many customers.

📊 Data: You have data on store locations (latitude, longitude), total sales per store, and customer counts per store area.

🎯 Deliverable: Create a Tableau map with two layers: one showing store locations sized by sales, and another showing customer density as a heatmap.

Sample Data

Store ID	Store Name	Latitude	Longitude	Total Sales	Customer Count
101	Central	40.7128	-74.0060	150000	1200
102	Northside	40.7306	-73.9352	90000	800
103	East End	40.7060	-73.9969	120000	950
104	West Point	40.7359	-74.0036	110000	1100
105	South Park	40.7001	-74.0125	80000	700
106	Uptown	40.7484	-73.9857	130000	1000
107	Harbor	40.6892	-74.0445	70000	600
108	Midtown	40.7549	-73.9840	140000	1150

1

Step 1: Connect the sample data to Tableau as a data source.

Import the data table with columns: Store ID, Store Name, Latitude, Longitude, Total Sales, Customer Count.

Expected Result

Data is loaded and visible in Tableau's data pane.

2

Step 2: Create a map view by dragging Longitude to Columns and Latitude to Rows.

Drag Longitude to Columns shelf and Latitude to Rows shelf.

Expected Result

A basic map with points representing store locations appears.

3

Step 3: Add store locations as points sized by Total Sales.

Drag Store Name to Detail on Marks card, drag Total Sales to Size, and set mark type to Circle.

Expected Result

Store points appear on the map sized proportionally to their sales.

4

Step 4: Create a new map layer showing customer density as a heatmap.

Duplicate the map worksheet, change mark type to Density, drag Customer Count to Color.

Expected Result

Heatmap layer shows areas with higher customer counts in warmer colors.

5

Step 5: Combine the two layers into a dashboard with map layers.

Create a dashboard, add both map worksheets, and overlay the heatmap layer with transparency over the store points map.

Expected Result

Dashboard shows store locations sized by sales with a transparent heatmap of customer density underneath.

6

Step 6: Adjust colors and transparency for clarity and accessibility.

Set heatmap colors to a colorblind-friendly palette, adjust opacity to 50%, and ensure store points have distinct colors.

Expected Result

Map layers are clear, readable, and accessible to all users.

Final Result

Heatmap Layer: Customer Density

↓

Store Locations Layer: Circles sized by Sales

✓Central and Midtown stores have the highest sales and are located in areas with high customer density.

✓Harbor store has the lowest sales and is in an area with low customer density.

✓Areas with high customer density but moderate sales could be opportunities for sales growth.

Bonus Challenge

Add a filter to the dashboard to select sales ranges and see how customer density correlates with different sales levels.

Show Hint

Use a parameter or filter on Total Sales and apply it to both map layers to dynamically update the visualization.

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