G2-Group13
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).
Through this project, we aim to:
- 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
- Analyse possible other delineated trade areas that our client can possibly consider
- Provide a Multiple Linear Regression (MLR) Model that can best explains the sales performance within Miaoli County and Taichung city
- Create and provide web-based maps that our client can conduct further visualisations without needing to have QGIS installed
The following datasets have been provided by Professor Kam, alongside our client.
| Data Folder Name | Data Format | Data Source | Purpose |
|---|---|---|---|
Admin Boundary
|
Shapefile | Client/Prof Kam | To know outline of Counties, Towns and Villages of Taiwan |
Places of Interest (POI) in Taiwan
|
Shapefile | Client/Prof Kam | To know different types of Places of Interest (POI) in Taiwan |
| Map Releases - Taiwan Release Notes | 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 |
