Difference between revisions of "G1-Group15"
Jump to navigation
Jump to search
| Line 42: | Line 42: | ||
</div> | </div> | ||
<br /> | <br /> | ||
| − | <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> |
{| class="wikitable" style="color:black; background-color:#FCF9F9;" | {| class="wikitable" style="color:black; background-color:#FCF9F9;" | ||
Revision as of 19:07, 21 October 2019
.png)
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 of each trade area of its stores and uncover the relationship between its stores' performance and Point of Interests in its trade area.
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 | Allocation of 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 | Reference Layer for Digitising |
| PF-20171122寬62高103(鋁) | Trade area of store | .pptx | Reference Layer for Digitizing |
| TU-20171128寬83高53(鋁) | Trade area of store | .pptx | Reference Layer for Digitizing |
| UM-20171212寬80高67.2(木)含框 | Trade area of store | .pptx | Reference Layer for Digitizing |
| AK-20190402寬90高等比(鋁)實際版 | Trade area of store | .pptx | Reference Layer for Digitizing |
| GH-20171121寬90高70(鋁) | Trade area of store | .pptx | Reference Layer for Digitizing |
| HT-20150407寬90高115(木) | Trade area of store | .pptx | Reference Layer for Digitizing |
| MQ-20171120寬70高70(鋁)含框 | Trade area of store | .pptx | Reference Layer for Digitizing |
| SH-20171128寬84高76(鋁)含框 | Trade area of store | .pptx | Reference Layer for Digitizing |
| TC-20171129寬121高92(木)含框 | Trade area of store | .pptx | Reference Layer for Digitizing |
| TR-20171128寬70高70(鋁) | Trade area of store | .pptx | Reference Layer for Digitizing |
| XS-20171129寬63高93(木) | Trade area of store | .pptx | Reference Layer for Digitizing |
| YG-20171128寬92高92(鋁) | Trade area of store | .pptx | Reference Layer for Digitizing |
| Points of Interest | |||
| Business | Contains locations of businesses | .shp | Type of facility that will be used for analysis |
| CommSvc | Contains locations of community service facilities | .shp | Type of facility that will be used for analysis |
| EduInsts | Contains locations of education institutions | .shp | Type of facility that will be used for analysis |
| Entertn | Contains locations of entertainment facilities | .shp | Type of facility that will be used for analysis |
| FinInsts | Contains locations of financial institutions | .shp | Type of facility that will be used for analysis |
| Hospital | Contains locations of medical facilities | .shp | Type of facility that will be used for analysis |
| MiscCategories | Contains locations of miscellaneous amenities | .shp | Type of facility that will be used for analysis |
| ParkRec | Contains locations of parks and recreational areas | .shp | Type of facility that will be used for analysis |
| Restrnts | Contains locations of restaurants | .shp | Type of facility that will be used for analysis |
| Shopping | Contains locations of shopping malls | .shp | Type of facility that will be used for analysis |
| TransHub | Contains locations of transport hubs | .shp | Type of facility that will be used for analysis |
| TravDest | Contains locations of travel destinations | .shp | Type of facility that will be used for analysis |
Scope Of Work
Our team has been allocated 13 Stores in New Taipei City (shown in the map below)
The table below shows the relevant facility types extracted from POI files
| Relevant Facility Type from POIs | |||
|---|---|---|---|
| ATM, 3578 | GOVERNMENT OFFICE, 9525 | ||
| BANK, 6000 | GROCERY STORE, 5400 | ||
| BAR OR PUB, 9532 | HIGHER EDUCATION, 8200 | ||
| BOOKSTORE, 9995 | HOSPITAL, 8060 | ||
| BOWLING CENTRE, 7933 | HOTEL, 7011 | ||
| BUS STATION, 4170 | MEDICAL SERVICE, 9583 | ||
| BUSINESS FACILITY, 5000 | PHARMACY, 9565 | ||
| CINEMA, 7832 | RESIDENTIAL AREA/BUILDING, 9590 | ||
| CLOTHING STORE, 9537 | RESTAURANT, 5800 | ||
| COFFEE SHOP, 9996 | SCHOOL, 8211 | ||
| COMMUTER RAIL STATION, 4100 | SHOPPING, 6512 | ||
| CONSUMER ELECTRONICS STORE, 9987 | SPORTS CENTRE, 7997 | ||
| CONVENIENCE STORE, 9535 | SPORTS COMPLEX, 7940 | ||
| DEPARTMENT STORE, 9545 | TRAIN STATION, 4013 | ||
Project Schedule
