Item$5$

$10$

points

Time Remaining $2$ hours $38$ minutes $28$ seconds$02$:$38$:$28$

eBookPrintReferencesCheck my workCheck My Work button is now enabledItem $5$

Time Remaining $2$ hours $38$ minutes $28$ seconds$02$:$38$:$28$

Applying Tableau Composition of the Balance Sheet $[$LO$2-7]$

In addition to watching the instructional video above and following the steps below, you may wish to watch the additional Tableau training videos that can be found on the Tableau website. $($However$,$ they are not required in order to complete this activity.$)$

In the Chapter $1$ Applying Tableau, you created bar charts to compare trends in operating cash flows and net income for two $($hypothetical$)$ companies: Discount Goods and Big Store. In this case you continue in your role as an analyst conducting research into the relative merits of investing in one or both of these companies, this time comparing the two companies$$ composition $($current versus noncurrent$)$ of the total assets, total liabilities, and total shareholders$$ equity. To garner some additional insights, you want to create pie charts to visualize the relative size of these components of the companies$$ balance sheets.

Tableau Instructions:

Before you begin, you will want to review the raw data in the Excel file for both companies. Review the Required questions below to determine which account classifications, like "Total current assets," to include in your pie charts. These will be the items you include in what$$s called "Account name". Notice that the two companies have somewhat different names for their accounts, but the major groupings are the same.

After viewing the training video, use the following steps to create the charts you need for the case:

Download the Excel file $$Discount$\_$Goods$\_$Big$\_$Store.$$

Open Tableau and connect to the Excel file. Starting on the "Sheet $1"$ tab, at the left side of canvas, double$-$click on $"2021"$ under Measure Names to add it to the canvas Rows shelf.

Click the pull$-$down menu arrow on "Store" under Tables and click "Show Filter." The filter box will appear on the right side of the canvas. Un$-$click the $"($All$)"$ button and click only Discount Goods.

Move "Account name" into the Filters card. In the Filter dialog box that opens, click all Discount Goods$$ account classifications you$$ve identified as needed for the case. You can determine this information by checking the raw data as instructed above. Hint: You should have selected no more than five account classifications.

Drag "Account name" from the left side of the canvas to "Color" in the Marks card to add more colors to the chart. On the "Show me$"$ tab in the upper right corner of the toolbar, select the pie chart.

Enlarge the pie chart by holding down the shift$-$control and clicking the $"$B$"$ key several times until your pie chart fills most of the screen.

Add "Labels" to the pie sections by clicking on "Label" in the Marks card and clicking the box "Show mark label."

Change the title of the sheet to be "Discount Goods $2021$ Balance Sheet" by double$-$clicking on the tab name.

To save time completing the next page, right$-$click the tab at the bottom of the canvas and select "Duplicate."

Click on the new tab. You should now see a duplicate of the first canvas. In the filter box on the right$-$hand side, click only the $$Big Store$$ checkbox.

Change the title of the sheet to be "Big Store $2021$ Balance Sheet."

Save your work.

Required:

Based on the visualization you created, answer the following questions:

For Discount Goods, do liabilities or shareholders$$ equity provide the greater proportion of the company$$s total assets?

For Big Store, do liabilities or shareholders$$ equity provide the greater proportion of the company$$s total assets?

Which of the two companies has the highest ratio of current liabilities to total liabilities? What is the ratio for that company?

Note: Round your answer to the nearest whole percent.

Which of the two companies has the highest ratio of current assets to current liabilities? What is the ratio for that company?

Note: Round your answer to the nearest whole percent.