Difference between revisions of "G2-Group13"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
Line 32: Line 32:
  
  
Our client is well-established in the food and beverage (F&B) industry internationally and has multiple shop outlets across Taiwan. They 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 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.  
 
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.  
Line 46: Line 46:
 
<div style="width: 95%;">
 
<div style="width: 95%;">
  
Given the 13 outlets assigned to us and to achieve our project objectives, the team has decided to do the following:
+
At the end of the project, we would like to provide our client back with
1) Digitalize the map of trade areas pointed out by client
+
# An MLR Model that can best explain the sales performance within Miaoli and Taichung county
2) Delineate trade area
+
# Web-based QGIS maps that our client can conduct further visualisations with
3) Set buffers of 2.5km, 3km and 3.5km for each trade area
+
# Digitalised maps of current trade area that is hand-drawn
4) Extract various Point of Interests (POI) within the trade area and within the buffers
 
5) Build a network data model around the trade areas.
 
6) Run Multiple Linear Regression (MLR) on the 3 buffer layers, original trade area and network analysis
 
7) Analyzing of MLR results to see how presence of POI can affect sales
 
8) Creating Poster
 
9) Creating of Project Report and Project Artefacts
 
 
 
  
 
</font></div>
 
</font></div>

Revision as of 16:08, 10 November 2019

Cp2banner.png

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

At the end of the project, we would like to provide our client back with

  1. An MLR Model that can best explain the sales performance within Miaoli and Taichung county
  2. Web-based QGIS maps that our client can conduct further visualisations with
  3. Digitalised maps of current trade area that is hand-drawn


Project Data


The following datasets has 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
  1. ATM
  2. Bank
  3. Bar or Pub
  4. Bookstore
  5. Bowling Centre
  6. Bus Station
  7. Business Facility
  8. Cinema
  9. Clothing Store
  10. Coffee Shop
  11. Commuter Rail Station
  12. Consumer Electronics Store
  13. Convenience Store
  14. Department Store
  15. Government Office
  16. Grocery Store
  17. Higher Education
  18. Hospital
  19. Hotel
  20. Industrial Zone
  21. Medical Service
  22. Nightlife
  23. Performing Arts
  24. Pharmacy
  25. Residential Area/ Building
  26. Restaurant
  27. School
  28. Shopping
  29. Specialty Store
  30. Sports Centre
  31. Sports Complex
  32. 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


Stores.png
G2group13scope.png



Project Schedule


link = timeline_g2g13