Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

• A.September 2017
• B.March 2018
• C.December 2017
• D.January 2018

Correct Answer: D

Explanation
Follow the steps to get the correct answer : January 2018

* We are talking about dates, so use the Time series sheet as follows:
* Next, the following should be your view and clearly, January 2018 is the lowest point:

Read more about dates:
https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/

Comment: *

Name: *

Email: *

Verification: *

How can you change the default Tableau repository location?

• A.By clicking on Window -> Repository Location
• B.By clicking on Help -> Change Repository Location
• C.By clicking on File -> Repository Location and choosing a new location
• D.By Moving the repository location manually to wherever we want

Correct Answer: D

Explanation
According to the official Tableau documentation:

Comment: *

Name: *

Email: *

Verification: *

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

• A.True
• B.False

Correct Answer: A

Explanation
This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

Comment: *

Name: *

Email: *

Verification: *

_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

• A.Tableau Data Extract (.tde)
• B.Tableau Packaged Workbook (.twbx)
• C.Tableau Bookmark (.tbm)
• D.Tableau Workbook (.twb)

Correct Answer: B

Explanation
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.

3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)

Comment: *

Name: *

Email: *

Verification: *

You can create _______________ for members in a dimension so that their labels appear differently in the view.

• A.parameters
• B.duplicates
• C.copies
• D.aliases

Correct Answer: D

Explanation
You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.
Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.
To create an alias:

1) In the Data pane, right-click a dimension and select Aliases.
2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.

* To submit your changes: In Tableau Desktop, click OK.
On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.
When you add the field to the view, the alias names appear as labels in the view. For example:

Comment: *

Name: *

Email: *

Verification: *