G2-Group13

PROPOSAL

POSTER

WEB MAPS

PROJECT REPORT

RETURN TO ALL PROJECTS

Project Motivation

Our client is well-established in the food and beverage (F&B) industry internationally and has multiple shop outlets across Taiwan. They are looking to improve their bottom line and would like us to explain the reasons for the difference in sales figures for different franchised outlets, whether factors like nearby presence of entertainment or presence of other food and beverage outlets would affect their sales. Currently, their trade area is done using sketches on maps and cuts through rivers and forested areas. However, as the hand-drawn trade area is static in nature, our client is unable to create any further analysis on their own. Thus, we aim to digitalize their hand-drawn trade areas for further analysis of our client's trade area based on their outlets using Points of Interests (POIs). Our client is looking to maximise their profitability in their franchise outlets by looking into their various trade areas and to determine the best model that can explain the sales performance.

To understand more about the assigned food outlets given to us, we researched on the background information of Miaoli and Taichung to find out more about the geological map of both Miaoli and Taichung.

Miaoli County is a county in the mid-northern cost of western Taiwan and has a population of 548,863 in the whole county. Miaoli City is the capital of the county and known as ‘Mountain Town’ due to the the number of mountains nearby. Miaoli is roughly diamond-shaped in appearance and the overall coastline of Miaoli is 54km long. (https://en.wikipedia.org/wiki/Miaoli_County)

Taichung is a special municipality in central Taiwan with a population of approximately 2.81million and is Taiwan’s 2nd most populated city. It is the core of Taichung-Changhua metropolitan area, which is the second largest in Taiwan. Taichung was formed when Taichung County merged with the provincial Taichung City to form the special municipality in 2010. Taichung has a land area of 2,21490km^2 and the Central Mountain Range lies just to the east of the city and the hills roll up to the north leading to Miaoli County. (https://en.wikipedia.org/wiki/Taichung).

Project Objective

Through this project, we aim to:

1. Digitalised our client’s current trade areas and provide them back with digitalised trade area maps in QGIS which they can conduct their own analysis with
2. Analyse possible other delineated trade areas that our client can possibly consider
3. Provide a Multiple Linear Regression (MLR) Model that can best explains the sales performance within Miaoli County and Taichung city
4. Create and provide web-based maps that our client can conduct further visualisations without needing to have QGIS installed

Project Data

The following datasets have been provided by Professor Kam, alongside our client.

Data Folder Name	Data Format	Data Source	Purpose
Admin Boundary County MOI Town MOI Village MOI	Shapefile	Client/Prof Kam	To know outline of Counties, Towns and Villages of Taiwan
Places of Interest (POI) in Taiwan ATM Bank Bar or Pub Bookstore Bowling Centre Bus Station Business Facility Cinema Clothing Store Coffee Shop Commuter Rail Station Consumer Electronics Store Convenience Store Department Store Government Office Grocery Store Higher Education Hospital Hotel Industrial Zone Medical Service Nightlife Performing Arts Pharmacy Residential Area/ Building Restaurant School Shopping Specialty Store Sports Centre Sports Complex Train Station	Shapefile	Client/Prof Kam	To know different types of Places of Interest (POI) in Taiwan
Map Releases - Taiwan Release Notes	PDF	Client/Prof Kam	Identify the POI based on facility code
Location Map (13 Trade Areas)	PowerPoint Slides	Client/Prof Kam	To know rough guide of trade area of franchise outlets in Taiwan for team to digitalize
GeoPackage (Taiwan Stores)	Geopackage	Client/Prof Kam	Provides outlet location of Franchise Stores

Scope of Work

General Methodology

Key Findings

Reflecting on this project

Project Schedule