Tableau Data Analyst – Exam 1 – Free

Solution

The trick in this question is that space is a default option for a field separator so the option to select space by giving space as a field separator is an invalid option. You do not actually need to give space as a separate.

For more details, refer the following link

Solution

Solution

The correct option is the distribution band.

In order to achieve the desired result following is the navigation.

Following screen appears. On this screen select the Distribution and in the computation value click on the drop-down as shown below

After it shows the values, you need to select the Quantiles value to have the desired output

So the right selection of the answer is Distribution Band.

Solution

States.Hyper is an extract file.

Solution

Solution

Three date part components that can be used with DATEDIFF Function are as follows ‘day’,’month’,’year’. So the correct syntax is DATEDIFF(‘day’,[Order Date],[Ship Date]).

Solution

As two sets already exist that provide the information for the Top 3 and Bottom 3 members, in such case, our job is simply to create a combined set to include all members from both sets.

Select both sets and create a combined set as shown in the picture and select the following settings

Now put the combined set in the filter shelf to see the desired result with 6 product sub categories containing top 3 and bottom 3 members.

Solution

The Rank value will be 3 and that can be verified by ordering the average value of the products sold against the employees.

For the verification, see the below image that clearly shows that the value for employee 4220 falls at the third rank.

We have simply sorted out the data based on the avg products sold field

Now for your better understanding, the same question now solved in the Tableau and looks like this

Created a Calculated field as shown below

And placed it on the Text on the Marks Card

For your better understanding the concept and clarification, see the same question with RANK_DENSE formula and its impact on the rank results.

This example has been given just to strengthen your concept for Rank related questions.

Likewise you can test your knowledge for other RANK functions

Solution

This requirement can be achieved by simply creating the aliases of the values in the State column.

Following link further elaborates the concept

Solution

Select the Country Field and click on symbol ABC

Select the geographic role to Country/ Region

As soon as you correct the geographic role, it will reflect the countries and values

Solution

Once Tableau data extracts are upgraded, It can not be converted back to previous format and when you open the work book that uses older version of .TDE, it must be converted to .hyper format before opening

Solution

In the question, they have asked to make it work in a way that any click on the map should filter the data in the tabular side and if we click any other point on the map, the tabular sheet will reflect the data as per the new selection.

So in this case, we shall select the Filter dashboard action that should fire on the select action and should show all values when clearing the filter.

Solution 
Tableau forecast is based on exponential smoothing, There is no way this computation mechanism. This is default computation method in Tableau.

Solution

You can use the background image in order to make your chart as watermarked.

Solution

Common Characters is the most feasible option for the given scenario

Solution

The correct syntax for the given scenario is {FIXED: SUM (Population)}.

To know more about LOD in Tableau, refer the following link

Solution

Click on Density Map Sheet and mouse hover to Density Table Sheet and click swap sheet button next to Density Table Sheet

Click on density map and then take your mouse to Density Table sheet, it will enable a swap option as shown below

Upon click, it replaces the sheets in the dashboard

Solution
You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

Solution

This requirement can be entertained by Extract Refresh functionality and since extract is already published so you can configure the extract refresh frequency instead of creating a new refresh

Solution

The most appropriate solution is to publish it on the Tableau Server and share the link with your organization employees whoever is entitled to see the data so the most appropriate option is

Publish the dashboard to Tableau Server and share the link to users

Solution

Change the mark type to density

Solution
INT Function Casts its argument as an integer. For expressions, this function truncates results to the closest integer toward zero.

Solution
When you use a sheet on dashboard, Delete option disappears for that sheet and becomes available only when you detach that sheet from the dashboard.
Sheets used on dashboard can be hided and there is no warning no hiding the sheets.

Solution

ZN and IFNULL are the correct answer to this questions as shown in the images below from Tableau Knowledge base articles

Reference Articles

Article 1

Article 2

Solution
FIXED is a reserve word used for LOD (Level of Detail). By Using FIXED, system gets instructions to groups data based on the dimension being used in FIXED clause.
Using {FIXED Region: Sum (Sales)} statement, Tableau will club the Sales on Region hence showing the sales per region.

Solution

More than one refresh schedules can be configured for a published extract, so appropriate answer to this questions would be to add a new refresh schedule along with the existing one.

From Tableau Server, select the workbook, select refresh extracts and then add a new extract refresh schedule as per given requirement

Solution

A Parameter and a calculation field will be an ideal way to achieve the given requirement. Following article explains the same step by step

https://interworks.com/blog/2021/12/02/the-basics-of-sheet-swapping-in-tableau-desktop/

Solution

Username() function contains the value of the logged in user and hence it will work find for the given scenario.

USERNAME() = Tableau_User_Name

Solution

Follow the sequence to get the desired result

•  Add the date to the columns shelf, Add the product line and the daily complains to the rows shelf
• Aggregate the date to the month and year
• From the Analytics Pane, drag forecast to the worksheet

Solution
PDF Connector in Tableau extracts data in Tables that can be used for building visualizations.

Solution
Background image needs to be mapped to datasource to reflect data point on the image.

Solution

Resume suspended alerts

If an alert fails enough times, you’ll receive a notification email that your alert has been suspended. There are a few ways that administrators or alert owners can resume a suspended alert:

• From the Tasks > Alerts area of Tableau web pages, an icon appears in the Last checked column to indicate that the alert is suspended. Select … > Resume Alert to resume the alert.
• Click Resume Alert in the notification email to resume the alert. A notification will either allow you to resume the alert, or indicate that the view has changed and the alert should be deleted.
• From the Alerts panel of the affected view or workbook. To resume the alert from a view or workbook, select Alert to open the Alerts panel. An icon appears next to the suspended alert. Select Actions > Resume Alert on the affected alert to resume.

Alert owners will receive an email notification when the alert is working again.

For more details, click the link below

https://help.tableau.com/current/online/en-us/data_alerts_admin.htm#:~:text=Resume%20suspended%20alerts,-If%20an%20alert&text=From%20the%20Tasks%20%3E%20Alerts%20area,email%20to%20resume%20the%20alert.

Solution

The correct answer for the given scenario is condition filter as it provides you an option to make logic to filter the data based on the business requirement.

Following article, explains well, when and how different type of filters can be used

Solution

This questions need data transformation so we shall be solving it using Tableau Prep and following order will be followed

D – Open Tableau Prep

C – Create a New Column to concatenate the name for the UAE division

A – Union the Sales Data of both divisions

E – Join the Sales Data and the population data by using City as the Join field

Note: There are some further steps that should be involved in order to meet the requirement for example, in the given steps, it is not mentioned how to handle the arrangements of columns as Saudi data source contains the email column whereas UAE data source does not contain such a column.

This information is intentionally skipped to confuse the users.

Focus only on the steps that have been provided and do not think about the steps that are not provided in the question.

Solution
When we are using cubes for a multi-dimensional databases, We cannot make extracts in Tableau.

Solution

Only density legend and density parameter are floating. Rest all objects are not floating in the given chart.

See the properties of Density Legend

See the properties of Density Parameter for your reference