ANLY482 AY2016-17 T2 Group13 - Initial Visualizations & Findings

AP PROJECTS

HOME

ABOUT US

PROJECT OVERVIEW

PROJECT FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

Methodology

Initial Visualizations

Data Exploration

Trade Analysis Dashboard

References

To create a set of initial visualisations of the data set, our group used Tableau. In the final product, we aim to reproduce a more seamless application through R, with the support capabilities of R Shiny.

Overview

Overview of UK Imports to Singapore

500px

The visualisation above shows us the overview of UK imports into Singapore. Both visualisations allow the user to look at UK imports. However, one looks at imports based on sector, and one looks at UK imports based on commodity. Under the hierarchy, sector is one aggregation level above commodity. On both treemaps, each quadrilateral represents a commodity/sector. The colour represents the percentage of market share of a particular commodity/sector with respect to the world while the size of the quadrilateral represents the market share of the commodity with respect to UK’s total exports to Singapore. The user can filter the treemap by year to see the change in exports by UK into Singapore and change in market share of Singapore’s imports from UK.

Overview of World Imports to Singapore

500px

The user can use the treemaps above show us the imports from all parts of the world into Singapore. Both visualisations allow the user to look at imports into Singapore. However, one treemap looks at it from the sector level while the other looks at it from the commodity level, where sector is one aggregation level above commodity in a hierarchy. Each quadrilateral represents a single sector/commodity of Singapore’s imports. The colour represents the trade value of a particular import into Singapore in US$ million while the size represents the number of countries that import a particular sector/commodity into Singapore. The user can filter the treemap by year to see that changes in number of countries importing a particular sector/commodity and the trade value of each sector/commodity.

Selection of sector or commodity will lead to a view of all countries within the selected sector/commodity.

Analysis of Countries within Sector/Commodity

500px

After choosing a particular commodity, the user will be able to view how the position of certain countries have changed with regards to their imports into Singapore. From the visualisation above, we can see a treemap on the left. The purpose of this treemap is to view the number of transactions in a particular year a country imports into Singapore based on the size of the quadrilateral. The colour of each quadrilateral on the treemap shows us the import value, in US$ millions, of the commodity in question.

From there, the user can view the slop graph on the right to compare how each country’s imports, of a particular commodity, has changed between two years. The year filter allows the user to select any two years to see how a country’s position has changed. The commodity and sector filters allow the user to choose a particular sector/commodity that they want to analyse.

Analysis by Selected Sector/Commodity

500px

• Country Market Share = Country Commodity / World Commodity

After filtering the dataset by sector and/or by commodity, we can look at the time-series graph above. This will allow us to look at the change in US$ trade value in millions of the sector/commodity into Singapore over the past five years.

From there we can use the bar graph in the bottom left corner to see top N countries that are importing a particular sector/commodity into Singapore. N can be determined by the filter on the right.

Then at the bottom right, the user will be able to see the top N countries that import the sector/commodity into Singapore based on market share. The user will also be able to compare the market share of that particular country to the market share of UK. N in this scenario can also be changed from the filter to the right.

Analysis by Selected Country

500px

After looking at market shares of other countries in comparison to the UK, the user would want to see the other commodities the country is importing into Singapore. This can be done by looking at the visualisation above. The time series-graph allows the user to look at the change in imports of a particular commodity over the past five years for one particular country.

From there, the user can look at the bar graph on the bottom left to see the top 10 sectors based on US$ trade value(millions).

The bar graph on the bottom right shows the user the top N commodities imported into Singapore based on US$ trade value (millions).