Unicorn Companies- Dashboard Challenge!

Challenge: In a 1-page dashboard, "Illustrate the current landscape of Unicorn Companies around the globe."

-Maven Analytics

Unicorn Company: A privately held company with a valuation of over 1 billion dollars.

Tools

I used SQL for data manipulation, and Tableau for the dashboard. The map and charts were created in Tableau, with the exception of the final chart that I made in Excel for formatting reasons. I used PowerPoint to make the classic BANs (Big A** Numbers).

Dashboard Approach

Personally, I like a grid layout so it can be read left to right. Although I appreciate the artistry some achieve, for me a visualization is about communicating insights clearly.

Data Issues Fixed

There was work to be done, as the data had millions and billions in one column, so they couldn't be added together. (Example: 640M and 3B in one column.) To fix that, I used SQLite to create 2 separate tables for millions and billions, stripping off the M's and B's. Then I turned the millions table into decimals of billions and Unioned the tables back together.

--Everything's coming up Billions!

The Intriguing "Other"

After creating the Funding by Industry chart (Bottom L.) I was interested in this category "Other." After all, $40 Billion dollars is a lot of money! Where is it going?

To find out, I filtered to isolate just the companies from "Other," sorted them by highest funding and googled the top 15 companies to find their industries.

Hidden Industries

I discovered 3 more categories: Aerospace, Batteries, and Video Games. (Bottom R. chart)

--You could call them "Industries to Watch."

To view this dashboard on Tableau Public: https://tabsoft.co/3vPEBQf

As always, thanks for reading, Take a look at my other projects, click over to my LinkedIn profile, or if you need a smile, find my easter egg "Dog Stats" page to meet my dog, Taffy the Good.

Take this challenge on Maven Analytics and a big thank you to them: https://www.mavenanalytics.io/blog/maven-unicorn-challenge