G2-Group04 Proposal

HOME

PROPOSAL

POSTER

WEB MAPS

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 Population Density, 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.

By doing so, 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.

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 population density 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 (Prof. Kam)	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	PDF	SMT201_Busines Profiling Project OneDrive Folder (Client)	Matches each POI Facility Description to their POI Facility Type

Higher Resolution: https://tinyurl.com/G2Group4POI

PROJECT SCOPE

PROJECT TIMELINE

Higher Resolution: https://tinyurl.com/G2Group4Timeline