Analytics on Venture Capital Data and Visualization in Tableau

Project Description

I need the answers, visualized in Tableau ideally, with supporting data, by May 22 at the latest. 

Data:

• The free Crunchbase data is available on Tableau Public. 
• I have also purchased two commercial data sets from CB Insights that may have better data. Revenue data will need to be found from another source — I believe there are some. 

Goals:

• Illustrate what it takes in venture capital, revenue, headcount, and time, to build a successful big data analytics company versus a social listening analytics company
• Illustrate the relationship between capital raised and exit valuation
• Illustrate the relationship between capital raised and revenue attainment
• Illustrate the relationship between capital raised and time to exit
• Illustrate the relationship between capital raised and exit ROI

Detailed Questions:

Big Data Analytics

• What is the average amount of funding that companies in big data analytics have raised at each round of funding (Seed, A, B, C, D, E)?
• What is the average amount of funding that companies in big data analytics have raised in total, by year since founding?
• What was the average annual revenue per each size funding round (Seed, A, B, C, D, E)?
• What is the average number of years from founding that it takes big data analytics companies to raise $30M, $50M, $100M, $200M
• At each round of funding, what pre-money valuations were achieved on average?
• What was the average multiple of revenue and prior funding raised, at each round of funding (A, B, C, D, E)?
• For various levels of total amounts of funding raised, what exit values (at IPO or acquisition) were achieved?
• How many years from founding to exit did it take on average?
• How many employees did companies have on average at each round (A, B, C, D, E) of funding?
• What is the average revenue, pre-money valuation, headcount, and new funding raised, and total funding to date of B round, and C round companies?

Social Listening / Analytics

• What is the average amount of funding that companies in social listening / analytics have raised at each round of funding (Seed, A, B, C, D, E)?
• What is the average amount of funding that companies in social listening / analytics have raised in total, by year since founding?
• What was the average annual revenue per each size funding round (Seed, A, B, C, D, E)?
• What is the average number of years from founding that it takes social listening / analytics companies to raise $30M, $50M, $100M, $200M
• At each round of funding, what pre-money valuations were achieved on average?
• What was the average multiple of revenue and prior funding raised, at each round of funding (A, B, C, D, E)?
• What were the average multiples of total funding raised, and revenues at exit, to exit price achieved in this category? (for example 6x total funding, 10x revenues)
• For various levels of total amounts of funding raised, what exit values (at IPO or acquisition) were achieved?
• How many years from founding to exit did it take on average?
• How many employees did companies have on average at each round (A, B, C, D, E) of funding?
• What is the average revenue, pre-money valuation, headcount, and new funding raised, and total funding to date of B round, and C round companies?