Taking advantage of the Python and R scripts that I developed in a previous post, I wanted to learn about the state of the art of the companies in Dublin according to Crunchbase (APIv2). It’s true however that Crunchbase, and other similar websites, can give an incomplete vision about the companies in a specific city and on the other hand, this information, sometimes, is a bit biased, because they themselves manage, as it’s logical, what information want to show to potential investors and what not. In any case, it’s a good starting point to glimpse the technological potential of this city, where by the way, are many of the largest software companies worldwide. In this sense, I wanted to know some things related to “business ecosystem” of Dublin as the following ones: Which are the companies that have received more investments in the last years?, Who are the main investors?, Which is the order of magnitude of the investments?, Which are the most important business areas (“categories”) in the city?, etc.
An aspect to highlight in Crunchbase is that the companies indicate one or many categories (or fields) where their businesses are developed, so, there isn’t an unique “tag” that describes a company. However, some companies for example don’t choose the category “startup”, but in their descriptions they consider themselves as “startups”. On the other hand, doing a search for Dublin city, I gathered 1227 companies where only 186 included information about their investments, i.e. they mentioned investors and funding, although sometimes a “undisclosed amount” was considered as zero EUR. Furthermore, some companies like Mongodb-Inc, maybe must be considered as “outliers” or an unrepresentative company, because in this case, Mongodb’s Headquarter is in New York city, but its EMEA Headquarter is exactly in Dublin city. So, it’d be necessary to improve the search with filters more accurate to avoid this situation. Unfortunately, GPS coordinates are “missing in action” in the system and they must be generated directly using the addresses of the offices. I’ve a pending Python script via geopy to generate a new column with lat/long coordinates.
Anyway, the following figure shows a network graph with only 186 companies (“blue nodes”), 211 investors (“orange nodes”), and 534 links. Visually it may seem less links due to some investors are involved in several funding rounds with a same company, for example. Here ithere s a javascript chart.
Perhaps, a Sankey diagram could be suitable to represent the connections between companies and investors because the width of the arrows is proportional to the investments which give us a clear idea about flow investment in Dublin. However, they are many companies and investors and the whole diagram is a bit confusing, so I only show a couple of companies/investors. By the way, this type of diagram is mainly used to visualize energy or material or cost transfers between processes. Here there is a javascript chart.
a) Total Fundraised vs Year
b) Top 10 Companies
Company | Total Fundraised |
---|---|
mongodb-inc | EUR 214,922,988.84 |
green-apple-media | EUR 122,760,000.00 |
mainstream-renewable-power | EUR 120,000,000.00 |
gc-aesthetics | EUR 83,700,000.00 |
intune-networks | EUR 46,732,497.21 |
opsona | EUR 40,277,993.28 |
sumup | EUR 30,689,999.07 |
brandtone | EUR 23,999,997.00 |
3v-transaction-services | EUR 23,715,000.00 |
(*) Mongodb-Inc can be considered an “outlier”.
c) Top 10 Inversors
Investor | Investment |
---|---|
marubeni-corporation | EUR 100,000,000.00 |
robert-abus | EUR 94,860,000.00 |
montreaux-equity-partners | EUR 46,500,000.00 |
enterprise-ireland | EUR 40,920,020.65 |
delta-partners | EUR 35,554,481.07 |
sequoia-capital | EUR 33,479,998.14 |
fountain-healthcare-partners | EUR 33,271,332.38 |
robert-abus-2 | EUR 27,900,000.00 |
intel-capital | EUR 26,615,047.83 |
d) Main Categories
By using Igraph for R, it’s possible to see the different connected components in the whole graph. This is an example:
|
Two charts that relate Funding with metrics like degree and pagerank.