Difference between revisions of "Two Eyes One Pizza"
Line 259: | Line 259: | ||
===#3: Comparison Between Stores=== | ===#3: Comparison Between Stores=== | ||
This dashboard allows the user to compare Store X and Store Y to analyse its Points of Interest (POI), Sales and discover the differences between the two stores. | This dashboard allows the user to compare Store X and Store Y to analyse its Points of Interest (POI), Sales and discover the differences between the two stores. | ||
+ | |||
+ | ===Refer to Application Page for live application=== | ||
+ | [[Two_Eyes_One_Pizza_Application|IFC Application]] | ||
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Comments</font></div>== | ==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Comments</font></div>== |
Revision as of 14:15, 20 November 2019
Contents
Introduction
International Food Chain (IFC) is a leading brand in its sector, with over 18000 outlets worldwide and an ever-growing presence in the global market. In Taiwan alone, IFC has over 240 branches and are constantly expanding.
However, as the franchise grows bigger, so does its challenges. One of the challenges involves the lack of a tool to efficiently compare the performance of each chain to one another.
Leveraging on this fact, our group aims to build a dashboard for IFC that allows for visualization and modeling. We hope to track the performance of each chain in relation to Point-Of-Interests surrounding each chain, uncovering and comprehending phenomena, with the aid of spatial data.
Problem and Motivation
To build a dashboard that allows for:
- Business profiling of the company’s outlet to determine Points-Of-Interests that can generate insights such as: Highest earning outlets, relative performance of outlets, outlet’s profile patterns and item sales information.
- Creating dynamic visualisations to make informed business decisions, such as determining locations for new outlet openings with matching POIs of high sales outlets
- Digitizing of each chain’s trade and delivery area
- Scalable program to incorporate future data to generate current information (Using data from other cities besides Taiwan)
- Easy and intuitive tool to quickly view information with regards to all branches
Objectives
This project aims to provide insights into the following:
- Outlets with the highest monthly sales
- Relative monthly or yearly performance of each outlet
- Each branch geographical information, including the type and number of POI’s in the surroundings
- Profiling of similar types of branches
- Improvements for poor performing outlets
- Scalable system to incorporate future data
Background Survey of Related Works
Visualizations | Explaination |
---|---|
![]()
|
The visualization provides the buffer polygons, as well as representing population density of the area through colour. By comparing the two, we can conclude whether the center of activity is proportional to the population density in a region. It allows us to perform further exploration to see what spatial information significantly affects the level of activity in a city, such as the availability of points-of-interest. This visualization is great as it allows the viewer to clearly see multiple dimensions dealing with spatial data in an elegant way. |
![]()
|
Data source: https://www.researchgate.net/publication/324949619_Visualization_of_Fast_Food_Restaurant_Location_using_Geographical_Information_System |
![]()
|
Data source: https://www.researchgate.net/publication/324949619_Visualization_of_Fast_Food_Restaurant_Location_using_Geographical_Information_System |
![]()
|
Data source: https://www.researchgate.net/publication/324949619_Visualization_of_Fast_Food_Restaurant_Location_using_Geographical_Information_System |
![]()
|
Data source:
https://public.tableau.com/profile/mirandali#!/vizhome/Salesforce-SalesPerformance/SalesPerformance This databoard shows the cumulative sales. We could learn from this and display by outlets to compare the performance by having multiple forms of visualization. We really like the fact that certain key summarizations and variables are displayed on the top, and will consider using this in our project. |
Proposed Storyboard
#1: Title Screen
The title screen indicates the project objectives that the data visualisation tool seeks to achieve on the analysis of IFC Taiwan. As the project focuses on Taiwan branches, an image of Taipei 101 was used as a landing page.
The screens are implemented in a form of single-page website design, where each screen occupies the full screen and is navigated through scrolling action.
#2: Geographical overview
The overview will allow the user to see all respective branches in the map. There will be an option for modes of view e.g (relative sales performance), which builds a thematic map. Hovering or clicking on any branch will allow for a tooltip that displays the information corresponding to the mode.
#3: Sales Overview
This storyboard will provide visualizations for us to quickly identify top branches with high monthly sales. Upon selecting a branch, the monthly sales performance change across the years could be displayed using line graphs. It shows the overall monthly and yearly sales performance of all outlets using bar charts.
#4: Key findings and conclusion
The key findings and conclusion page display the insights that have been gathered from the visualisation tool, which aligns with the objectives of the project. The background of the page signifies the importance of tourist attractions in the selection of new outlets, which plays a big role in maximising the yield for an outlet.
Tools and Libraries
The following tools and libraries are used in the development of the web-based data visualisation application:
- QGIS
- Microsoft Excel
- R Studio
- R Shiny
- Tableau
- Adobe Suite
- Google Drive
Architectural Diagram
The following architectural is used in the implementation of the visualisation tool: The application is deployed through R Shiny with shinyapps.io.
Datasets
These are the datasets we plan to use:
Dataset | Rationale |
---|---|
| |
| |
| |
|
Foreseen Technical Challenges
We encountered the following technical challenges throughout the course of the project. We have indicated our proposed solutions, and the outcomes of the solutions.
Key Technical Challenges | Proposed Solution | Outcome |
---|---|---|
|
NA | |
|
We managed to start using the packages quickly and suit our own project needs. Each of us work on different parts such as setting up, designing, logic and deployment. This speeds up our project progress. | |
|
The adopted process was having clear instructions issued to each member in the team, along with maintaining constant communication with each other. In the event that the dataset is deemed too dirty to be usable, it was dropped along with sourcing for new data that would be a suitable replacement. | |
|
NA | |
|
The data points can better allow us to generate insights on the profile of each outlet via its trade area. | |
|
NA | |
|
NA |
Roles & Milestones
- Project Timeline
- Gantt Chart
References
- Tableau: https://www.tableau.com/learn/training
- R Shiny: https://shiny.rstudio.com/tutorial/
- QGIS: http://www.qgistutorials.com/en/
Ideation Drafts
This area is for iterations of our project proposal
Draft 1 | Draft 2.1 | Draft 2.2 | Draft 3 |
Final Storyboard
#1: IFC Store Sales Overview
This page will allow us to visualize the sales across all stores given a specified date range. It will consist of a choropleth map and bar chart.
#2: Individual IFC Store Information
This page will allow us to look into each IFC Store and visualise the point of interest for the store's subzone. It will also show the store sales with comparison to the median sales of all stores.
#3: Comparison Between Stores
This dashboard allows the user to compare Store X and Store Y to analyse its Points of Interest (POI), Sales and discover the differences between the two stores.
Refer to Application Page for live application
Comments
Feel free to leave comments / suggestions!