Hands On Questions and answers part -1 for Tableau desktop Associate Exam

1.     Build a Hierarchy with Segment-Category-Region and Find which combinations have the lowest profit? by using Global SuperStore data source.

  ( Ans- Corporate-Furniture-South Asia – ($-3816)

Solution:

Step 1: Open tableau and connect to Global SuperStore.

Step 2: Drag Orders table(Pane) and Click sheet 1

Step 3: Now build a Hierarchy by using Segment-Category-Region(Easy way to create hierarchy, you            have drop one column on another column, and change the hierarchy).

Step 4: Now drag the Hierarchy to rows pane and expand the rows pane(like Segment-Category-Region)

Step 5: Now drag Profit to Columns pane and Colors in the marks shelf.

Step 6: Enable label

Now in the color shelf itself you can find the lowest value.

2.      How Many products are taking almost average 7 days to ship? by using Global SuperStore data source.

(Ans-  9 )

Solution:

         Step 1: Open tableau and connect to Global SuperStore.

Step 2: Drag Orders table(Pane) and Click sheet 1

Step 3: Drag product Name to Rows Pane

Step 4: Create a Calculate field and give a name for the calculate fields

Step 5 : Paste below code and click Ok

           

             DATEDIFF('day',[Order Date],[Ship Date])

Step 6: Now drag the created calculated field to Column Pane and right click the calculate field and               Select Measure, change Sum to Average

Step 7: Now click sort option in the window and enable Label( Now you can easily count how many products are almost 7 Days to ship.)

Step 8: Now Drag Calculated field to filter and select as minimum and give range minimum and maximum value range as 7

Now you can find how many products are taking almost average 7 days to ship