Why maps visualize location data in Tableau - Dashboard Impact

Dashboard Mode - Why maps visualize location data

Business Question

How can we use maps to understand sales distribution across different cities?

Sample Data

City	State	Sales	Latitude	Longitude
Seattle	WA	150000	47.6062	-122.3321
Portland	OR	90000	45.5152	-122.6784
San Francisco	CA	200000	37.7749	-122.4194
Los Angeles	CA	180000	34.0522	-118.2437
Denver	CO	120000	39.7392	-104.9903
Chicago	IL	160000	41.8781	-87.6298
New York	NY	250000	40.7128	-74.0060

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 1,150,000
• Map Visualization: Sales by City
  Marks: Circle size and color represent sales amount
  Location: Uses [Latitude] and [Longitude] fields
  Tooltip: Shows City, State, and Sales
• Bar Chart: Sales by State
  Formula: SUM([Sales]) grouped by [State]
  Shows total sales per state for comparison

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Map View        |
|  (Total Sales)       |  (Sales by City)     |
+----------------------+----------------------+
|                 Bar Chart (Sales by State)          |
+----------------------------------------------------+

Interactivity

Clicking on a city in the map filters the bar chart to show sales only for that city's state. Selecting a state in the bar chart highlights cities in that state on the map. The KPI card updates to show total sales for the selected filters.

Self Check

If you add a filter to show only cities in California, which components update and how?

• KPI Card updates to show total sales for California cities (San Francisco + Los Angeles = 380,000).
• Map shows only San Francisco and Los Angeles with their sales data.
• Bar chart shows only California's sales total.

Key Result

A dashboard showing total sales and sales distribution by city and state using a map and charts.

Practice

1. Why do maps help in visualizing location data in Tableau?

easy

A. Because maps show where data points are located geographically

B. Because maps only show numerical data trends

C. Because maps replace all other chart types

D. Because maps hide data details

Solution

1. Step 1: Understand the purpose of maps

   Maps are designed to display data points based on their geographic location.

2. Step 2: Relate to Tableau's mapping feature

   Tableau uses geographic fields to place data on maps, helping users see spatial patterns.

3. Final Answer:

   Because maps show where data points are located geographically -> Option A

4. Quick Check:

   Maps visualize location data by showing geographic points [OK]

Hint: Maps show data by location, not just numbers [OK]

Common Mistakes:

• Thinking maps only show numbers
• Believing maps replace all charts
• Assuming maps hide data

2. Which of the following is the correct way to create a map in Tableau using geographic data?

easy

A. Drag a geographic field like 'Longitude' to Columns and 'Latitude' to Rows

B. Drag a geographic field like 'City' to the Marks card and select Map

C. Drag a geographic field like 'Country' to Rows and then to Columns

D. Drag a numeric field to Filters and select Map

Solution

1. Step 1: Identify how Tableau plots maps

   Tableau uses Latitude and Longitude fields to position points on a map.

2. Step 2: Confirm correct field placement

   Longitude goes to Columns and Latitude goes to Rows to create a map view.

3. Final Answer:

   Drag a geographic field like 'Longitude' to Columns and 'Latitude' to Rows -> Option A

4. Quick Check:

   Longitude on Columns and Latitude on Rows creates maps [OK]

Hint: Longitude = Columns, Latitude = Rows for maps [OK]

Common Mistakes:

• Putting numeric fields in Filters to create maps
• Dragging geographic fields only to Marks card
• Swapping Latitude and Longitude incorrectly

3. Given a dataset with 'City', 'Sales', and 'Latitude' and 'Longitude' fields, what will happen if you drag 'Longitude' to Columns and 'Latitude' to Rows in Tableau?

medium

A. Tableau will produce an error

B. Tableau will create a bar chart of sales

C. Tableau will show a table of city names

D. Tableau will create a map showing sales by city location

Solution

1. Step 1: Understand field roles

   Latitude and Longitude fields define geographic points for mapping.

2. Step 2: Visualize Tableau's behavior

   Dragging Longitude to Columns and Latitude to Rows plots points on a map, showing locations.

3. Final Answer:

   Tableau will create a map showing sales by city location -> Option D

4. Quick Check:

   Latitude and Longitude create maps, not bar charts [OK]

Hint: Latitude and Longitude create maps, not charts [OK]

Common Mistakes:

• Expecting bar charts from geographic fields
• Confusing table view with map view
• Assuming error occurs without extra steps

4. You tried to create a map in Tableau by dragging 'City' to Rows and 'Sales' to Columns, but no map appeared. What is the likely problem?

medium

A. You must drag Latitude and Longitude fields to create a map

B. City is not recognized as a geographic field automatically

C. Sales is a geographic field and should not be on Columns

D. Tableau does not support maps with city data

Solution

1. Step 1: Check field geographic role

   City may not be set as a geographic role, so Tableau treats it as text.

2. Step 2: Understand Tableau mapping requirements

   Tableau needs geographic roles or Latitude/Longitude to plot maps.

3. Final Answer:

   City is not recognized as a geographic field automatically -> Option B

4. Quick Check:

   Geographic roles must be assigned for maps [OK]

Hint: Assign geographic roles to fields before mapping [OK]

Common Mistakes:

• Assuming Sales is geographic
• Thinking Latitude/Longitude always required
• Believing Tableau can't map cities

5. You want to visualize sales data by state on a map in Tableau, but your dataset only has state names and sales figures. What is the best way to create a map showing sales by state?

hard

A. Drag 'Sales' to Rows and 'State' to Columns to create a bar chart

B. Create calculated fields for Latitude and Longitude manually

C. Assign the 'State' field a geographic role of 'State/Province' and drag it to Detail on the Marks card

D. Use only numeric fields to create the map

Solution

1. Step 1: Assign geographic role to 'State'

   Tableau needs to know 'State' is a geographic field to map it.

2. Step 2: Use 'State' on Marks card Detail

   Dragging 'State' to Detail lets Tableau plot each state on the map automatically.

3. Final Answer:

   Assign the 'State' field a geographic role of 'State/Province' and drag it to Detail on the Marks card -> Option C

4. Quick Check:

   Geographic role + Detail = map by state [OK]

Hint: Assign geographic role and use Detail for location maps [OK]

Common Mistakes:

• Trying to create maps without geographic roles
• Using numeric fields only for maps
• Manually creating Latitude/Longitude unnecessarily