Difference between revisions of "G1-Group15"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
Line 27: Line 27:
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Motivation</b></font></div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Motivation</b></font></div>
  
−
<div style="text-align: left;>Our client has multiple resturants across taiwan and each store has varied success across the island. Our client suggests that the differences in store successes can be linked to the different points of interests (POI) in the store vicinity.  
+
<div style="text-align: left;>
 +
<br />
 +
Our client is a global brand in the Food and Beverage industry. As the number of its stores grows bigger, it urgently needs a way to analyze the performance of its stores in different trade areas. Therefore, our team aims to perform in-depth analysis on each trade area of its stores and uncover the relationship between its stores' performance and the Point of Interest around each stores.
 +
<br />
  
−
Therefore, our client wishes to derive insights from profiling trade areas of individual stores, to better understand the characteristics of a trade area that contribute to better sales. Our team is given 13 out of the 240 stores in Taiwan, all 13 located in Taipei.
 
−
 
−
We began by digitising and delineating the existing operational trade areas, before analysing the POIs within these trade areas, and comparing the characteristics of stores with high sales volume to that of stores with low sales volume, to generate insights for our client. In the future, our client can look for areas with similar favourable characteristics to consider opening a new store there.
 
 
</div>
 
</div>
  
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Objectives</b></font></div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Project Objectives</b></font></div>
−
<div style="text-align: left;>The objective of our project is to conduct an analysis on 13 stores in Taiwan to give useful insights that will aid us in creating an effective business strategy. All 13 stores are located within New Taipei City, and the respective trade areas cover majority of the city. In our analysis, our aim is to find any correlation between the sales of each store with POIs within their trade areas. We would compare the stores with higher sales with the stores with lower sales to identify which POIs in the trade areas that best explain the difference in sales. Based on our findings, we would make recommendations to our client.
+
<div style="text-align: left;>
 +
<br />
 +
Our objective is to conduct trade area analysis on 13 stores located in New Taipei city by using QGIS and discover insights that can be used in designing business strategies, optimizing the performance of the stores and planning the location of new stores in the future. In our analysis, we aim to uncover any correlation between the sales of each store with POIs within their trade areas. We will also allocate a POI score to each POI to find out which trade area has more potential customers, this insight will be used to plan the location of new stores and reallocation of the boundary of trade areas. Base
 +
 
 
</div>
 
</div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Data Collection</b></font></div>
 
<div style="background: #4FD989; padding: 20px; line-height: 0.3em; text-indent: 0px;letter-spacing:0.01em;font-size:26px"><font color=#000000 face="Arial"><b>Data Collection</b></font></div>
Line 122: Line 125:
 
  shown in the map below.
 
  shown in the map below.
 
[[File:Wiki scope final.jpg|760px|center]]
 
[[File:Wiki scope final.jpg|760px|center]]
−
 
−
 
−
<div style="text-align: left;>The 28 chosen Points of Interests are as follows:</div>
 
−
{| style="text-align: center;left;background: #093066; color: white; width: 30%;"
 
−
! style="width: 35px;" | POIs
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|1. ATM, 3578
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|2. BANK, 6000
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|3. BAR OR PUB, 9532
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|4. BOOKSTORE, 9995
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|5. BOWLING CENTRE, 7933
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|6. BUS STATION, 4170
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|7. BUSINESS FACILITY, 5000
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|8. CINEMA, 7832
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|9. CLOTHING STORE, 9537
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|10. COFFEE SHOP, 9996
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|11. COMMUTER RAIL STATION, 4100
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|12. CONSUMER ELECTRONICS STORE, 9987
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|13. CONVENIENCE STORE, 9535
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|14. DEPARTMENT STORE, 9545
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|15. GOVERNMENT OFFICE, 9525
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|16. GROCERY STORE, 5400
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|17. HIGHER EDUCATION, 8200
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|18. HOSPITAL, 8060
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|19. HOTEL, 7011
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|20. MEDICAL SERVICE, 9583
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|21. PHARMACY, 9565
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|22. RESIDENTIAL AREA/BUILDING, 9590
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|23, RESTAURANT, 5800
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|24. SCHOOL, 8211
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|25. SHOPPING, 6512
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|26. SPORTS CENTRE, 7997
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|27. SPORTS COMPLEX, 7940
 
−
|-style="text-align: left; text-indent: 15px;background: white; color: black"
 
−
|28. TRAIN STATION, 4013
 
−
|}
 
  
  

Revision as of 10:14, 21 October 2019

Home

Proposal

Poster

Web Maps

Project Report


Project Motivation


Our client is a global brand in the Food and Beverage industry. As the number of its stores grows bigger, it urgently needs a way to analyze the performance of its stores in different trade areas. Therefore, our team aims to perform in-depth analysis on each trade area of its stores and uncover the relationship between its stores' performance and the Point of Interest around each stores.

Project Objectives


Our objective is to conduct trade area analysis on 13 stores located in New Taipei city by using QGIS and discover insights that can be used in designing business strategies, optimizing the performance of the stores and planning the location of new stores in the future. In our analysis, we aim to uncover any correlation between the sales of each store with POIs within their trade areas. We will also allocate a POI score to each POI to find out which trade area has more potential customers, this insight will be used to plan the location of new stores and reallocation of the boundary of trade areas. Base

Data Collection
Data File Description Data Format Purpose
GeoPackage
Taiwan_stores Contains geo-coded stores .gpkg Find location of our stores
Administrative Boundaries
County MOI Contains county area .shp Show boundary
Town MOI Contains town area .shp Show boundary
Location Maps
AE-20190313寬100高等比(鋁)含框參觀版 Trade area of store .pptx Used to find POIs inside
PF-20171122寬62高103(鋁) Trade area of store .pptx Used to find POIs inside
TU-20171128寬83高53(鋁) Trade area of store .pptx Used to find POIs inside
UM-20171212寬80高67.2(木)含框 Trade area of store .pptx Used to find POIs inside
AK-20190402寬90高等比(鋁)實際版 Trade area of store .pptx Used to find POIs inside
GH-20171121寬90高70(鋁) Trade area of store .pptx Used to find POIs inside
HT-20150407寬90高115(木) Trade area of store .pptx Used to find POIs inside
MQ-20171120寬70高70(鋁)含框 Trade area of store .pptx Used to find POIs inside
SH-20171128寬84高76(鋁)含框 Trade area of store .pptx Used to find POIs inside
TC-20171129寬121高92(木)含框 Trade area of store .pptx Used to find POIs inside
TR-20171128寬70高70(鋁) Trade area of store .pptx Used to find POIs inside
XS-20171129寬63高93(木) Trade area of store .pptx Used to find POIs inside
YG-20171128寬92高92(鋁) Trade area of store .pptx Used to find POIs inside
Points of Interest
Business Contains locations of businesses .shp Used for analysis
CommSvc Contains locations of community service facilities .shp Used for analysis
EduInsts Contains locations of education institutions .shp Used for analysis
Entertn Contains locations of entertainment facilities .shp Used for analysis
FinInsts Contains locations of financial institutions .shp Used for analysis
Hospital Contains locations of medical facilities .shp Used for analysis
MiscCategories Contains locations of miscellaneous amenities .shp Used for analysis
ParkRec Contains locations of parks and recreational areas .shp Used for analysis
Restrnts Contains locations of restaurants .shp Used for analysis
Shopping Contains locations of shopping malls .shp Used for analysis
TransHub Contains locations of transport hubs .shp Used for analysis
TravDest Contains locations of travel destinations .shp Used for analysis


Scope Of Work

Our team has been allocated 13 Stores in New Taipei City 

shown in the map below.
Wiki scope final.jpg


Project Schedule


ProjectSchedule.png
Retrieved from ‘https://wiki.smu.edu.sg/1920t1smt201/index.php?title=G1-Group15&oldid=5451’