Question: This is part 2 of the Applying Tableau Project. Before completing part 2, you should have installed Tableau and completed Part 1 in Connect. Part

This is part 2 of the Applying Tableau Project. Before completing part 2, you should have installed Tableau and completed Part 1 in Connect. Part 1 asked that you complete the following steps:

==============

Instructions from Part (A) (for your reference):

  1. Download the Excel file Discount_Goods_Big_Store."Links to an external site.
  2. Open Tableau and connect to the Excel file you downloaded. You should see the data in the "canvas" area of Tableau.
  3. To begin creating your first visualization, click on the "Sheet 1" tab at the bottom of the canvas.
  4. Move "Account name" into the Filters card. In the Filter dialog box that opens, if all accounts are selected, un-check all accounts by selecting the "None" button. Then, select only the account "Net cash flows from operating activities". Click Apply and OK.
  5. Drag "Store" and Measure Names into the Columns shelf at the top of the canvas.
  6. From the Measure Names section on the left side of the canvas, drag "Measure Values" into the Rows shelf.
  7. In the Rows shelf, remove "Count of Sheet 1" from "Measure Values" by clicking the pull-down menu arrow from the Measure Values dimension. Select " Filter", unselect "Count of Sheet 1", and click Apply and "OK".
  8. On the "Show Me" menu in the upper right corner of the toolbar, select the side-by-side bars if they do not already appear in that chart format. Add labels to the bars by clicking on "Label" in the Marks card and clicking the box "Show mark label".
  9. Double click on the tab label at the bottom of the sheet. Type "Operating Cash Flows: Discount Goods vs. Big Store." (similar to how you would change a tab name in Excel).
  10. If the color bars of your chart are all the same color, change the colors of the bars by dragging Measure Names from within the Marks card on to "Color."
  11. To expedite the creation of your next chart, right-click the "Sheet 1" tab at the bottom of the canvas and select "Duplicate".
  12. Click on the new tab. You should now see a duplicate of your first chart. Double-click on "Account name" in the "Filters" shelf and change the selection "Net income/(loss)" and click Apply and "Ok". Then, double click on the tab name to change the title.
  13. Save your work.

==============

Working with tools like Tableau can be very entertaining because it greatly simplifies tasks, including analyzing large sets of information. However, this simplification sometimes risks oversimplifying the analysis or the consideration of how we design our analysis. The above instructions for Tableau failed to explain why we did what we did in Tableau. Looking at the steps and the Excel spreadsheet along with your answers, explain why the assignment recommended the steps it did to arrive at its Tableau solution. Put another way, what did the various steps you performed really do in Tableau? Explain them briefly.

https://ezto.mheducation.com/extMedia/bne/accounting/spiceland_int_10e/data_analytics/Discount_Goods_Big_Store.xlsx cope link for excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f