In this post, I would like to brief the usage of SAP Visual Intelligence to understand the CO2 emissions by drilling down to the data
The data can be downloaded from http://data.worldbank.org
As we have an option in Visual Intelligence,to explore the data directly from Excel,just browsed for the source file and selected the required fields to explore and finally acquired the data.
I wanted to find the Country which contributes for the high CO2 emission.Since Visual Intelligence has a good geographical maps,i thought of exploring the data using it.
Create a Geographical Hierarchy on Country Name
Add this under Dimensions with,the Population values of year 2010 as Measure
China has a higher value and contributing for the huge population growth
Just to identify the Top 15 Countries who contributed for the global population growth,filter the top 15 values
As China is in No.1,it’s possible to know what kind of CO2 emissions this Country makes with the help of Visual Intelligence by applying further filtering and Treillis.
Filter the Country Name by China and move the CO2 emissions type(Indicator Name) under Treillis.This shows the different types of emissions during various years in China as shown below
Out of different CO2 emissions,let’s focus on “Emissions by residential and commercial buildings”.Filter the third chart to focus more on that
This chart shows that the “Emissions by residential and commercial buildings” are high in the year of “1990”
To find why its high in this particular year,we can add additional Indicator “Urban Population Growth”
This clearly indicates that when there is a high Urbal Population Growth,the amount of CO2 emission from residential and commercial buildings are more.
Thus SAP Visual Intelligence helps the casual business users to dive into the data (though he doesnt have much technical knowledge about the data modeling) and come up with the conclusion with a very good visualisation capability.