# 35|TABLEAU – Investment Fund Visualizations

BYU Student Author: @Hyrum
Reviewers: @TylerBooth, @Erick_Sizilio, @klayton
Estimated Time to Solve: 25 Minutes

We provide the solution to this challenge using:

• Tableau

Overview
You’re about to be the investing MVP of your crew! You’ve decided to assist some of your friends in launching their own investment company. As the designated accountant, you’ve received a wealth of financial data on the companies that your crew’s got their eye on. They’ve asked you to condense the data into easily digestible nuggets and present it to the group next week.

You’ve already worked your magic and compiled the data into a stunning Excel sheet, but you know that non-accountant types prefer pictures and graphs. That’s when you had a lightbulb moment: why not use Tableau to create some fun and funky charts for your buds? With your new visual aids, your friends will be able to absorb your research like it’s a piece of cake!

Instructions

1. To get started, make a bar chart of the industries as the x axis, and the market cap as the y axis. Which industry has the highest market cap?
2. Now make a visualization that clearly shows which industry has the highest Revenue growth. Which industry has the highest? Which industry has the lowest? What industry would you suggest your friends put their money into?
3. Make a heat map that shows the book value of individual companies. Which company has the highest book value?
4. Segment the industries by their individual companies and use the current price as an estimation of how the market views the value of these companies. Which company is the most valuable? Which industry has the most valuable companies? Are there any industries that have a lot of disparity?
5. In accounting, having a lot of loose cash on hand is typically a bad idea since that cash could be used for developing the company or researching improvement. Make a scatterplot that shows total cash against revenue growth of the company. Is there anything concerning about some popular companies you would like to discuss with your friends? Why might these companies be holding so much cash?
6. Make your own visualization from the dataset that you find interesting! Share it in a picture in our website for others to see and learn from!

Data Files

Suggestions and Hints

To segment data, you will need two discrete datasets (the blue data) in the columns window.

Solution

Internet and content are the largest while consulting services are the smallest

Internet connection has the highest market cap!

Biotechnology has the highest revenue growth while life-insurance has the lowest revenue growth.

Alphabet inc. has the highest book value!

Alphabet inc. has the highest value in the industry of internet content and information. At the bottom, we have pharmaceutical retailers and building products & equipment.

Internet Content and Information companies have the highest revenue!

1 Like
1 Like

Internet Content & Information

Highest: Biotechnology
Lowest: Packaged Foods
Biotechnology

Alphabet Inc.

Most valuable Company: Alphabet Inc.
Most Valuable Industry: Internet Content & Information, Internet Retail, Auto
Industries with a lot of disparity: Internet Content & Information

Alphabet Inc. is holding too much cash

Biotechnology has the highest revenue growth!

Here are my visuals from this challenge.

1. Internet Content and Information has the highest market cap.

2. Biotechnology has the highest revenue growth and insurance-life has the lowest revenue growth. I would suggest investing in Biotechnology given the revenue growth.

3. Alphabet Inc has the highest book value.

4. Alphabet Inc is the most valuable company and Internet Content and Information has the most valuable companies.

5. Some companies are decreasing in revenue yet have positive cash. This could be due to the market demand or the way the company manages its expenses.