Data: https://www.mavenanalytics.io/blog/maven-unicorn-challenge ; https://www.mavenanalytics.io/data-playground
Questions to answer:
1. Where are the top 5 most valued companies located?
A1: United States, China, India, United Kingdom and Germany
2. What are the top 5 most valued industries?
A2: Fintech, Internet software and services, E-commerce and direct-to-consumer, Artificial intelligence, Others
3. Assuming a constant rate, which industry reaches unicorn status early?
A3: Auto & Transportation firms.
4. Do AI industries receive the most funding?
A4: Considering the nature of the AI industry, it is surprising that they do not receive the most funding.
5. Top 5 industries with most funding?
A5: Fintech, E-commerce and direct-to-consumer, Internet software and services, Artificial Intelligence, Supply chain, logistics and delivery.
Had to use Tableau Prep to format the numbers.
https://kb.tableau.com/articles/howto/finding-the-top-n-within-a-category (to find the top N)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_string.htm (to clean on Prep)
https://tarsolutions.co.uk/blog/dates-in-tableau-the-ultimate-guide/#convert (to verify on Tableau’s date functions_