Difference between revisions of "HomeIntel"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 37: Line 37:
 
The Data Sets we will be using for our analysis and for our application is listed below:
 
The Data Sets we will be using for our analysis and for our application is listed below:
  
−
<center>
+
{| class="wikitable" style="margin-left: auto; margin-right: auto; width: 90%;
−
{| class="wikitable" style="background-color:#FFFFFF;" width="90%"
 
 
|-
 
|-
−
! style="font-weight: bold;background: #141414;color:#fbfcfd;width: 30%;" | Dataset/Source
+
! style="background:#B0E0E6;|Dataset/Source !! style="background:#B0E0E6;|Data Attributes !! style="background:#B0E0E6;|Rationale of Usage
−
! style="font-weight: bold;background: #141414;color:#fbfcfd;width: 20%" | Data Attributes
 
−
! style="font-weight: bold;background: #141414;color:#fbfcfd;width: 50%;" | Rationale Of Usage
 
−
 
 
−
 
 
−
||
 
−
<center>This dataset will be used to understand the most popular tourist attraction in the different major cities in Korea. We will also be able to gain insights on the Number of visitors to each attraction and also if they are local and foreigner visitors which will allow us to see the difference between locals and foreigners.</center>
 
 
|-
 
|-
−
| <center>Entry by nationality by age
+
| <center><br/>
−
(2007 - 2018)<br/><br/><br/>
+
Resale Flat Price (Jan 2015- Aug 2019)
−
([http://know.tour.go.kr/stat/tourStatSearchDis.do;jsessionid=18780F0E8CFAFBBCEB58B0A96098EDD3 Click to View Data])</center>
+
<br/>
−
||
+
(https://data.gov.sg/dataset/resale-flat-prices?resource_id=42ff9cfe-abe5-4b54-beda-c88f9bb438ee)
  
−
* City
+
</center>
−
 
 
−
* Age Range
 
−
 
 
−
* Date
 
−
 
 
−
||
 
−
<center>This data set will be used to understand the general demographic of international visitors coming to Korea from 2007 - 2018. We will be able to gain descriptive insights on the visitor demographics by Age Range.</center>
 
−
|-
 
−
| <center>Entry by nationality by Sex
 
−
(2007 - 2018)<br/><br/><br/>
 
−
([http://know.tour.go.kr/stat/tourStatSearchDis.do;jsessionid=18780F0E8CFAFBBCEB58B0A96098EDD3 Click to View Data])</center>
 
 
||
 
||
 +
* Month
 +
* Town
 +
* Flat type
 +
* Block
 +
* Street Name
 +
* Storey range
 +
* Floor Area sqm
 +
* Flat Model
 +
* Lease Commence Date
 +
* Remaining Lease
 +
* Resale Price
  
−
* City
+
||  
−
 
+
To gain information on the HDB procurement over the years such as:
−
* Sex
+
* The Resales prices by flat type
−
 
+
* Area size and Floor level and;
−
* Date
+
* The lease date of the flat.
−
 
 
−
||
 
−
<center>This data set will be used to understand the general demographic of international visitors coming to Korea from 2007 - 2018. We will be able to gain descriptive insights on the visitor demographics by Gender.</center>
 
−
|-
 
−
| <center>Entry by nationality by Purpose
 
−
(2007 - 2018)<br/><br/><br/>
 
−
([http://know.tour.go.kr/stat/tourStatSearchDis.do;jsessionid=18780F0E8CFAFBBCEB58B0A96098EDD3 Click to View Data])</center>
 
−
||
 
−
 
 
−
* City
 
−
 
 
−
* Purpose of Visit
 
−
 
 
−
* Date
 
−
 
 
−
||
 
−
<center>This data set will be used to understand the general demographic of international visitors coming to Korea from 2007 - 2018. We will be able to gain descriptive insights on the visitor demographics by Purpose of Visit.</center>
 
 
|}
 
|}
−
</center>
 
−
 
−
<br/>
 
  
 
==<div style="background:#143c67; padding:15px; font-weight: bold; line-height: 0.3em;letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>BACKGROUND SURVEY</center></font></div>==
 
==<div style="background:#143c67; padding:15px; font-weight: bold; line-height: 0.3em;letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>BACKGROUND SURVEY</center></font></div>==

Revision as of 03:18, 13 October 2019

Logo home.png


Team

 

Proposal

 

Poster

 

Application

 

Research Paper


<--- Go Back to Project Groups

Problem and Motivation

Objectives

Selected Dataset

The Data Sets we will be using for our analysis and for our application is listed below:

Dataset/Source Data Attributes Rationale of Usage

Resale Flat Price (Jan 2015- Aug 2019)
(https://data.gov.sg/dataset/resale-flat-prices?resource_id=42ff9cfe-abe5-4b54-beda-c88f9bb438ee)

  • Month
  • Town
  • Flat type
  • Block
  • Street Name
  • Storey range
  • Floor Area sqm
  • Flat Model
  • Lease Commence Date
  • Remaining Lease
  • Resale Price

To gain information on the HDB procurement over the years such as:

  • The Resales prices by flat type
  • Area size and Floor level and;
  • The lease date of the flat.

BACKGROUND SURVEY


Before we embarked on this project, we did some basic background research on this topic to see if there were any visualizations or dashboards we could drive inspirations from or make it better. Below are a few visuals we found:

Reference of Other Interactive Visualization Learning Point

Title: Monthly Number of Individual Travelling Visitors (2016)

Example1.png

Source:https://www.data.go.kr/visual/content/577

Background Survey

Visual Considerations Insights / Comments

Title: Sunburst Diagram

Sunburst.png

Source:https://bl.ocks.org/mbostock/4348373

  • Pros:
    • Aims to show various sub-components of a particular category
    • Can drill down to multiple divisions to observe the distribution by percentages
    • May be useful to analyze tourism receipts by components and country
  • Cons:
    • Difficult to break down the huge number of markets
    • Does not provide a comprehensive time-series comparison

Title: Treemap

250px

Source:https://www.theinformationlab.co.uk/2015/02/10/show-treemaps/

  • Pros:
    • Effective visualisation to organise multivariate data by hierarchy
    • We can effectively see the purpose of visit for the top 10 visiting countries to Korea.


  • Cons:
    • It would be hard to compare between years and months for different countries.
    • The hierarchy will only be 2 levels so the interaction would not be as much.

Title: Chord Diagram

250px

Source:https://beta.observablehq.com/@mbostock/d3-chord-diagram

  • Pros:
    • Effective visualisation to see the influx of Visitors from and to Korea.
    • We will be able to easily spot the country with the most travelers to Korea.


  • Cons:
    • This chart will make it harder to spot trends in the visiting pattern.
    • We will not be able to see every single country as the size of the chord diagram is limited.

Brainstorming Sessions

Proposed Storyboard

Tools and Technologies Used

Challenges

Timeline

Comments
Retrieved from ‘https://wiki.smu.edu.sg/1920t1is428g1/index.php?title=HomeIntel&oldid=5119’