Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Sample Superstore ordinarily is installed when one downloads Tableau. It should be located under Saved Data Sources in the Connect Pane ( Tableau ) on

Sample Superstore ordinarily is installed when one downloads Tableau. It should be located under Saved Data Sources in the Connect Pane (Tableau) on the Tableau start page (bottom left). Superstore is a fictional online retailer with sales limited to the United States.
Drag and drop Order Date onto the Columns shelf.
Drag and drop Sales onto the Rows shelf. Note that this line chart illustrates that sales have increased over time. You may now answer question 1 within the assignment.
Part 2:
If necessary, click the carrot beside Product on the Data Pane to display additional product-related options.
Drag and drop Category onto the Columns shelf to the right of Order Date. Note that the sales data is now displayed for each product category, instead of in total.
Click the Show Mark Labels option on the Toolbar. The labels are now displayed above each bar within the bar chart.
Click the Swap Rows and Columns option on the Toolbar. The bar chart is now displayed horizontally instead of vertically.
Click the Undo option on the Toolbar to revert the bar chart back to a vertical orientation.
Drag and drop Sub-Category onto the Columns shelf to the right of Category.
Drag and drop Sub-Category onto the Color mark. Note that the subcategories are now color coded within the bar chart.
Click the Undo option on the Toolbar to eliminate the color coding.
Part 3:
Right-click Order Date on the Data Pane and choose Show Filter. If the Show Me menu is displayed on the right side of the workbook, and therefore the Filter Card is not visible, click Show Me at the top-right to minimize the menu.
Right-click Sub-Category on the Data Pane and choose Show Filter.
Drag and drop Profit onto the Color mark.
Within the Sub-Category Filter Card choose the All checkbox to clear all checkmarks, then check the boxes for Bookcases, Machines, and Tables. Note that your data now displays only the three selected subcategories.
Within the Sub-Category Filter Card choose the All check to check all boxes.
If necessary, click the carrot beside Location on the Data Pane to display additional location-related options. Drag and drop region onto the Rows shelf to the left of Sales.
Within the Sub-Category Filter Card choose the All checkbox to clear all checkmarks, then check the box for Machines. Note that Machines in the South are reporting a higher negative profit than in other regions.
Within the Sub-Category Filter Card choose the All check to check all boxes.
Right-click the Sheet 1 tab, choose Rename, type Sales by Product/Region, and tap the Enter key.
Right-click the Sales by Product/Region sheet and choose Duplicate.
Right-click the Sales by Product/Region (2), choose Rename, type Sales in the South, and tap the Enter key.
Drag and drop Region onto the Filters shelf.
In the Filter Region dialog box uncheck every region except South and click OK. You may now answer questions 2 through 5 within the assignment.
Having completed all necessary steps, the Tableau file can be saved by choosing the Save As option from the File menu.
General Formatting
In the middle of the ribbon at the top of the page you will find a dropdown menu that has a default option of Standard selected. Make your visualization bigger by changing the selection to Entire View.
To change the formatting on any part of a visualization, right click on that part of the visualization and select Format. For example, if you want to add dollar signs to the y-axis tick mark labels, right click the y-axis and select Format. Next find the Scale section of the menu that appears on the left side of your screen. Under Scale find Numbers, change the Automatic to be Currency.
If there are parts of a visualization you want to hide, right click on that part and select the option that allows you to hide that part of the visualization. For example, if you want to hide an unnecessary header, right click the header, and select Show Header.
If any filter or color legends appear in an area you do not want them, you can drag and drop them anywhere else on the screen you would like them to appear.
PrevQuestion 1 of 1 Total1 of 1Visit question mapThis is the last question in the assignment. To submit, use Alt + S. To access other questions, proceed to the question map button.Next

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions