Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
IngoH
Advisor
Advisor

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.

Labels in this area