Difference between revisions of "Three horrible guys Poster"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
Line 31: Line 31:
  
 
[[File:G1 G1 lowerRes Poster.jpg|1000px|center]]
 
[[File:G1 G1 lowerRes Poster.jpg|1000px|center]]
 
 
 
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Missing Area Analysis</font></div>==
 
<div style="font-family:Helvetica;font-size:16px">
 
As we observe the generated trade areas, it seems there are some areas which are not covered by any of the branches. Hence, we decided to analyse these areas.
 
[[File:q1.png|300px|center]]
 
<center>''Missing area 1''</center>
 
<br/>
 
In the above figure, the uncovered area is 大安森林公园 which is a park. As it is not common to order an IFC product to a park, being uncovered is to be expected.
 
[[File:q2.png|300px|center]]
 
<center>''Missing area 2''</center>
 
<br/>
 
In the above figure, we do see buildings that are not in any trade area. Therefore, this uncovered area may have been omitted and should be fulfilled by one of the branches.
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Store Sales Analysis</font></div>==
 
<div style="font-family:Helvetica;font-size:16px">
 
The yearly store sales of IFC located in Taiwan range from USD$6,809,445 - $13,863,637, with the branch YT being the lowest, and the branch MA having the highest sales. The median sales is branch SS, with USD$9597893.5
 
[[File:q6.png|800px|center]]
 
<center>''Thematic map of overall Sales''</center>
 
<br/>
 
Based on the following thematic map, we can see that the top performers are branches YW,MA,CA and the branches WT,CR,YT are the worst performers. Our recommendation in this case would be to look at the factors surrounding the top performers and apply said factors to the worst performers in order to boost their sales.
 
[[File:q9.png|800px|center]]
 
<center>''Thematic map showing areas above/below median sales''</center>
 
<br/>
 
The map above reveals an interesting pattern, where the northern stores perform better than southern stores. Our suggestion would be to look at location based factors, such as type of buildings (residential/office) and see whether they vary between areas. It is also possible to look at connectivity with regards to road types, and see if accessibility is a problem for some stores.
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Total Delivery Analysis</font></div>==
 
[[File:q12.png|800px|center]]
 
<center>''Thematic map for delivery sales''</center>
 
<br/>
 
Unsurprisingly, having a high delivery count leads to higher sales when compared to the sales thematic map . This is possible as unlike a store where products are priced with vastly different ranges E.g. $5, $5000, the price range of IFC products are roughly the same. Although there might be orders which are of higher value, it seems these orders do not affect the sales amount by much. The exception to this is the area ST, where although it has a comparable delivery count to areas that perform better than the median, it is still slightly behind in sales.
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Population Density Analysis</font></div>==
 
[[File:q15.png|800px|center]]
 
<center>''Thematic map showing normalized population density''</center>
 
<br/>
 
From the above charts where we analyse the normalized population density, we can see that most stores have a high population density. However, when compared to the thematic map of sales,  it seems that population density has little to no relation; having a higher population density does not necessarily mean higher sales.
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Buffer Analysis</font></div>==
 
Buffer Analysis was performed to evaluate the proximity of each IFC.
 
[[File:q18.png|800px|center]]
 
<center>''Map showing 500m buffer and competitors''</center>
 
<br/>
 
Based on the 500m buffer, we can see that there are 3 overlapping pairs of stores:
 
* WT,KT
 
* CA,SS
 
* KF,HH
 
[[File:q19.png|800px|center]]
 
<center>''Map showing 1000m buffer and competitors''</center>
 
<br/>
 
In the 1000m buffer, we can see all stores have some form of overlap with each other.
 
[[File:q21.png|800px|center]]
 
<center>''Map showing 500m & 1000m buffers and competitors''</center>
 
<br/>
 
When we overlay the two maps, we can see that the overall proximity of IFC stores to each other in Taipei is rather close. This has interesting implications, as some competitors might affect multiple stores due to the close proximities.
 
 
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Nearest Competitor to Store Analysis</font></div>==
 
[[File:q22.png|800px|center]]
 
<center>''Map depicting nearest competitor to store''</center>
 
<br/>
 
Based on our findings in the buffer analysis where there are some competitors in close proximity to multiple stores, we decided to map each individual competitor to the nearest IFC store to give a more accurate representation of the competition. Through this, we can find competitors that are in different trade areas but are actually closer to a particular IFC store.
 
[[File:q23.png|800px|center]]
 
<center>''Example of incorrect competitor''</center>
 
<br/>
 
As it turns out, there are a few competitors that are “incorrect” in areas KT and YW, denoted by the black circles in the map above. Our suggestion is to recalibrate each store’s competitors with some consideration to absolute distance, rather than to just consider the competitors located in the trade area each IFC store is located in.
 

Latest revision as of 19:42, 22 November 2019