G2-Group04
|
PROJECT DESCRIPTION |
A Food and Nutrition Board (FNB) International Food Chain is interested in improving their current methods of delineation and analysis.
Using the various functions available on QGIS, we are able to help the FNB business to conduct analysis on the correlation between various factors, such as the Point-Of-Interests (POIs) and Competitors, and the Sales Revenue of the 13 trade areas where this FNB business operates in. At the same time, we are able to advise the FNB business on how to delineate trade areas more efficiently and less tediously.
Also, we aim to optimise the performance of each store located in these trade areas and we hope to highlight the benefits of adopting the QGIS method so that the FNB business can make more informed business decisions in the future based on the insights they have gathered from QGIS and SAS analysis.
|
PROJECT MOTIVATION |
As the FNB business expands, it gets increasingly difficult to accurately keep track of the various factors that affects the business performance. Various factors such as the number of POIs and competitors can affect the human traffic in each of the trade area and should be considered with utmost importance. Hence, using QGIS and SAS Enterprise Guide will be able to provide a much more precise analysis for the outlets in the trade areas.
Also, the current method that has been adopted by the FNB business to delineate the trade areas is Microsoft PowerPoint. This is a less effective approach as compared to using QGIS. Hence, we believe that by utilizing QGIS to digitize and delineate the different trade areas, the analysis process will be less tedious and less time-consuming as the data is being integrated into a single platform and allows for an easier integration for future usage.
This provides the FNB business with a more realistic & better representation of their stores’ environment through the analysis of the data provided by the food chain business and generated by QGIS and SAS Enterprise Guide. This will allow the business to make plans on how to optimise performance for its stores.
|
PROJECT DATA |
| DATA FILE NAME | DESCRIPTION | DATA FORMAT | SOURCE | USAGE |
|---|---|---|---|---|
| GeoPackage | ||||
| Taiwan_stores.gpkg | Contains properties of all 240 Taiwan_stores | GPKG | SMT201_Busines Profiling Project OneDrive Folder (Client) |
Allocation of Stores |
| Location Map | ||||
| CC-20171113 寬65高43(鋁) |
Contains Drive-Time Map of Trade Area CC | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area CC onto QGIS |
| CL-20171113 寬74高75(木)含框 |
Contains Drive-Time Map of Trade Area CL | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area CL onto QGIS |
| GM-20171112 寬70高70(鋁) |
Contains Drive-Time Map of Trade Area GM | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area GM onto QGIS |
| HL-20171112 寬90高60(鋁) |
Contains Drive-Time Map of Trade Area HL | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area HL onto QGIS |
| JI-20190102 寬72高100(鋁)含框 |
Contains Drive-Time Map of Trade Area JI | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area JI onto QGIS |
| KC-20180112 寬93高102(鋁)含框 |
Contains Drive-Time Map of Trade Area KC | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area KC onto QGIS |
| MD-20170606 寬85高60(鋁) |
Contains Drive-Time Map of Trade Area MD | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area MD onto QGIS |
| MH-20171110 寬80高90(鋁) |
Contains Drive-Time Map of Trade Area MH | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area MH onto QGIS |
| MJ-20171031 寬74.5高60(鋁)含框 |
Contains Drive-Time Map of Trade Area MJ | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area MJ onto QGIS |
| RS-20171128 寬74高74(鋁)含框 |
Contains Drive-Time Map of Trade Area RS | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area RS onto QGIS |
| YH-20171112 寬80高55(鋁) |
Contains Drive-Time Map of Trade Area YH | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area YH onto QGIS |
| YJ-20171214 寬62高87(鋁) |
Contains Drive-Time Map of Trade Area YJ | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area YJ onto QGIS |
| YN-20171016 寬60高65(鋁) |
Contains Drive-Time Map of Trade Area YN | PPTX | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference to transfer and digitize Trade Area YN onto QGIS |
| Point-Of-Interests (POIs) | ||||
| V7AM181F0WV7000AACV0 | Contains all 37 POIs | CPG, CSV, DBF, MXD, PRJ, SHP, SHX, Text Document | SMT201_Busines Profiling Project OneDrive Folder (Client) | Imported onto QGIS to conduct POI Analysis |
| Relevant Point-Of-Interests (POIs) | ||||
| metadata | Contains a list of 32 relevant POIs | XLSX | Prof. Kam | Choosing the appropriate POIs for analysis on QGIS |
| Admin Boundary | ||||
| COUNTY_MOI_1080726 | Contains 22 County in Taiwan | SHP | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference layer on QGIS |
| TOWN_MOI_1080726 | Contains 368 Town in Taiwan | SHP | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference layer on QGIS |
| VILLAGE_MOI_121_1080726 | Contains 7679 Village in Taiwan | SHP | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference layer to digitize onto QGIS |
| VILLAGE_MOI_1080726 | Contains 7965 Village in Taiwan | SHP | SMT201_Busines Profiling Project OneDrive Folder (Client) | Reference layer on QGIS |
| Store Sales Data | ||||
| Store_sales_data | Contains Store Sales Data for all 240 stores | CSV | SMT201_Busines Profiling Project OneDrive Folder (Client) | Used for further analysis for each store in each POD and Trade Area |
| Map Release | ||||
| Map Releases - Taiwan (TWN) v181G0 Release Notes | Provides details about version 181G0 of the Map Releases - Taiwan (TWN) Baseline and Feature Introduction Map Products | SMT201_Busines Profiling Project OneDrive Folder (Client) | Matches each POI Facility Description to their POI Facility Type | |
|
PROJECT SCOPE |
|
PROJECT TIMELINE |
