Combining multiple datasets allows analysts to create richer, more contextual visualizations. Instead of viewing variables in isolation, you can analyze relationships between emissions, GDP, population, and energy use in a single, unified view.

This guide explains how to link four datasets in Tableau Public, prepare the data correctly, and build an interactive CO₂ emissions visualization.

1. Scenario Overview

You are a data analyst at a policy research institute. Your task:

Create a visualization showing:

  • CO₂ emissions per capita
  • For each country
  • From 2000–2011
  • With contextual information:
    • Population
    • GDP
    • Energy use

To accomplish this, you must combine four datasets:

  1. CO₂ Data
  2. Energy Use
  3. GDP Total
  4. Total Population

2. Uploading Multiple Datasets

  1. Log into Tableau Public.
  2. Click My Profile → Create a Viz.
  3. In Connect to Data, upload the CO₂ dataset.
  4. Go to the Data Source tab.
  5. Under Connections, click the + icon.
  6. Add:
    • Energy
    • GDP Total
    • Total Population

You now have four datasets loaded into Tableau.

3. Understanding JOINs

A JOIN combines tables based on shared columns.

Common JOIN types:

  • Inner Join → Only matching rows from both tables.
  • Left Join → All rows from left table, matched rows from right.
  • Right Join → All rows from right table, matched rows from left.
  • Outer Join → All rows from both tables.

In this case, we are joining on:

  • Year
  • Country name

These columns act as relational keys.

4. Creating the First JOIN (CO₂ + Energy)

  1. Drag CO₂ data cleaned into the canvas.
  2. Drag the Energy sheet to the right side of the CO₂ box.
  3. A JOIN window appears.

Set JOIN conditions:

  • Year (CO₂) = Year 1 (Energy)
  • Country Name (CO₂) = Country (Energy)

If necessary:

  • Change Year and Year 1 data types from Number (#) to Date.

Correct data type alignment is critical for accurate joins.

5. Joining GDP Total

  1. Drag GDP Total into the canvas beneath Energy.
  2. Open JOIN settings.
  3. Change Year GDP Total to Date.
  4. Add JOIN clause:
    • Country Name (CO₂)
    • Country (GDP Total)

Confirm matching key fields.

6. Joining Total Population

  1. Drag Total Population into the canvas.
  2. Change Year Total Population to Date.
  3. Add JOIN clause:
    • Country Name (CO₂)
    • Country Total Population

Click Update Now to preview combined data.

7. Time Range Alignment

Important observation:

  • CO₂ dataset spans 1960–2011.
  • Other datasets span 2000–2015.
  • The intersection is 2000–2011.

This overlapping range becomes your valid analysis window.

Always verify temporal alignment after joins.

8. Correcting Data Types

Some columns may load as string (ABC).

Convert:

  • Energy Use → Number (Decimal)
  • Current GDP → Number (Whole)

Correct data types ensure:

  • Accurate aggregation
  • Proper scaling
  • Correct filtering behavior

9. Creating the CO₂ Per Capita Map

  1. Go to Sheet 1.
  2. Drag Country Name to Detail.
  3. Drag CO₂ Per Capita to Color.

This generates a world map colored by emissions intensity.

10. Applying a Diverging Color Palette

  1. Click Color → Edit Colors.
  2. Select Red-Green Diverging.
  3. Check:
    • Stepped Colors
    • Reversed

Reasoning:

  • Green → Lower emissions (more favorable)
  • Red → Higher emissions (less favorable)

Set scale manually:

  • Start = 0
  • End = 62

Manual range ensures consistent color meaning across years.

11. Adding an Interactive Year Filter

  1. Drag Year to the Filters shelf.
  2. Choose Years → All → OK.
  3. Right-click Year in Filters.
  4. Select Show Filter.
  5. Change filter display to Single Value (Slider or Dropdown).

Users can now toggle between years 2000–2011.

The map updates dynamically.

12. Extracts and Saving

If prompted:

  1. Go to Data Source.
  2. Click Create Extract.
  3. Save again using Publish As.

Extracts improve performance for multi-source data.

13. What You Achieved

You successfully:

  • Linked four datasets.
  • Ensured correct key matching.
  • Aligned time ranges.
  • Standardized data types.
  • Built an interactive, color-coded map.
  • Added user-controlled filtering.

This demonstrates multi-source integration and dynamic visualization.

14. Why Linking Data Matters

Single datasets often provide limited perspective.

Combining datasets allows:

  • Contextual comparisons
  • Multi-factor analysis
  • Richer storytelling
  • Policy-relevant insights

For example:

  • High CO₂ per capita + High GDP
  • Low emissions + High renewable energy
  • Population-adjusted comparisons

Linked datasets enable deeper insight.

15. Key Technical Concepts Reinforced

  • Data connections
  • JOIN logic
  • Key column matching
  • Data type alignment
  • Extract creation
  • Diverging color palettes
  • Interactive filtering
  • Time-series exploration

16. Final Insight

Linking multiple datasets transforms isolated variables into integrated analysis.

In this case:

  • Emissions
  • Economic output
  • Population
  • Energy use

Combine into a single analytical framework.

The more you practice combining data sources, the more capable you become at presenting complex relationships clearly and interactively.

Complex data becomes powerful when structured correctly and visualized thoughtfully.