Skip to Content

Hi friends,

In this challenge I will try to show you a analysis of high-tech exports from several countries, using SAP Predictive analyis. High-technology exports are products with high R&D intensity, such as in aerospace, computers, pharmaceuticals, scientific instruments, and electrical machinery. Data are in current U.S. dollars.

I collected the data from This link from 1988-2011. First of all we need to download the data, then save the data in excel (.xlx).

format the data is presented as the table below, the Country Code will very helpful to facilitate in determining the position of a country. After that I made ​​a meansure by year and country.

/wp-content/uploads/2013/09/a_276301.png

Below is a visualization of the formed:

Table: in the form of tables will provide more detailed information, the following is the number of 20 countries with the highest export of High-Technology in 2011 in U.S. dollar

/wp-content/uploads/2013/09/b_276305.png

Pie Chart: in the visualization of Pie chart, Look China export value in 2011 is comparable to the 3 biggest exporting country below china. Very fantastic!

c.PNG

China also controls almost one quarter trading of High-Technology in the world.

d.PNG

Next below is the view in map, here shows which countries become exporters High-Technology in 2011 and we compare with 10 years ago.

e.PNG

f.PNG

Seen 10 years before America was the one who controlled, with japan and europe trade of High-Technology.

Next we will see the growth of the country’s largest exporter of High-Technology in 2011 from 1991.

g.PNG

in the form of a 3D coloum chart, we can see countries that are trying to become the largest exporter, is seen starting in 2005 singapore starting compensate for export japan. then seen a steady growth in Germany. American growth fell in 2008, then back again to China shows his superior ability in increasing foreign exchange through export.

let’s look further than 1988, the following visualization:

h.PNG

Clearly visible, China export boom in 2004-2005, seen also Japan and Germany in 1988, dominate High-Technology trade, though still showed growth until now, as well as Singapore slowly but surely.

The line chart below can show more clearly the growth of export High-Technology:

i.PNG

The next is a comparison of the growth 5 country, measured by the distance of 10 years. China look shows a very high jump from 1991 to 2011

j.PNG

To clarify we can take a look into how much the increase in exports of High-technology, Compared with 10 countries under china’s based on largest export in 2011.

k.PNG

Impressive growth from China.

In SAP Predictive Analysis, there are still some visualization models that can be used, of course, according to the analytical model that wants to do. This is very helpful in getting information fast and fun.

Some other visualization with SAP Predictive Analysis, I try to look as 25 states with the largest export in 2011.

l.PNG

If you like Metrostyle like in windows 8/7 phone, can use the TreeMaps

m.PNG

Final word, i closed my blog by following analysis with Area chart, which shows the state with the highest export value since the year 1988 to 2011.

o.PNG

and the state sequence is:

1 United States USA USD 3.515.400.010.727
2 China CHN USD    2.858.199.703.290
3 Japan JPN USD    2.438.208.885.873
4 Germany DEU USD    2.250.702.907.511
5 Singapore SGP USD    1.590.257.163.593
6 United Kingdom GBR USD    1.383.176.166.542
7 France FRA USD    1.341.417.595.247
8 Korea, Rep. KOR USD    1.244.740.286.973
9 Netherlands NLD USD       934.583.062.916
10 Malaysia MYS USD       851.180.519.231

I hope this blog gives all new inspiration in presenting raw data more fun and colorful.

Thank you 🙂

Best Regards,

Jerry Zhang

To report this post you need to login first.

1 Comment

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

Leave a Reply