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/

When creating a histogram in Tableau, bin size refers to the range of the continuous measure counted in each bin. A histogram is a chart that displays the shape of a distribution of a continuous measure. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.  The basic building blocks for a histogram are as follows: Mark type: Automatic; Rows shelf: Continuous measure (aggregated by Count or Count Distinct); Columns shelf: Bin (continuous or discrete) 4  To create bins from a continuous measure, you need to specify the size of bins, which determines how many bins are created and how wide they are. The size of bins is equal to the difference between consecutive values along the axis that represents the bins. For example, if you have bins with values 0-10, 10-20, 20-30, etc., then the size of bins is 10.  You can either enter a value for the size of bins manually or have Tableau suggest an optimal bin size based on a formula that considers the number of distinct rows and the minimum and maximum values in the data 5  The other options are not valid definitions of bin size when creating a histogram in Tableau. The minimum number of axis ticks in the view is determined by Tableau’s automatic scaling and formatting of axes, which can be adjusted manually if needed. The count distinct (COUNTD) of items on either axis is an aggregation function that returns the number of unique values in a field, which can be used as a measure in a histogram but not as bin size.  The maximum number of marks in the view is limited by the performance and readability of the visualization, which can be improved by filtering, sorting, or aggregating the data 4

Explanation

This question is directly from the Official Tableau Desktop Specialist exam guide.

Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we ' re working with MEASURES.

Date part and Date values don ' t really make much sense given the question, and neither does geography.

Therefore, the answer naturally is " An aggregated measure " .

To combine data from another database with an existing data source in Tableau, the first step is to add a new connection. This will allow you to access the additional database and either blend or join the data from the two sources depending on your analysis needs.

THIS IS A VERY IMPORTANT QUESTION

Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales] ) will give you a very different answer than [Profit] / [Sales] , even though both formulas are valid.

If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.

In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y --- > This is what we expect! Perfect!

BUT, if you don ' t specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan ' t!

An example:

 You can share a dashboard as an image file by using one of the following methods: Export Image on the Dashboard menu, or a dashboard export button. Export Image on the Dashboard menu allows you to export the dashboard as an image file in BMP, JPEG, PNG, or SVG format.  A dashboard export button is a custom button that you can create on your dashboard to export it as an image file using a URL action

According to the  Tableau Desktop Specialist Exam Readiness , to create a calculation that returns a customer name followed by a comma, a space, and then the customer’s age, you should use the formula [Customer Name] + “,” + STR([Age] ). This is because you need to concatenate strings using the + operator, and convert the numeric field [Age] to a string using the STR() function.

Explanation

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

Layout containers  let you group related dashboard items together so you can quickly position them. As you change the size and placement of items inside a container, other container items automatically adjust

The benefits of using a live connection over an extract include:

B: A live connection ensures that the data in the workbook is as up-to-date as the database itself, providing fresher data compared to a static extract which is updated at intervals.

C: A live connection queries the database server directly, which means it uses the server ' s memory and processing power rather than relying on the client computer ' s resources.

A live connection does not necessarily require less network overhead (A) as it may continually send queries over the network, and it is not always faster than an extract (D) because extracts can provide quicker response times for complex queries or large datasets.