Difference between revisions of "IS428 AY2019-20 T1 EC Inspector: Proposal V2"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<!-- Back Button -->
 +
[[Project Groups|< Back to Project Groups]] <br>
 +
 
<div style="margin-bottom:30px;">[[File:IS428_AY2019-20_T1_Group4_logo.jpg|400px|frameless|center]]</div>
 
<div style="margin-bottom:30px;">[[File:IS428_AY2019-20_T1_Group4_logo.jpg|400px|frameless|center]]</div>
  
Line 4: Line 7:
 
{|style="padding: 10 0 10 0;" width="100%" cellspacing="8" cellpadding="0" valign="top" border="0" |
 
{|style="padding: 10 0 10 0;" width="100%" cellspacing="8" cellpadding="0" valign="top" border="0" |
 
| style="padding:0.3em; text-align:center; color:#000; border-top: 2px solid lightgrey; margin: 0 10px 0 10px; border-bottom: 2px solid orange" width="19%" |  
 
| style="padding:0.3em; text-align:center; color:#000; border-top: 2px solid lightgrey; margin: 0 10px 0 10px; border-bottom: 2px solid orange" width="19%" |  
−
[[IS428 AY2019-20 T1 Business Sparks: Proposal|<font color="#000">PROPOSAL</font>]]
+
[[IS428 AY2019-20 T1 Business Sparks: Proposal V2|<font color="#000">PROPOSAL</font>]]
  
 
| style="padding:0.3em; text-align:center; color:#000; border-top: 2px solid lightgrey; margin: 0 10px 0 10px" width="19%" |  
 
| style="padding:0.3em; text-align:center; color:#000; border-top: 2px solid lightgrey; margin: 0 10px 0 10px" width="19%" |  
Line 22: Line 25:
  
 
<!-- Current Page -->
 
<!-- Current Page -->
−
| style="vertical-align:top;width:49%;" | <div style="padding: 3px; line-height: wrap_content; border-bottom:1px solid lightgrey;"> [[IS428-AY2019-20T1 Business Sparks-Proposal | <font color =#000>Version 1</font>]]
+
| style="vertical-align:top;width:49%;" | <div style="padding: 3px; line-height: wrap_content; border-bottom:1px solid lightgrey;"> [[IS428 AY2019-20 T1 EC Inspector: Proposal | <font color =#000>Version 1</font>]]
  
 
| style="vertical-align:top;width:49%;" | <div style="padding: 3px; line-height: wrap_content; border-bottom:2px solid orange;"> [[IS428 AY2019-20 T1 Business Sparks: Proposal V2 | <font color =#000>'''Version 2'''</font>]]
 
| style="vertical-align:top;width:49%;" | <div style="padding: 3px; line-height: wrap_content; border-bottom:2px solid orange;"> [[IS428 AY2019-20 T1 Business Sparks: Proposal V2 | <font color =#000>'''Version 2'''</font>]]
Line 31: Line 34:
 
__FORCETOC__
 
__FORCETOC__
  
−
After consultations with Prof KAM, we felt that our previous scope of the proposal is too board as online business covers too many aspects. Therefore, we decided to narrow down to the first part our problem statement, which is to explore whether starting a online business in Singapore is getting more difficult. <br>
+
After consultations with Prof KAM, we felt that our previous scope of the proposal is too board and we were not able to find detailed data on cessation of businesses. Therefore, we revised our project topic to inspect on Executive Condominium in Singapore. <br>
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Problem & Motivation</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Problem & Motivation</div> =
−
Singapore is known to be a good test bed for business and innovation. However, with its ability to attract more and more business and innovation, it made decisions on what business to start in Singapore more difficult.
+
'''Executive Condominium''' (EC) is a special type of public housing in Singapore, which is similar to private condominiums in terms of facilities and amenities. Introduced in Q2 1996, it was meant to cater to the  needs of the middle income home buyers; especially young graduates and professionals who can  afford more than a HDB flat but find private property to be out of their reach. For direct purchases from a developer, there is a minimum occupancy period of five years, only after which the EC can be resold or rented for whole. <br>
 +
It has been over 20 years since EC was first introduced. Is it still popular in real estate market in Singapore, or the need for this kind of housing has already been decreasing? How is EC distributed in Singapore? How has the price of EC been changing over the two decades? In this project, we hope to find out the '''real value and status change''' of EC in Singapore since 1996 considering economic factors such as inflation rate through our visualization.
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Datasets</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Datasets</div> =
 
<table>
 
<table>
 
<tr>
 
<tr>
−
<td style="border-bottom: 1px solid #000">Data</td>
+
<td style="border-bottom: 1px solid #000">'''Data'''</td>
−
<td style="border-bottom: 1px solid #000">Variables</td>
+
<td style="border-bottom: 1px solid #000">'''Variables'''</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td style="border-bottom: 1px solid #000">Cessation Of Companies By Industry (SSIC 2015), Monthly<br/>Source: https://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=15948</td>
+
<td style="border-bottom: 1px solid #000">Transactions Records of Executive Condominium since 1996<br/>
 +
Source: SMU Library Database<br> https://spring-ura-gov-sg.libproxy.smu.edu.sg/lad/ore/property_market/index.cfm</td>
 
<td style="border-bottom: 1px solid #000">
 
<td style="border-bottom: 1px solid #000">
 
<ul>
 
<ul>
−
<li>Industry (e.g. Manufacturing, Accommodation)</li>
+
<li>Project Name</li>
−
<li>Time(Year/Month)</li>
+
<li>Address</li>
−
<li>Number of Ceased Companies</li>
+
<li>Unit Price</li>
 +
<li>Sale Date</li>
 +
<li>Type of Sale (i.e. New Sale vs. Resale)</li>
 +
<li>Planning Area (e.g. Punggol)</li>
 
</ul>
 
</ul>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td style="border-bottom: 1px solid #000">ACRA Information on Corporate Entities<br/>Source: https://data.gov.sg/dataset/acra-information-on-corporate-entities</td>
+
<td style="border-bottom: 1px solid #000">Consumer Price Index (CPI), Base Year 2014 = 100, Annual<br/>
 +
Source: https://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=12005</td>
 
<td style="border-bottom: 1px solid #000">
 
<td style="border-bottom: 1px solid #000">
 
<ul>
 
<ul>
−
<li>Uen</li>
+
<li>Year</li>
−
<li>Entity Name</li>
+
<li>CPI for Housing & Utilities</li>
−
<li>Entity Type Description</li>
 
−
<li>Entity Status Description</li>
 
−
<li>Uen Issue Date</li>
 
 
</ul>
 
</ul>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td style="border-bottom: 1px solid #000">Planning Areas in Singapore<br/>
 +
Source: https://data.gov.sg/dataset/planning-area-census2010</td>
 +
<td style="border-bottom: 1px solid #000">
 +
.shp files
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 67: Line 80:
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Background Survey of Related Work</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Background Survey of Related Work</div> =
 +
Please find some related work below:
 +
<br/>
 +
1. https://zuuonline.sg/property/local-properties/executive-condominiums-still-a-value-buy-in-the-current-market
 +
<br/>
 +
2. https://www.propertyinvestsg.com/the-singapore-property-market-in-9-charts/
 +
<br/>
 +
3. https://www.globalpropertyguide.com/Asia/Singapore/Price-History
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Technical Challenges</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Technical Challenges</div> =
 +
{| class="wikitable"
 +
|-
 +
! Challenge !! Type !! Mitigation Plan
 +
|-
 +
| Lack of experience in visualizing with R || Technical || Allocate time in our project schedule for self learning; organize knowledge sharing session on R
 +
|-
 +
| Lack of experience in designing suitable visualizations || Design practices || Research about best practices of visualizing; explore and try out different ways of visualization
 +
|-
 +
| Time limitation and workload allocation || Project management || Arrange meetings and divide work in advance; set a deadline for every member
 +
|}
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Milestones</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Milestones</div> =
Line 74: Line 104:
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">References</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">References</div> =
 +
1. Executive Condominium, from https://en.wikipedia.org/wiki/Executive_Condominium <br>
 +
2. Transactions Records of Executive Condominium since 1996, from https://spring-ura-gov-sg.libproxy.smu.edu.sg/lad/ore/property_market/index.cfm <br>
 +
3. Consumer Price Index (CPI), Base Year 2014 = 100, Annual, from https://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=12005 <br>
 +
4. Planning Areas in Singapore, from https://data.gov.sg/dataset/planning-area-census2010 <br>
 +
5. Orange Tee Research, from https://zuuonline.sg/property/local-properties/executive-condominiums-still-a-value-buy-in-the-current-market <br>
 +
6. Singapore Property Market, from https://www.propertyinvestsg.com/the-singapore-property-market-in-9-charts/ <br>
 +
7. Property Price in Singapore, from https://www.globalpropertyguide.com/Asia/Singapore/Price-History <br>
  
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Comments</div> =
 
= <div style="width: 100%; text-align: center; padding: 10px; background-color: #4db1e8; color: #fff;">Comments</div> =

Latest revision as of 16:01, 23 November 2019

< Back to Project Groups

IS428 AY2019-20 T1 Group4 logo.jpg

PROPOSAL

POSTER

APPLICATION

RESEARCH PAPER



After consultations with Prof KAM, we felt that our previous scope of the proposal is too board and we were not able to find detailed data on cessation of businesses. Therefore, we revised our project topic to inspect on Executive Condominium in Singapore.

Problem & Motivation

Executive Condominium (EC) is a special type of public housing in Singapore, which is similar to private condominiums in terms of facilities and amenities. Introduced in Q2 1996, it was meant to cater to the  needs of the middle income home buyers; especially young graduates and professionals who can  afford more than a HDB flat but find private property to be out of their reach. For direct purchases from a developer, there is a minimum occupancy period of five years, only after which the EC can be resold or rented for whole.
It has been over 20 years since EC was first introduced. Is it still popular in real estate market in Singapore, or the need for this kind of housing has already been decreasing? How is EC distributed in Singapore? How has the price of EC been changing over the two decades? In this project, we hope to find out the real value and status change of EC in Singapore since 1996 considering economic factors such as inflation rate through our visualization.

Datasets

Data Variables
Transactions Records of Executive Condominium since 1996
Source: SMU Library Database
https://spring-ura-gov-sg.libproxy.smu.edu.sg/lad/ore/property_market/index.cfm
  • Project Name
  • Address
  • Unit Price
  • Sale Date
  • Type of Sale (i.e. New Sale vs. Resale)
  • Planning Area (e.g. Punggol)
Consumer Price Index (CPI), Base Year 2014 = 100, Annual
Source: https://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=12005
  • Year
  • CPI for Housing & Utilities
Planning Areas in Singapore
Source: https://data.gov.sg/dataset/planning-area-census2010

.shp files

Background Survey of Related Work

Please find some related work below:
1. https://zuuonline.sg/property/local-properties/executive-condominiums-still-a-value-buy-in-the-current-market
2. https://www.propertyinvestsg.com/the-singapore-property-market-in-9-charts/
3. https://www.globalpropertyguide.com/Asia/Singapore/Price-History

Technical Challenges

Challenge Type Mitigation Plan
Lack of experience in visualizing with R Technical Allocate time in our project schedule for self learning; organize knowledge sharing session on R
Lack of experience in designing suitable visualizations Design practices Research about best practices of visualizing; explore and try out different ways of visualization
Time limitation and workload allocation Project management Arrange meetings and divide work in advance; set a deadline for every member

Milestones

Milestone v2.jpg

References

1. Executive Condominium, from https://en.wikipedia.org/wiki/Executive_Condominium
2. Transactions Records of Executive Condominium since 1996, from https://spring-ura-gov-sg.libproxy.smu.edu.sg/lad/ore/property_market/index.cfm
3. Consumer Price Index (CPI), Base Year 2014 = 100, Annual, from https://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=12005
4. Planning Areas in Singapore, from https://data.gov.sg/dataset/planning-area-census2010
5. Orange Tee Research, from https://zuuonline.sg/property/local-properties/executive-condominiums-still-a-value-buy-in-the-current-market
6. Singapore Property Market, from https://www.propertyinvestsg.com/the-singapore-property-market-in-9-charts/
7. Property Price in Singapore, from https://www.globalpropertyguide.com/Asia/Singapore/Price-History

Comments

Retrieved from ‘https://wiki.smu.edu.sg/1920t1is428g1/index.php?title=IS428_AY2019-20_T1_EC_Inspector:_Proposal_V2&oldid=7773’