Skip to Content

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:

/wp-content/uploads/2015/11/data_genius_001_840182.jpg

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.

/wp-content/uploads/2015/11/data_genius_003_840183.jpg

The user also has the option to filter the complete data set to a specific region.

/wp-content/uploads/2015/11/data_genius_004_840184.jpg

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.

/wp-content/uploads/2015/11/data_genius_005_840185.jpg

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.

/wp-content/uploads/2015/11/data_genius_006_840186.jpg

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply