It’s finally here, dashboard week! This is the week at Data School where we are given a different data source every day and must create a workflow and dashboard according to the specific requirements of the task. It doesn’t matter how far you get in the task, the main point of the week is to apply what you have learnt so far in training to your work, learn new things, and to encourage you to ask for help when you need it!
Today’s project was to look at historical data on greenhouse gas emissions. The data source was https://oasishub.co/dataset/global-cait-emission-projections
Cleaning the data was super simple as there wasn’t much cleaning necessary. I used the GHG Emissions, and Socio-Economic data, joined them both on Country and Year to join the Population column from the Socio-Economic Data to the GHG Emissions data.
I also created a second flow regarding future projections, but I did not end up using it for my final dashboard.
After that I input the data as a Tableau Hyper File, and I created a dashboard looking at the Greenhouse Gas Emissions over time. We were asked to create a KPI dashboard, so I looked at each type of greenhouse gas, and used BAN’S to display the value, that value would change depending on the country you choose to explore. I also added a KPI that showed the percent increase/decrease of greenhouse gas in the latest year (2014) verses the first year in the data source (1990).
We can see that the United States of America and China’s greenhouse gas emissions have increased dramatically over the years. However, there is some good news, the Russian Federation saw a decrease of 37%, and United Kingdom also showed some improvement with a 32% decrease since 1990.
I hope you enjoyed this blog and if you would like to explore the dashboard you can find it here: https://tinyurl.com/3by2jrn9