Studying CO2 Emission
Tableau Dashboard
About this project
Project Goal
The objective of this project is to discern the countries that have the most significant impact on global carbon dioxide (CO2) emissions. The project aims to gain insights into CO2 emissions on a country and continental level, identifying trends and the key contributors to atmospheric pollution. The date is sourced from the World Bank's indicator dataset (https://data.worldbank.org/indicator).
SQL Code
The SQL analysis in this project contains distinct stages, beginning with data quality assessment to ensure dataset integrity, followed by country-level CO2 emission insights and identifying data gaps. Subsequently, the analysis highlights emission trends and prominent contributors, showcasing top countries with recent CO2 indicator values and associating continents with indicator averages. Additionally, temporal patterns are explored through pivoted tables indicating yearly averages, while emission growth is quantified and average emissions for countries and continents are computed. The results gave us a good idea about the key contributors to the emission. The detailed queries can be viewed from the GitHub link above.
Tableau Dashboard
The culmination of the SQL analysis was the creation of an interactive Tableau dashboard. This visualization tool presented the derived insights in a user-friendly format. The dashboard included an interactive map illustrating the country-wise distribution of emissions, enabling users to focus on specific countries of interest. A time series analysis also showcased emissions over time in a chosen country, complete with forecasts for the upcoming year.
Key Insights and Conclusion
The project offered significant insights into global emissions trends. Among 213 countries, very few countries missed data that were removed from the analysis. The project showcased varying emission levels among countries, with leaders like the US, China, India, and Germany prominently featured. Among the continents, Africa exhibited the highest increase in the yearly rate of emissions, underscoring the urgent need for sustainable strategies. In terms of average emissions, North America led the continents, while Africa had the least emissions despite experiencing the highest increase rate. Although, much more indicators need to be included to reach a conclusion about CO2 emissions, this project gave a good starting point and provided an in-depth understanding of global CO2 emissions.
Additional project images
