So I decided in the last minute to submit an entry for the Data Genius Competition and create a small dashboard around the CO2 Emission data using SAP BusinessObjects Design Studio. The data is available on SAP’s Data Genius website, so all I needed to do was to do a little bit of a clean up start creating my dashboard.
Looking at the data it was quickly clear that just the data on the CO2 Emission does not deliver a very strong message, so I decided to enrich the data set with other information – such as the Oil Consumption, Total Energy consumption, Coal Consumption, and Electricity consumption for the different countries.
So the first page of my dashboard look like this:
The user has the option to choose which KPI is being used for the X-Axis and which KPI is being used for the Y-Axis.
The data set is group by regions and each region is represented by a color in the scatter plot.
The user also has the option to filter the complete data set to a specific region.
And the user can decide to include the Total Population of each country as a third measure, which then means that we will switch from a scatter plot to a bubble chart.
On the second tab I am following the same concept but I am using maps to visualize the information and when filtering the data to a specific region, the map will focus on the selected region – for example Europe.
Now the interesting part in the data is to see how the data has changed over the years – for example how our Oil and CO2 consumption has changed in the last 50 years.
For that I added a slider component to the dashboard in Design Studio and created the option to simply “play” the years and the see the changes in the data.
Here a short video of that.