BYU Student Author: @Andrew
Reviewers: @Jack_Thomas
Estimated Time to Solve: 25 Minutes
We provide the solution to this challenge using:
- Tableau
Need a program? Click here.
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