# 81|TABLEAU – Portfolio Visualization

BYU Student Author: @Andrew
Reviewers: @Jack_Thomas
Estimated Time to Solve: 25 Minutes

We provide the solution to this challenge using:

• Tableau

Overview
You work at a mutual fund as an analyst. You have been tasked to build a dashboard to visualize your fund’s portfolio for internal use by the fund CFO. The dashboard needs to display metrics of the fund’s overall performance and diversity. Your analysis will be used for financial reporting purposes for measuring you’re the fair value of your fund’s assets.

The data you have been provided includes trading data for all securities (prices tab) and portfolio information for your fund (portfolio tab). It includes data from 2013-2018 (assume the last reported date is the current date). For your analysis, use the closing price from the prices dataset.

Instructions
First, upload the data to Tableau and the relate the two data sets together.

Suggestions and Hints
• The parameters for the data set relationship is: Portfolio (Stock) = Prices (Name). The cardinality is Portfolio (one) – Prices (many). The referential integrity is Portfolio (all records match) – Prices (some records match).

Second, recreate the chart below to analyze the funds overall performance.

Suggestions and Hints
• Create a calculated field that represents the portfolio value of the security on a particular day. Formula: [Number of Shares]*[Close]

Third, recreate the chart below to visualize how the portfolio is diversified among industries. Filter the data to show only the most recent date, February 7, 2018.

Suggestions and Hints
• To find the percentage of the total portfolio value, use a quick table calculation on the SUM(Portfolio Value) pill. The quick table calculation should be “% of Total.”

Data Files

Solution

I completed the relationships by making it a one-to-many for portfolio–>prices. I joined them on stock=name with all values relating to portfolio and some values relating to prices.

I then created a calculated field for the portfolio values by multiplying number of portfolios by the closing date. I added that to the rows, and date to the columns to create the chart.

I finished by taking the % of my calculated field (above), and then I dragged the attributes over color and name, with some in the rows and columns, to get this colored Tableau chart.