Difference between revisions of "HomeIntel"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 69: Line 69:
 
Our team did background research on the topic before creating the storyboards. It will expose us to the different types of charts and graphs that we can use for the project and consider how we can make it better. Some of the visualisations that we draw inspiration from are as follows:  
 
Our team did background research on the topic before creating the storyboards. It will expose us to the different types of charts and graphs that we can use for the project and consider how we can make it better. Some of the visualisations that we draw inspiration from are as follows:  
  
−
<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: 45%;" | Visual Considerations
+
! style="background:#B0E0E6;|Reference of Other Interactive Visualization !!style="background:#B0E0E6;| Learning Points
−
! style="font-weight: bold;background: #141414;color:#fbfcfd;width: 55%" | Insights / Comments
 
 
|-
 
|-
−
| <center>
+
|
−
'''Title''': Sunburst Diagram
+
<center><br/> '''Title: Historical Average of HDB Resale Prices in Ang Mo Kio
−
[[File:Sunburst.png|250px|frameless|center]]
+
'''  
−
'''Source''':https://bl.ocks.org/mbostock/4348373
+
[[File:Relatedwork1.jpg|200px|center]]
 +
Source: https://getaflat.herokuapp.com/charts
 
</center>
 
</center>
  
 
||  
 
||  
 +
* This is a time-series chart which allow users to see the trend in resale prices by room type over time
 +
* The axis titles are missing
 +
* We will be using this chart as a reference and improving it by adding filters such as the age of flat and story range
  
−
*'''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
+
| <center><br/>  '''Title: Distribution of 4-Room HDB Resale Prices By Town '''  
−
** Does not provide a comprehensive time-series comparison
+
[[File:Relatedwork2.jpg|200px|center]]
 +
Source: https://public.tableau.com/profile/priyadarsan.shankar#!/vizhome/Singapore4-ROOMHDBresalepricesvisualization/HDBdashboard
 +
</center>
 +
||
 +
* The box plots can be used to identify towns with high median resale prices
 +
* Outliers can be identified easily and we can see if the data is skewed
  
 
|-
 
|-
−
| <center>
+
| <center><br/> '''Title: Singapore Property Prices Heatmap '''
−
'''Title''': Treemap
+
[[File:3.jpg|200px|center]]
−
[[File:Treemap.png|250px|frameless|center]]
+
Source: https://www.greyloft.com/singapore/property-prices-heatmap
−
'''Source''':https://www.theinformationlab.co.uk/2015/02/10/show-treemaps/
 
 
</center>
 
</center>
 
||  
 
||  
−
 
+
* The heatmap focuses on the price per square foot by district.
−
*'''Pros''':
+
* Users can select the date range
−
** Effective visualisation to organise multivariate data by hierarchy
+
* The tooltips provide more information on the trend, the number of transactions and towns within the district
−
** We can effectively see the purpose of visit for the top 10 visiting countries to Korea.
+
* Easy to interpret the chart and the legends are useful.  
−
+
* The Central area stands out well. Good colour choice to represent the high price per sqf
−
 
+
* We will do a heatmap on the average resale price by town and provide more information in the tooltip
−
*'''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.
 
  
 
|-
 
|-
−
| <center>
+
|<center><br/>  '''Title: Heat Map of Median Resale Price'''
−
'''Title''': Chord Diagram
+
[[File:Captureff.jpg|200px|center]]
−
[[File:Chord.png|250px|frameless|center]]
+
Source: https://public.tableau.com/profile/darrick8462#!/vizhome/HDBResaleAnalysisDDO/HDBRESALEDASHBOARD
−
'''Source''':https://beta.observablehq.com/@mbostock/d3-chord-diagram
 
 
</center>
 
</center>
 
||  
 
||  
  
−
*'''Pros''':
+
* The heat map shows the relationship between flat type and the storey range
−
** Effective visualisation to see the influx of Visitors from and to Korea.
+
* We can improve this further by creating a heatmap based on an additional field called Estate Type (mature and non-mature estates)
−
** 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.
 
  
−
|-
 
 
|}
 
|}
−
</center>
 
  
 
== Brainstorming Sessions ==  
 
== Brainstorming Sessions ==  

Revision as of 03:42, 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

This dataset will be used to understand the resale transacted price and see the price trend change over year.

Background Survey

Our team did background research on the topic before creating the storyboards. It will expose us to the different types of charts and graphs that we can use for the project and consider how we can make it better. Some of the visualisations that we draw inspiration from are as follows:

Reference of Other Interactive Visualization Learning Points

Title: Historical Average of HDB Resale Prices in Ang Mo Kio

Relatedwork1.jpg

Source: https://getaflat.herokuapp.com/charts

  • This is a time-series chart which allow users to see the trend in resale prices by room type over time
  • The axis titles are missing
  • We will be using this chart as a reference and improving it by adding filters such as the age of flat and story range



Title: Distribution of 4-Room HDB Resale Prices By Town
Relatedwork2.jpg

Source: https://public.tableau.com/profile/priyadarsan.shankar#!/vizhome/Singapore4-ROOMHDBresalepricesvisualization/HDBdashboard

  • The box plots can be used to identify towns with high median resale prices
  • Outliers can be identified easily and we can see if the data is skewed

Title: Singapore Property Prices Heatmap
3.jpg

Source: https://www.greyloft.com/singapore/property-prices-heatmap

  • The heatmap focuses on the price per square foot by district.
  • Users can select the date range
  • The tooltips provide more information on the trend, the number of transactions and towns within the district
  • Easy to interpret the chart and the legends are useful.
  • The Central area stands out well. Good colour choice to represent the high price per sqf
  • We will do a heatmap on the average resale price by town and provide more information in the tooltip

Title: Heat Map of Median Resale Price
Captureff.jpg

Source: https://public.tableau.com/profile/darrick8462#!/vizhome/HDBResaleAnalysisDDO/HDBRESALEDASHBOARD

  • The heat map shows the relationship between flat type and the storey range
  • We can improve this further by creating a heatmap based on an additional field called Estate Type (mature and non-mature estates)

Brainstorming Sessions

Proposed Storyboard

Tools and Technologies Used

Challenges

Timeline

Comments

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