Difference between revisions of "IS428 2016-17 Term1 Assign1 Nguyen Duy Loc"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 68: Line 68:
  
  
[[File: activenesssellingbuying.PNG |400px|frame|center]]
+
[[File: activenesssellingbuying.PNG |200px|frame|center]]
  
 
==Infographics==
 
==Infographics==
  
 
==Conclusion==
 
==Conclusion==

Revision as of 16:47, 29 August 2016

Abstract

The market of private properties in 2015 continued to show decline further in term of supply and prices. Would this trend go further into 2016?

The prices on the market is usually determined by supply and demand. From this analysis, we will see how the supply react to the decreasing demand and how responsive is this industry to the market forces.

Problem and Motivation

What are the three patterns of the share of the private properties supply in 2015?

What are the three patterns of the distribution of the private properties prices in 2015?

With reference to the findings, what policy should we implement for 2016.

Approaches

Data Preparation

The data is collected from REALIS by quarter:

- The residential projects data quarter by quarter of 2015

- The residential transactions data monthly of 2015.

Tools Utilized

Tablue 10

QGIS 2.12

Results

Supply

As seen below, the majority of the of the units supply come from condominium category, followed secondly by apartments.


Relativesballon.PNG

However, this dominant category is dropping in term of supply. Clearly, the supply is following the decreasing demand trend for condominiums.

Unitsbytype.PNG

Among the residentials units supplied in 2015, some are planned, some are under-construction and some are complete.

Statusofunits.PNG

To clearly see the trend in demand, we look at how many units are launched during 2015 but unsold. Even though the trend in the number of units is downward, the number of units unsold is upward.

Unitsunsold.PNG

Demand & Prices

The below picture show us the sales throughout all the months of 2015 by planning regions. For North East Region, there is a huge surge during the summer period.

Overall, sales tends to decreases toward the end of the year from November and starts to pick up around March. During the period between March and November, sales fluctuate wildly.

Monthlysales.PNG

Its not always the case where the pricing dictates demand. Still, it is true for North East Region sales during summer when the price plummeted and the sales rocketed up.

Pricingdemand.PNG

One common question always comes to our minds is when to buy and where to buy a house? For instance, I want to buy a condo.

Whenwheretobuy.PNG

However, is it good enough if a person takes the median pricing and gauge the future price of the house? It depends on the distribution of the pricing in that area as well as the property type.

Distributebyregions.PNG

Based on the transactions data, we observe the following distribution of selling/buying activities.


Activenesssellingbuying.PNG

Infographics

Conclusion