Answered step by step
Verified Expert Solution
Question
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 within the assignment.
Part :
If necessary, click the carrot beside Product on the Data Pane to display additional productrelated 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 SubCategory onto the Columns shelf to the right of Category.
Drag and drop SubCategory 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 :
Rightclick 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 topright to minimize the menu.
Rightclick SubCategory on the Data Pane and choose Show Filter.
Drag and drop Profit onto the Color mark.
Within the SubCategory 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 SubCategory Filter Card choose the All check to check all boxes.
If necessary, click the carrot beside Location on the Data Pane to display additional locationrelated options. Drag and drop region onto the Rows shelf to the left of Sales.
Within the SubCategory 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 SubCategory Filter Card choose the All check to check all boxes.
Rightclick the Sheet tab, choose Rename, type Sales by ProductRegion and tap the Enter key.
Rightclick the Sales by ProductRegion sheet and choose Duplicate.
Rightclick the Sales by ProductRegion 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 through 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 yaxis tick mark labels, right click the yaxis 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 of Total of Visit 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started