G1-Group05 Proposal
Contents
Proposal
About Taipei and Yilan
Taipei, the capital of Taiwan, is the most populated city in Taiwan with around 7 million people in the city and surrounding areas. In contrast, Yilan is a county in northeastern Taiwan. Even though its land area is 8 times the size of Taipei, it has a low population of around 450,000 people. Joining together both counties is Jiang Yushui Expressway (National Freeway 5).
Project Motivation
Our client is part of the International Food and Beverage franchise that is currently present in Taiwan. Our client has provided us with data to analyse each outlet and their respective trade areas have impacted the franchise's business in Taipei and Yilan. By understanding the trade areas of each location better, we can identify what influences the performance of each outlet.
Our project aims to digitise and delineate the trade areas, as well as study the points of interest per area. We can then provide useful information for our client by analysing effect the different points of interests have on sales. This information will allow for more informed business decision-making, especially when assessing the success of their current outlets considering the viability of a potential new outlet location.
Project Objectives
Highway to Taipei aims to achieve the following objectives by the end of the project:
- Digitise and delineate Operational Trade Areas
- Analyse the overlapping trade areas of the outlets
- Extract significant POIs
- Analyse impact of POIs in each trade area of each outlet
- Perform drive time analysis & impact on trade areas
- Create GIS maps for data visualisation
- Summarise findings in a poster & report
About Areas Studied
Our group studied 14 franchise outlets, 9 of which were located in Taipei and 5 in the Yilan region of Taiwan. The areas we received were mostly clustered together. This allows us to take away certain assumptions, and instead focus on seeing how the points-of-interest and trade area properties impact annual sales.
Scope of Work
Our main tool to perform our analyses was QGIS, a free and open-source geographic information system. To support our findings with more in-depth calculations, we used SAS Enterprise Guide.
Data Preparation
- Digitisation of operational trade
- Data Cleaning
- Trade Area Buffer Creation
- Count POI in Polygons
Performing GIS Analysis
- Vector-Based Analysis
- Raster-Based Analysis
- Trade Area Analysis
- Multiple Linear Regression
- POI-Sales Analysis
- Drive Time Analysis
Project Deliverables
- Poster
- Full Report
- Summarised Report
Project Timeline
Data Sources
| Data | Data Format | Data Source | |
|---|---|---|---|
| Admin Boundary | |||
| Country MOI | Shapefile (.shp) | Prof Kam & Client | |
| Town MOI | Shapefile (.shp) | Prof Kam & Client | |
| Village MOI | Shapefile (.shp) | Prof Kam & Client | |
| Taiwan Stores | |||
| Taiwan Stores (inclusive of our 14 stores) | Geopackage (.gpkg) | Prof Kam & Client | |
| Location Maps | |||
| Taiwan Stores (inclusive of our 14 stores) | PowerPoint Slides (.ppt) | Client | |
| Point of Interest (POI) | |||
| ATM | Shapefile (.shp) | Prof Kam & Client | |
| Bank | Shapefile (.shp) | Prof Kam & Client | |
| Bar/Pub | Shapefile (.shp) | Prof Kam & Client | |
| Bookstore | Shapefile (.shp) | Prof Kam & Client | |
| Bowling Centre | Shapefile (.shp) | Prof Kam & Client | |
| Bus Station | Shapefile (.shp) | Prof Kam & Client | |
| Business Facility | Shapefile (.shp) | Prof Kam & Client | |
| Cinema | Shapefile (.shp) | Prof Kam & Client | |
| Clothing Store | Shapefile (.shp) | Prof Kam & Client | |
| Coffee Shop | Shapefile (.shp) | Prof Kam & Client | |
| Commuter Rail Station | Shapefile (.shp) | Prof Kam & Client | |
| Consumer Electronics Store | Shapefile (.shp) | Prof Kam & Client | |
| Convenience Store | Shapefile (.shp) | Prof Kam & Client | |
| Department Store | Shapefile (.shp) | Prof Kam & Client | |
| Government Office | Shapefile (.shp) | Prof Kam & Client | |
| Grocery Store | Shapefile (.shp) | Prof Kam & Client | |
| Higher Education | Shapefile (.shp) | Prof Kam & Client | |
| Hospital | Shapefile (.shp) | Prof Kam & Client | |
| Hotel | Shapefile (.shp) | Prof Kam & Client | |
| Industrial Zone | Shapefile (.shp) | Prof Kam & Client | |
| Medical Service | Shapefile (.shp) | Prof Kam & Client | |
| Nightlife | Shapefile (.shp) | Prof Kam & Client | |
| Performing Arts | Shapefile (.shp) | Prof Kam & Client | |
| Pharmacy | Shapefile (.shp) | Prof Kam & Client | |
| Residential Area/Building | Shapefile (.shp) | Prof Kam & Client | |
| Restaurant | Shapefile (.shp) | Prof Kam & Client | |
| School | Shapefile (.shp) | Prof Kam & Client | |
| Shopping | Shapefile (.shp) | Prof Kam & Client | |
| Speciality Store | Shapefile (.shp) | Prof Kam & Client | |
| Sports Centre | Shapefile (.shp) | Prof Kam & Client | |
| Sports Complex | Shapefile (.shp) | Prof Kam & Client | |
| Train Station | Shapefile (.shp) | Prof Kam & Client | |
| Sales Data | |||
| Trade Area Annual Sales Data | Comma-Separated Values (.csv) | Prof Kam & Client | |
