You work for Spark Funds, an asset management company. Spark Funds wants to make investments in a few companies. The CEO of Spark Funds wants to understand the global trends in investments so that she can take the investment decisions effectively.
Spark Funds has two minor constraints for investments:
-
It wants to invest between 5 to 15 million USD per round of investment
-
It wants to invest only in English-speaking countries because of the ease of communication with the companies it would invest in
Taken real investment data from crunchbase.com, so the insights you get may be incredibly useful. UseD three main data tables for the entire analysis.
Business objective: The objective is to identify the best sectors, countries, and a suitable investment type for making investments. The overall strategy is to invest where others are investing, implying that the 'best' sectors and countries are the ones 'where most investors are investing'. Goals of data analysis: Goals are divided into three sub-goals: Investment type analysis: Comparing the typical investment amounts in the venture, seed, angel, private equity etc. so that Spark Funds can choose the type that is best suited for their strategy. Country analysis: Identifying the countries which have been the most heavily invested in the past. These will be Spark Funds’ favourites as well. Sector analysis: Understanding the distribution of investments across the eight main sectors. (Note that we are interested in the eight 'main sectors' provided in the mapping file. The two files — companies and rounds2 — have numerous sub-sector names; hence, you will need to map each sub-sector to its main sector.)
-The data insights and results are stored in Investments.xlsx file.