Difference between revisions of "1718t1is428T8"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 57: Line 57:
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Visualisation Plan</font></div>
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Visualisation Plan</font></div>
 
To meet the required objectives of customisability and interactivity, we drew our inspiration from [http://www.nytimes.com/interactive/2013/03/29/sports/baseball/Strikeouts-Are-Still-Soaring.html?ref=baseball Mike Bostock's Visualisation on Baseball Strikeouts]. We would like to reproduce his method of incorporating the many components of a time series visualisation into one graph, hidden in the background of the overall trend, as well as the ability to select a component to view when needed.
 
To meet the required objectives of customisability and interactivity, we drew our inspiration from [http://www.nytimes.com/interactive/2013/03/29/sports/baseball/Strikeouts-Are-Still-Soaring.html?ref=baseball Mike Bostock's Visualisation on Baseball Strikeouts]. We would like to reproduce his method of incorporating the many components of a time series visualisation into one graph, hidden in the background of the overall trend, as well as the ability to select a component to view when needed.
 
+
[[File:Strikeouts on the Rise.png|450px]]
 
Our plan is to produce a similar visualisation, with countries instead of baseball players and exports or imports of services instead of strikeouts. This will allow us to view the long-term trend of this dataset while viewing the individual country data in the background, as well as allowing selection and highlighting of individual countries upon request.  
 
Our plan is to produce a similar visualisation, with countries instead of baseball players and exports or imports of services instead of strikeouts. This will allow us to view the long-term trend of this dataset while viewing the individual country data in the background, as well as allowing selection and highlighting of individual countries upon request.  
  

Revision as of 17:58, 4 November 2017

DOTA.png



Introduction

Singaporecbd.jpg



The international exports and imports of services has played an increasingly important role in Singapore over the last decade, with 70% of the nation’s GDP comprising of service industries such as finance, insurance and wholesale retail trade, up from 64% 10 years ago. This is contrasted to the decline of the share of manufacturing in the economy, down from 26% to 19% in the same period.

As government bodies such as the Ministry of Trade and Industry (MTI ) and Innovation and Enterprise (IE) Singapore focus more on these industries in their development plans, there comes the need to continuously view the trends and components of our services exports. This will allow us to understand the growth trends of this critical aspect of Singapore’s economy, its individual components and the countries that contribute to it and finally to monitor the effects of existing initiatives from various government agencies. Through


Problem and Motivation

From the existing reports prepared by MTI, we’ve identified the following areas in which we plan our visualization to value-add:

1) Interactivity and Customisability - By allowing the reader to interact with the graph to filter periods to view as well as the level of detail. This will facilitate user-led investigation and exploration of the data without any data processing tools.

2) Professional and ready to use format – This will save stakeholders such as MTI and SPH time in the preparation of graphs, especially when graph formatting is necessary before release to the public.

Exhibit 5 Growth of services exports va.png

This will provide a one stop visualization for stakeholders in the services industry in Singapore, to quickly consume the aspects of this data that is relevant to them, in an aesthetically pleasing and intuitive manner.


Data Source

We are using the following two datasets from the Singapore Department of Statistics:

Exports Of Services By Major Trading Partner And Services Category, Annual Dataset

Imports Of Services By Major Trading Partner And Services Category, Annual Dataset

The dataset consists of the following columns:

  • match_id - INTEGER, unique match id
  • match_seq_num - INTEGER, match sequence number
  • radiant_win - STRING, boolean variable than indicates if radiant won or not in the match
Visualisation Plan

To meet the required objectives of customisability and interactivity, we drew our inspiration from Mike Bostock's Visualisation on Baseball Strikeouts. We would like to reproduce his method of incorporating the many components of a time series visualisation into one graph, hidden in the background of the overall trend, as well as the ability to select a component to view when needed. 450px Our plan is to produce a similar visualisation, with countries instead of baseball players and exports or imports of services instead of strikeouts. This will allow us to view the long-term trend of this dataset while viewing the individual country data in the background, as well as allowing selection and highlighting of individual countries upon request.

For additional customisability, we will include filters to toggle between viewing the absolute Exports in services, the percentage change over the years and selection of imports or exports. On top of that, to facilitate country selection, we will have a bar graph on the right denoting the measure selected, such as exports, by each individual country. This bar graph will be linked to the time series chart, allowing us to quickly view and select, for example, the largest country that imports Singapore's services and quickly highlight it on the main chart.


Key Technical Challenges

The following are some of the key technical challenges that we may face throughout the course of the project:

Key Technical Challenges Plans to resolve these issues
Data Cleaning & Transformation
  • Understanding the data
  • Cleaning and Transforming the data together
Unfamiliarity in Javascript, especially D3 Libraries
  • Attending D3 Programming Workshop
  • Research on different types of charts
  • Independent Learning on D3 Libraries
  • Asking questions on sites like StackOverflow to seek help


Project Timeline

The timeline for this project until its completion is as follows:

T8 Timeline.png


Tools & Technologies

The tools and technologies we will be using for this project:

  • Data Cleaning
    • Excel
    • JMP
    • R
  • Data Visualization
    • D3.js


Comments

Please give us feedbacks! Thank you!