Difference between revisions of "Unicorn Ventures"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(6 intermediate revisions by the same user not shown)
Line 8: Line 8:
  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border-bottom:0px solid #FF5A60 ; background:#FF5A60 ; text-align:center;" width="16.6%" |  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border-bottom:0px solid #FF5A60 ; background:#FF5A60 ; text-align:center;" width="16.6%" |  
[[IS428_2018_19T1_Group08_Team| <font color="#fff">TEAM</font>]]
+
[[IS428 2018-19 T1 Group 03 Unicorn Ventures: Team| <font color="#fff">TEAM</font>]]
 
| &nbsp;
 
| &nbsp;
  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border-bottom:0px solid #FF5A60 ; background:#252320; text-align:center;" width="16.6%" |  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border-bottom:0px solid #FF5A60 ; background:#252320; text-align:center;" width="16.6%" |  
[[IS428_2018_19T1_Group08_Proposal | <font color="#FFF">PROPOSAL</font>]]
+
[[IS428 2018-19 T1 Group 03 Unicorn Ventures: Proposal | <font color="#FFF">PROPOSAL</font>]]
 
| &nbsp;
 
| &nbsp;
  
 
| style="font-family:Century Gothic; font-size:85%; solid FF5A60 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
 
| style="font-family:Century Gothic; font-size:85%; solid FF5A60 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
[[IS428_2018_19T1_Group08_Poster | <font color="#fff">POSTER</font>]]
+
[[IS428 2018-19 T1 Group 03 Unicorn Ventures: Poster | <font color="#fff">POSTER</font>]]
 
| &nbsp;
 
| &nbsp;
  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
[https://github.com/atwj/IS428-UNICORN-VENTURES <font color="#FFFFFF">APPLICATION</font>]
+
[https://is428-ay2018-2019-unicorn-ventures.shinyapps.io/application/ <font color="#FFFFFF">APPLICATION</font>]
 
| &nbsp;
 
| &nbsp;
  
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
 
| style="font-family:Century Gothic; font-size:85%; solid #f48024 ; border:0px solid #FF5A60 background:#FF5A60;  background:#FF5A60; text-align:center;" width="16.6%" |
[[IS428 2018_19T1_Group08 Report  | <font color="#FFFFFF">RESEARCH PAPER</font>]]
+
[[IS428 2018-19 T1 Group 03 Unicorn Ventures: Report  | <font color="#FFFFFF">RESEARCH PAPER</font>]]
 
| &nbsp;
 
| &nbsp;
 
|}
 
|}
[[IS428_2018_19T1_Group08_Proposal-version1 | <font color="#000">Version 1</font>]] | [[IS428_2017_18T1_Group01_Proposal | <font color="#000">Version 2</font>]]
+
[[IS428 2018-19 T1 Group 03 Unicorn Ventures: Proposal Version 1 | <font color="#000">Version 1</font>]] | [[IS428 2018-19 T1 Group 03 Unicorn Ventures: Proposal | <font color="#000">'''Version 2'''</font>]]
 
<br>
 
<br>
  
Line 41: Line 41:
  
 
<br />
 
<br />
Our research is motivated by the lack of comprehensive comparison between these two countries’ startup ecosystem. Currently, there are many sources of fragmented datasets on different aspects of the startup ecosystem such as top-funded companies, industry breakdown and funding analysis. Our project aims to consolidate the data sources and study the two different startup ecosystems through a centralized interactive web application.
+
As there is a general lack of effective and user-friendly visualization for discovering country-specific differences between the start-up ecosystems, the main motivation behind this project is to create a centralized, dynamic and interactive dashboard for quantitative comparisons on various aspects of start-ups and funding organizations in Singapore and Hong Kong. Based on User-Centric Dashboard Design Guide, this dashboard takes a broad, strategic, customizable, drillable and exploratory approach and is targeted at potential entrepreneurs, policy makers and investors.
 +
This project will focus on start-up companies and funding organizations in the tech ecosystem. The insights generated could help:
 +
*Enable potential entrepreneurs to understand the growing and declining industries, investors’ profile as well as pinpoint the top funded start-ups
 +
*Help policy makers to identify the potential profitable and leading industries and dedicate more resources in specific industries
 +
*Assist investors in identifying the difference between Singapore and Hong Kong’s start-up industries and strategizing future investments in these two regions
  
This project will focus on start-up companies and funding organizations in the tech ecosystem. The insights generated could help:
 
*Hong Kong and Singapore policy makers improve its existing infrastructures or policies to cultivate a more robust startup ecosystem
 
*Potential and current founders to understand the growing industries, competitor landscape and investors
 
*Potential investors to identify the growing industries and dominant players
 
 
<br />
 
<br />
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">OBJECTIVES</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">OBJECTIVES</font></div>
 
<br>
 
<br>
Our project aims to explore and compare the following aspects for the startup
+
Our project aims to explore and compare the following aspects for the start-up ecosystem in Singapore and Hong Kong by considering the start-ups founded after 2000. We hope to address the following questions
ecosystem in Singapore and Hong Kong by considering the startups founded after  
+
For Entrepreneurs:
2000.
+
*Time-series analysis: When was the start-ups founded, exited and funded?
 +
*Funding Analysis: Discovering the top funded start-ups
 +
*Spatial Analysis: Where do the investors originate from?
 +
For Policy Makers/Investors:
 +
*Profile Analysis: What are the differences in terms of start-up formation across the years?
 +
*Industry Analysis: Comparing the start-ups in various industries and sectors based on different performance indicators
  
Ecosystem Index Analysis:
 
*What is the difference of Hong Kong and Singapore in terms of Global Entrepreneurship Index and Global Competitiveness Index?
 
Startup Analysis:
 
*Time-series analysis for startups that has formed/exited across the years by different industries
 
*What is the current breakdown of startups by industries, key industries, team size, funding stage, age and gender of founders?
 
Funding Analysis:
 
*What are top funded startups and their funding stages and industries?
 
*Time-series analysis of the disclosed funding over the years by industries
 
*Where does the investors originate from and what are the investor types?
 
 
</br>
 
</br>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">SELECTED DATASET</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">SELECTED DATASET</font></div>
Line 69: Line 65:
 
! Dataset
 
! Dataset
 
|-
 
|-
 +
 
|
 
|
<p><center>'''Global Entrepreneurship Index Score in Singapore and Hong Kong in 2018''' </center></p>  
+
<p><center>'''Basic Startup Information in Singapore and Hong Kong''' </center></p>  
*Description: The GEI measures both the quality of entrepreneurship in a country and the extent and depth of the supporting entrepreneurial ecosystem. The GEI consistsof 3 sub-indices including entrepreneurial attitudes, entrepreneurial abilities and entrepreneurial aspirations.
+
*Description: This dataset includes various key attributes on startups in Singapore and Hong Kong that was founded after 2000.  
*Source: Global Entrepreneurship and Development Institute
+
*Source: [https://www.crunchbase.com/search/organization.companies/a7600f0093365b7c1eb51e6325036762f5a19635 Crunchbase]
*[https://thegedi.org/wp-content/uploads/dlm_uploads/2017/11/GEI-2018-1.pdf Dateset]  
+
*[https://drive.google.com/open?id=1y0lhzu9b1CD4hRvORNhakkraBorUBmiX Dataset]
 
*Components:
 
*Components:
 +
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
! Sub-index
+
 
! Attributes
+
! Field
 +
! Type
 +
! Description
 
|-
 
|-
| style="text-align: center;" | Attitudes Sub-index
+
| style="text-align: center;" | Organization Name
 +
 
 +
|String
  
|
+
|Organization Name
*Opportunity Perception
+
|-
*Startup Skills
+
|-
*Risk Acceptance
+
| style="text-align: center;" | Categories
*Networking
+
|String
*Cultural Support
+
|Industry the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Sub Category 1
 +
|String
 +
|Sub category the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Sub Category 1
 +
|String
 +
|Sub category the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Headquarter Location
 +
|String
 +
|Organization headquarter location
 +
|-
 +
|-
 +
| style="text-align: center;" | Description
 +
|String
 +
|Organization description
 +
|-
 
|-
 
|-
 +
| style="text-align: center;" | Founded_Date
 +
|String
 +
|Organization founding date
 
|-
 
|-
| style="text-align: center;" | Abilities Sub-index
 
 
|
 
*Opportunity Perception
 
*Technology Absorption
 
*Human Capital
 
*Competition
 
 
|-
 
|-
 +
| style="text-align: center;" | Exit Date
 +
|String
 +
|Organization exit date
 
|-
 
|-
| style="text-align: center;" | Aspiration Sub-index
 
 
|
 
*Product Innovation
 
*Process Innovation
 
*High Growth
 
*Internationalization
 
*Risk Capital
 
 
|-
 
|-
|}
+
| style="text-align: center;" | Last Funding Date
 +
|Date
 +
|Last Funding Date
 
|-
 
|-
|
 
<p><center>'''Global Competitiveness Index 2017-2018 for Singapore and Hong Kong''' </center></p>
 
*Description: It measures national competitiveness which is defined as the set of institutions, policies and factors that determine the level of productivity.
 
*Source: World Economic Forum
 
*[http://www3.weforum.org/docs/GCR2017-2018/05FullReport/TheGlobalCompetitivenessReport2017%E2%80%932018.pdf Dataset]
 
*Components:
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
! Sub-index
 
! Attributes
 
 
|-
 
|-
| style="text-align: center;" | Basic Requirements Sub-index
+
| style="text-align: center;" | Last Funding Type
 
+
|String
|
+
|Last Funding Type
*Institutions
 
*Infrastructure
 
*Macroeconomic environment
 
*Health and primary education
 
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" | Efficiency Enhancers Sub-index
+
| style="text-align: center;" | Last Funding Amount Currency (in USD)
 
+
|String
|
+
|Last Funding Amount in USD
*Higher education and training
 
*Goods market efficiency
 
*Labour market efficiency
 
*Financial market development
 
*Technological readiness
 
*Market Size
 
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" | Innovation and Sophistication Factors Sub-index
+
| style="text-align: center;" | Total Funding Amount Currency in USD
 
+
|String
|
+
|Total Funding Amount in USD
*Business sophistication
 
*Innovation
 
 
|-
 
|-
 
|}
 
|}
 
|-
 
|-
 
|
 
|
<p><center>'''Startup Information in Singapore and Hong Kong''' </center></p>  
+
<p><center>'''Investment and Funding Information in Singapore and Hong Kong ''' </center></p>  
*Description: This dataset includes various key attributes on startups in Singapore and Hong Kong that was founded after 2000.  
+
*Description: This dataset details the individual disclosed funding transactions that are public and are published in crunchbase.
*Source: [https://www.crunchbase.com/search/organization.companies/a7600f0093365b7c1eb51e6325036762f5a19635 Crunchbase]  
+
*Source: [https://www.crunchbase.com/search/funding_rounds/635cbd9bcafca178f043955a5ddebe9b5603acaa Crunchbase]  
*[https://drive.google.com/file/d/1IyfxqDqOCmQ4c4wahW0u6ONrfJE-J3nh/view?usp=sharing Dataset]
+
*[https://drive.google.com/open?id=1XTr_kgsya8LDM4GjuM1S7k4vGAmfSVeg Dataset]
 
*Components:
 
*Components:
  
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
! Information Type
+
! Field
! Attributes
+
! Type
 +
! Description
 
|-
 
|-
| style="text-align: center;" | Basic Information
+
| style="text-align: center;" | Transaction Name
 +
 
 +
|String
  
|
+
|Auto-generated name of transaction (e.g. Angel-Uber)
*Organization Name
 
*Categories
 
*Category Groups
 
*Headquarters Location
 
*Operating Status
 
*Founded Date
 
*Exit Date
 
*Closed Date
 
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" | Team
+
| style="text-align: center;" | Organization Name
 +
 
 +
|String
  
|
+
|Name of the organization that got funded.
*Number of Founders
+
|-
*Female_Founder
+
|-
*Founders
+
| style="text-align: center;" | Categories
*Number of Employees
+
|String
 +
|Industry the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Location
 +
|String
 +
|Location of the organization that got funded
 +
|-
 +
|-
 +
| style="text-align: center;" | Funding Type
 +
|String
 +
|Type of Funding Round (e.g. Seed, Series A, Private Equity, Debt Financing)
 +
|-
 +
|-
 +
| style="text-align: center;" | Money Raised Currency (in USD)
 +
|Integer
 +
|Amount of money raised in Funding Round
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" | Funding
+
| style="text-align: center;" | Announced Date
|
+
|Date
*Number of Funding Rounds
+
|Date that the Funding Round was publicly anounced
*Funding Status
 
*Last Funding Date
 
*Last Funding Amount Currency (in USD)
 
*Last Funding Type
 
*Last Equity Funding Amount Currency (in USD)
 
*Last Equity Funding Type
 
*Total Equity Funding Amount Currency (in USD)
 
*Total Funding Amount Currency (in USD)
 
*Number of Lead Investors
 
*Number of Investors
 
*Number of Acquisition
 
*Acquisition Status
 
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" |IPO and Stock Price
+
| style="text-align: center;" | Funding Stage
|
+
|String
*IPO Status
+
|The funding stage of a funding round
*IPO Date
 
*Stock Symbol
 
*Stock Exchange
 
 
|-
 
|-
 +
 
|}
 
|}
 
|-
 
|-
 
|
 
|
<p><center>'''Investment and Funding Information in Singapore and Hong Kong ''' </center></p>  
+
<p><center>'''Investor Information in Singapore and Hong Kong ''' </center></p>  
*Description: This dataset details the individual disclosed funding transactions that are public and are published in crunchbase.
+
*Description: This dataset shows the investor locations and number of investments made by the investors .
*Source: [https://www.crunchbase.com/search/funding_rounds/635cbd9bcafca178f043955a5ddebe9b5603acaa Crunchbase]  
+
 
*[https://drive.google.com/file/d/1YRCa5ssjA4Y8k75mvrMSBHYu2YgT_jYX/view?usp=sharing Dataset]
+
*Source: [https://www.crunchbase.com/search/principal.investors/6803113d3482513cb2152ca68c002ad6501dd7c7 Crunchbase]  
 +
*[https://drive.google.com/open?id=1Cy7HH-1gCbh8CIQHYAjhFw1cBcT5IkHM Dataset]
 
*Components:
 
*Components:
  
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
! Information Type
+
! Field
! Attributes
+
! Type
 +
! Description
 
|-
 
|-
| style="text-align: center;" | Deal Information
+
| style="text-align: center;" | Location
  
|
+
|String
*Transaction Name
+
 
*startup Organization Name
+
|Investor locations
*Funding Type
+
|-
*Money Raised Currency (in USD)
+
|-
*Announced Date
+
| style="text-align: center;" | Lat
*Funding Stage
+
 
*Equity Only Funding
+
|Double
 +
 
 +
|Latitude of the location
 +
|-
 
|-
 
|-
 +
| style="text-align: center;" | Categories
 +
|Double
 +
|Longitude of the location
 
|-
 
|-
| style="text-align: center;" | Investors
 
|
 
*Number of Investors
 
*Number of Partner Investors
 
 
|-
 
|-
 +
| style="text-align: center;" | Number_of_Investments
 +
|Integer
 +
|Number of investments made by investors from the location
 
|-
 
|-
 
|}
 
|}
 
|-
 
|-
 
|
 
|
<p><center>'''Investor Information in Singapore and Hong Kong ''' </center></p>  
+
<p><center>'''Other Startup Information in Singapore and Hong Kong''' </center></p>  
*Description: This dataset shows  the current breakdown of the profile of the investors that had invested in Singapore/Hong Kong startups. However, this data set does not disclose the individual transaction due to privacy policy .
+
*Description: This dataset includes other attributes on startups in Singapore and Hong Kong that was founded after 2000.  
 
+
*Source: [https://www.crunchbase.com/search/organization.companies/a7600f0093365b7c1eb51e6325036762f5a19635 Crunchbase]  
*Source: [https://www.crunchbase.com/search/principal.investors/6803113d3482513cb2152ca68c002ad6501dd7c7 Crunchbase]  
+
*[https://drive.google.com/open?id=1sYx1lezHo9KyTFD5l6M8GPgE1nuPk001 Dataset]
*[https://drive.google.com/file/d/1pXDBx_OPE6EZ8pei1AcKkjxVDyBH8jcC/view?usp=sharing Dataset]
 
 
*Components:
 
*Components:
  
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
! Information Type
+
 
! Attributes
+
! Field
 +
! Type
 +
! Description
 
|-
 
|-
| style="text-align: center;" | Basic Information
+
| style="text-align: center;" | Organization Name
  
|
+
|String
*Organization/Person Name
 
*Location
 
*Region
 
*Primary Job Title
 
*Number of Organizations Founded
 
*Primary Organization
 
  
 +
|Organization Name
 +
|-
 +
|-
 +
| style="text-align: center;" | Categories
 +
|String
 +
|Industry the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Sector
 +
|String
 +
|The sector the organization belongs to
 +
|-
 +
|-
 +
| style="text-align: center;" | Headquarter Location
 +
|String
 +
|Organization headquarter location
 +
|-
 +
|-
 +
| style="text-align: center;" | CB_Rank
 +
|Integer
 +
|Crunchbase Rank
 
|-
 
|-
 
|-
 
|-
| style="text-align: center;" | Investment
+
| style="text-align: center;" | Age_days
|
+
|Integer
*Number of Investments
+
|Age of the organization measured in days
*Number of Portfolio Organizations
+
|-
*Number of Partner Investments
+
|-
*Number of Lead Investments
+
| style="text-align: center;" | SimilarWeb_Average_Visits
*Number of Exits
+
|Double
*Number of Exits (IPO)
+
|Average visits to the organization website recorded by SimilarWeb
*Investment Stage
+
|-
*Investor Type
+
|-
*Investor’s Category Group
+
| style="text-align: center;" | SimilarWeb_Visit_Duration
*Investor’s Category
+
|Integer
 +
|Visit duration to the organization website recorded by SimilarWeb
 +
|-
 +
|-
 +
| style="text-align: center;" | SimilarWeb_Global_Traffic_Rank
 +
|Double
 +
|Organization website traffic ranking among all the organization websites globally recorded by SimilarWeb
 +
|-
 +
|-
 +
| style="text-align: center;" | BuiltWith_Active_Tech_Count
 +
|Integer
 +
|Count of active technology used recorded by BuiltWit
 
|-
 
|-
 
|-
 
|-
 +
 +
 
|}
 
|}
 +
 
|-
 
|-
 
|}
 
|}
 
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">BACKGROUND SURVEY OF RELATED WORKS</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">BACKGROUND SURVEY OF RELATED WORKS</font></div>
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
Line 284: Line 314:
 
! What We Can Learn
 
! What We Can Learn
 
|-
 
|-
|[http://bl.ocks.org/nbremer/6506614  <center>'''Spider Chart''' </center>]
 
<b>[[File:Spider chart unicorn.PNG|center|400px]] </b>
 
  
|
+
|[https://online.flowpaper.com/7c3c077c/GlobalStartupEcosystemReport2017v18/#page=19 <center>'''Heat Map''' </center>]
*A spider chart helps compare two objects in multiple dimensions. By comparing the shapes of different objects, It is easier for user to identify the similarity and differences between them.
 
*Contrasting colours used can represent different categories.
 
*When the user hovers to one area, the corresponding category will be shaded and other category will be unshaded. It also helps user to focus on the details of chart.
 
*Tooltips can also be added to show more details of each sub-index.
 
 
 
 
 
|-
 
|[https://online.flowpaper.com/7c3c077c/GlobalStartupEcosystemReport2017v18/#page=1 <center>'''Heat Map''' </center>]
 
  
 
<b>[[File: Heatmap unicorn.PNG|center|400px]] </b>
 
<b>[[File: Heatmap unicorn.PNG|center|400px]] </b>
Line 315: Line 335:
  
 
|-
 
|-
|[https://towardsdatascience.com/best-bookshelf-data-visualization-adapting-real-world-objects-with-d3-js-ca420b5d79cc <center>'''Grouped Bar Chart''' </center>]
+
|[https://datavizcatalogue.com/methods/violin_plot.html <center>'''Violin Plot''' </center>]
  
<b>[[File: Bookshelf chart unicorn.PNG|center|400px]] </b>
+
<b>[[File:Violin plot 1.png|400px|center]]</b>
  
 
|
 
|
*Unlike the traditional bar chart, grouped bar chart shows more information with high dimension in one chart.
+
A violin plot show more information in one plot:
*The filtering function provides more interactive features and user can customize the bar charts based on his/her preference.
+
* IQR (25% percentile, median, 75% percentile) and Max & Min
*The cons of this chart is that the data-ink ratio is too high and the choice of red and green colours is disadvantageous for colour blind users.
+
* 95% confidence interval
 
+
* Average
 
+
* Density plot indicating concentration of data
 +
This can be used for our industry analysis to achieve a more insightful visualization
 
|-
 
|-
|[https://www.r-graph-gallery.com/how-to-draw-connecting-routes-on-map-with-r-and-great-circles/ <center>'''Connection Map''' </center>]
+
|[https://clarity-us.com/data-viz-maps-hex-appeal/ <center>'''Dot Density Map''' </center>]
  
<b>[[File: Connection map unicorn.png|center|400px]] </b>
+
<b>[[File:Map-dot.png|400px|center]]</b>
  
 
|
 
|
*Connection Map is useful to show the flow of traffic from one region to another.
+
* Dot Density Map is useful to show the value density in different locations.  
*The lines in the chart are all with same thickness and color. However, we can use different thickness of the graphs to show the quantity of connections while the colour intensity shows different dimensions.
+
* The color and size of the dot can represents different things.
  
 
|-
 
|-
Line 341: Line 362:
 
! How Analyst Can Conduct Analysis
 
! How Analyst Can Conduct Analysis
 
|-
 
|-
| style="text-align: center;" | <b>  </b>
 
 
<b>[[File:Spider chart unicorn sketch.PNG|center|400px]] </b>
 
  
|
 
Spider Charts
 
*Allows users to compare the Global Entrepreneurship Index and Global Competitiveness Index between Singapore and Hong Kong
 
*Enables users to see the performance of different index when hover on top of the index
 
 
 
|-
 
 
| style="text-align: center;" | <b></b>
 
| style="text-align: center;" | <b></b>
  
Line 367: Line 379:
 
|
 
|
 
Cleveland Dot Plot with Filters:
 
Cleveland Dot Plot with Filters:
*Presents current breakdown of startups by industries, team size, funding stage, age and gender of founders
+
*Presents current breakdown of startups by industries
 
*Colour of the dots represent the region
 
*Colour of the dots represent the region
  
Line 373: Line 385:
 
| style="text-align: center;" | <b></b>
 
| style="text-align: center;" | <b></b>
  
<b>[[File: Bookshelf chart unicorn sketch.PNG|center|400px]] </b>
+
<b>[[File:Violin-own-2.png|600px|center]]</b>
  
 
|
 
|
Grouped Bar Chart with filters:
+
Violin Plot with filters:
*Displays startups ordered by funding amount in various industries
+
* Displays values across sectors and industry inside each sector across 2 regions. The values are: age (company age), similarweb visit duration, crunchbase rank, similarweb average visits, builtwith active technology count, global traffic rank.
*Users can search for a startup or choose the ranking range and country.
+
* The value shown are accessible through tabs.
*Color intensity shows the funding stage of the startups.
+
* Breakdown of industries in each sector is shown by selecting sector in dropdown list.
 +
* User can choose bar chart over violin chart to have an overview of data.
  
 
|-
 
|-
 
| style="text-align: center;" | <b></b>
 
| style="text-align: center;" | <b></b>
  
<b>[[File: Connection map unicorn.png|center|400px]] </b>
+
<b>
 +
[[File:Density-map.png|400px|center]]
 +
</b>
  
 
|
 
|
Connection Map:
+
Dot Density Map:
*Paths Illustrates investor’s locations
+
* color shows number of investments by percentile (to standardize the skewed number)
*Colour density shows investor type and line thickness shows number of investors.
+
* size shows number of investments
 +
* style of map can be changed using the radio button
 
|-
 
|-
 
|}
 
|}
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">ARCHITECTURE DIAGRAM</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">ARCHITECTURE DIAGRAM</font></div>
  
<br>[[File:Technology diagram VA unicorn.png|center|500px]]</br>
+
<br>[[File:Technology diagram VA.png|center|700px]]</br>
  
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">KEY TECHNICAL CHALLENGES</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">KEY TECHNICAL CHALLENGES</font></div>
Line 411: Line 427:
 
<div style="background: #FF7F50 ; margin-bottom:10px; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">PROJECT TIMELINE</font></div>
 
<div style="background: #FF7F50 ; margin-bottom:10px; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">PROJECT TIMELINE</font></div>
  
<br>[[File:Project milestones unicorn.png|center|1000px]]</br>
+
<br>[[File:Timeline Diagram.png|1000px|center]]</br>
  
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">REFERENCES</font></div>
 
<div style="background: #FF7F50 ; margin-top: 40px; font-weight: bold; line-height: 0.3em;letter-spacing:-0.08em;font-size:20px"><font color=#FF5A60 face="Century Gothic">REFERENCES</font></div>
 
<br>
 
<br>
*[https://www-statista-com.libproxy.smu.edu.sg/statistics/882698/singapore-global-entrepreneurship-index-score/ Global Entrepreneurship Index]
+
*[https://online.flowpaper.com/7c3c077c/GlobalStartupEcosystemReport2017v18/#page=19 Global Startup Ecosystem Report 2017]
*[http://www3.weforum.org/docs/GCR2017-2018/05FullReport/TheGlobalCompetitivenessReport2017%E2%80%932018.pdf Global Competitiveness Report]
+
*[https://uc-r.github.io/cleveland-dot-plots UC Business Analytics R Programming Guide on Cleaveland Dot Plot]
 +
*[https://datavizcatalogue.com/methods/violin_plot.html Data Visualisation Catalogue on Violin Plot]
 +
*[https://clarity-us.com/data-viz-maps-hex-appeal/ Data Viz: Give Your Maps Some Hex Appeal]
 
*[https://www.crunchbase.com/ Crunchbase]
 
*[https://www.crunchbase.com/ Crunchbase]
 
</br>
 
</br>

Latest revision as of 23:59, 25 November 2018

Unicorn Logo.jpg


PROJECT GROUP

 

TEAM

 

PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER

 

Version 1 | Version 2

INTRODUCTION


Blockchain, artificial intelligence, data science, edtech and internet-of-things are all buzzwords today in this new innovation era. More and more founders and investors begin to see the potential of innovation in Asia today. Meanwhile, local governments in the region have introduced new policies and initiatives to explore new technological innovation frontiers in order to boost the competitiveness of various knowledge-based industries. In recent years, both Hong Kong and Singapore government has pumped in resources including start-up clusters, grants and funding to boost its start-up Ecosystem.

The two Asian-Tigers, Singapore and Hong Kong, will be the main contexts for this project. They are two high-growth metropolitan city-states in Asia that share many characteristics in common in terms of GDP per capita and population density. Beyond that, both Hong Kong and Singapore offers a comprehensive financial and technical infrastructure and has attracted a considerable amount of foreign investment. It is commendable that both countries have achieved stellar economic performance despite the lack of natural resources and large land size. Unicorn Ventures strives to study the current start-up ecosystem in these two city-based regions and hope to generate new insights for policy-makers, founders and investors.

MOTIVATION


As there is a general lack of effective and user-friendly visualization for discovering country-specific differences between the start-up ecosystems, the main motivation behind this project is to create a centralized, dynamic and interactive dashboard for quantitative comparisons on various aspects of start-ups and funding organizations in Singapore and Hong Kong. Based on User-Centric Dashboard Design Guide, this dashboard takes a broad, strategic, customizable, drillable and exploratory approach and is targeted at potential entrepreneurs, policy makers and investors. This project will focus on start-up companies and funding organizations in the tech ecosystem. The insights generated could help:

  • Enable potential entrepreneurs to understand the growing and declining industries, investors’ profile as well as pinpoint the top funded start-ups
  • Help policy makers to identify the potential profitable and leading industries and dedicate more resources in specific industries
  • Assist investors in identifying the difference between Singapore and Hong Kong’s start-up industries and strategizing future investments in these two regions


OBJECTIVES


Our project aims to explore and compare the following aspects for the start-up ecosystem in Singapore and Hong Kong by considering the start-ups founded after 2000. We hope to address the following questions For Entrepreneurs:

  • Time-series analysis: When was the start-ups founded, exited and funded?
  • Funding Analysis: Discovering the top funded start-ups
  • Spatial Analysis: Where do the investors originate from?

For Policy Makers/Investors:

  • Profile Analysis: What are the differences in terms of start-up formation across the years?
  • Industry Analysis: Comparing the start-ups in various industries and sectors based on different performance indicators


SELECTED DATASET
Dataset

Basic Startup Information in Singapore and Hong Kong

  • Description: This dataset includes various key attributes on startups in Singapore and Hong Kong that was founded after 2000.
  • Source: Crunchbase
  • Dataset
  • Components:
Field Type Description
Organization Name String Organization Name
Categories String Industry the organization belongs to
Sub Category 1 String Sub category the organization belongs to
Sub Category 1 String Sub category the organization belongs to
Headquarter Location String Organization headquarter location
Description String Organization description
Founded_Date String Organization founding date
Exit Date String Organization exit date
Last Funding Date Date Last Funding Date
Last Funding Type String Last Funding Type
Last Funding Amount Currency (in USD) String Last Funding Amount in USD
Total Funding Amount Currency in USD String Total Funding Amount in USD

Investment and Funding Information in Singapore and Hong Kong

  • Description: This dataset details the individual disclosed funding transactions that are public and are published in crunchbase.
  • Source: Crunchbase
  • Dataset
  • Components:
Field Type Description
Transaction Name String Auto-generated name of transaction (e.g. Angel-Uber)
Organization Name String Name of the organization that got funded.
Categories String Industry the organization belongs to
Location String Location of the organization that got funded
Funding Type String Type of Funding Round (e.g. Seed, Series A, Private Equity, Debt Financing)
Money Raised Currency (in USD) Integer Amount of money raised in Funding Round
Announced Date Date Date that the Funding Round was publicly anounced
Funding Stage String The funding stage of a funding round

Investor Information in Singapore and Hong Kong

  • Description: This dataset shows the investor locations and number of investments made by the investors .
Field Type Description
Location String Investor locations
Lat Double Latitude of the location
Categories Double Longitude of the location
Number_of_Investments Integer Number of investments made by investors from the location

Other Startup Information in Singapore and Hong Kong

  • Description: This dataset includes other attributes on startups in Singapore and Hong Kong that was founded after 2000.
  • Source: Crunchbase
  • Dataset
  • Components:
Field Type Description
Organization Name String Organization Name
Categories String Industry the organization belongs to
Sector String The sector the organization belongs to
Headquarter Location String Organization headquarter location
CB_Rank Integer Crunchbase Rank
Age_days Integer Age of the organization measured in days
SimilarWeb_Average_Visits Double Average visits to the organization website recorded by SimilarWeb
SimilarWeb_Visit_Duration Integer Visit duration to the organization website recorded by SimilarWeb
SimilarWeb_Global_Traffic_Rank Double Organization website traffic ranking among all the organization websites globally recorded by SimilarWeb
BuiltWith_Active_Tech_Count Integer Count of active technology used recorded by BuiltWit
BACKGROUND SURVEY OF RELATED WORKS
Related Works What We Can Learn
Heat Map
Heatmap unicorn.PNG
  • A heat map can display time series data for multiple dimensions across a fixed set of categories and this provides more information in one single chart.
  • By looking at the overview of color intensity, user are able to identify the overall pattern of the data and highlight any exceptions/outliers.
  • The color intensity displays the quantity while tooltip enables users to hover over the individual shaded area and understand the exact quantity.
Cleveland Dot Plot
Cleveland dot plot unicorn.PNG
  • Cleveland Dot Plot is effective in comparing data of two parties on a single chart. It can easily communicate the huge gaps between two objects to the user.
  • Unlike bar chart, this dot plot reduce the clutter and maximize the data-ink ratio.


Violin Plot
Violin plot 1.png

A violin plot show more information in one plot:

  • IQR (25% percentile, median, 75% percentile) and Max & Min
  • 95% confidence interval
  • Average
  • Density plot indicating concentration of data

This can be used for our industry analysis to achieve a more insightful visualization

Dot Density Map
Map-dot.png
  • Dot Density Map is useful to show the value density in different locations.
  • The color and size of the dot can represents different things.
SKETCHES STORYBOARD
Sketches How Analyst Can Conduct Analysis
Heatmap unicorn sketch.PNG

Heat Map:

  • Shows time-series analysis for startups that has formed or exited and their funding amount across the years according different industries
  • AllowS the user to identify the growing industries as well as the trend in start-up formation and funding amount
Cleveland dot plot unicorn sketch.PNG

Cleveland Dot Plot with Filters:

  • Presents current breakdown of startups by industries
  • Colour of the dots represent the region
Violin-own-2.png

Violin Plot with filters:

  • Displays values across sectors and industry inside each sector across 2 regions. The values are: age (company age), similarweb visit duration, crunchbase rank, similarweb average visits, builtwith active technology count, global traffic rank.
  • The value shown are accessible through tabs.
  • Breakdown of industries in each sector is shown by selecting sector in dropdown list.
  • User can choose bar chart over violin chart to have an overview of data.

Density-map.png

Dot Density Map:

  • color shows number of investments by percentile (to standardize the skewed number)
  • size shows number of investments
  • style of map can be changed using the radio button
ARCHITECTURE DIAGRAM


Technology diagram VA.png


KEY TECHNICAL CHALLENGES


Domain Knowledge Understanding:

  • As the datasets involves many technical terms in the startup ecosystem, the group has to study more in-depth on the terminologies used in the ecosystem in order to draw meaningful insights. This includes the definition of different funding stages, types of fundings, types of investors, startup industries categories and etc.

Data Preprocessing:

  • Missing data: how to deal with missing values
  • Data integration and calculation: understanding the column attributes and perform meaningful summation or calculation
  • Multiple values for certain observations: how to deal with such attributes and ensure that the visualizations take into account of start-ups that has attributes with multiple values

Technological Expertise:

  • Learning relevant packages under R such as ggplot2, tidyverse, shiny and plotly
  • Learning how to integrate D3.js with R to achieve both advanced analytics functions as well as interactive visualization
  • Learning integration of different charts and enhance the interactivity and animation techniques of the storyboard


PROJECT TIMELINE


Timeline Diagram.png


REFERENCES



COMMENTS

Feel free to comments, suggestions and feedbacks to help us improve our project!:D