World CO₂ Emissions Growth with Dashboard using Tableau

Tableau Data Visualization

A guide to create an effective and clear dashboard for better understand average CO₂ in the world using CO₂ dataset.

Miftahul Hadi
Dec 20, 2022

Introduction

According to the World Meteorological Organization’s (WMO), the past eight years are the warmest Earth temperature on record. To better understand about this climate changes, I want to design a dashboard about World CO₂ Emissions Growth. This dashboard will review the average CO₂ that produced in every country. Then, we try to investigate the production growth over the year in every region. Hopefully, this dashboard will be beneficial to reduces and mitigates the effects of global climate changes.

Fig. 1. The spreading of factory residue

Here, we used the data sets from The World Bank Group, a world organization that work to reduce poverty in a country. This data sets include several variable such as:

What to analyze?

This data set can be used to find a questions that might arise such as:

Hopefully, this questions will be a step to reveal what inside the data sets and helps other countries to mitigate the global climate changes.

Preparation

Here, I want to describe a few tools used in this analysis:

  1. Tableau Public
  2. Excel (for storing data)
  3. CO₂ Dataset

Create a Dashboard

Here’s a step-by-step to create a clear dashboard about CO₂ growth. You can click every step to show the detailed :

Load the Dataset

To connect the dataset to Tableau, the step as follows:

As a preview, here is a view of Tableau project we work on.

As the image above, there are three sections that show up, including:

Create a Graph

In this section, we want plotting the dataset about CO₂ activity in the World to answers question.

Average CO₂ per Capita

Here’s the step to create a clear graph of average CO₂ for every country:

CO₂ Production by Region

Here’s the step to a viz about CO₂ production over the years:

Next, we can combine this two graph to design a clear dashboard.
Design the dashboard

In this section, we want to combine two graph we have created into one dashboard. Here’s the step:

Final dashboard

Here’s the final dashboard that we have created.

Now, the legend is tied with each graph. It’s give a context to graph and make the dashboard more clear.

Analysis

Average CO₂ per capita

This graph describes the average of CO₂ per capita in every country, between 1960 and 2011. The circle shows where the country is. Darker red or bigger circles indicate the country produces more CO₂ than the others. Darker the green or smaller circles, the less CO₂ to be produced.

From the graph above, we can see that the Middle-east country has the highest average CO₂ per capita. For example, Qatar (one of the Middle-east countries) has an average of 54.42 tons per capita. It means that Qatari people have produced more CO₂ than any other country in the world. This is because of Qatar’s heavy reliance on gas and oil and has relatively small population when compared to other countries. This make the average larger. There’s also UAE (31.84 tons), Kuwait (28.4 tons), Bahrain (19.87 tons), and others.

On the opposite, most of Africa and South America country has the lowest average CO₂ per capita. Chad (one of the African countries) has the average of 0.03 tons per capita, the lowest in the world.

Growth of CO₂ emitters

This graph describes the CO₂ production growth in a number of regions between 1960 and 2011. Here, the CO₂ production is measured by kilo ton (kt). Each region shows in a colored line.

From the graph above, each region tend to produce more CO₂ every year. In 1960, the highest CO₂ emitter is North America region. But 50 years later, East Asia & Pacific has produces more CO₂ than any others region.

In the graph above, we can see the rapid increase of CO₂ production in East Asia & Pacific from 1960 to 2011. In 1960, the CO₂ production is about 1,17 billion tons. 40 years later, the production is increased by 6 times (6,34 billion tons). It took only 10 years later to get 12,74 billion tons. This indicates that the increase rate of CO₂ production in East Asia & Pacific is significant.

Conclusion

According to this analysis, we find that Qatar’s reliance on Gas and Oil makes the country the highest average of CO₂ per capita with 54.42 tons produced. But, the growth of CO₂ production in East Asia & Pacific should be wary with only 10 years from 2000, the CO₂ production increased 2 times higher by 12,74 billion tons.

Suggestion

For the next analysis, a population dataset is needed for better little-bias analysis. Because, Qatar with less population could get a higher average of CO₂ per capita than other countries with a higher population.

Source

© Miftahul Hadi, 2023

Powered by &

Corrections

If you see mistakes or want to suggest changes, please create an issue on the source repository.

Citation

For attribution, please cite this work as

Hadi (2022, Dec. 20). DataHadi: World CO₂ Emissions Growth with Dashboard using Tableau. Retrieved from https://miftahulhadii.github.io/index.html/posts/2022-12-20-world-co2-emissions-growth-using-tableau/

BibTeX citation

@misc{hadi2022world,
  author = {Hadi, Miftahul},
  title = {DataHadi: World CO₂ Emissions Growth with Dashboard using Tableau},
  url = {https://miftahulhadii.github.io/index.html/posts/2022-12-20-world-co2-emissions-growth-using-tableau/},
  year = {2022}
}