Tableau Data Analyst Test - 12

Welcome to your Tableau Data Analyst – Test-12

Name

Phone

Q1. You are analyzing sales data in Tableau and want to create a forecast for the next quarter based on historical sales data over the past three years. The dataset includes monthly sales figures. How should you generate a forecast using Tableaus default settings?

Select 1 option(s):

Apply a linear regression model to the historical sales data

Use the ‘Forecast‘ option in the Analytics pane and apply it to the sales data visualization

Create a calculated field to manually predict sales for the next quarter

Implement a parameter that allows users to input predicted sales figures

Q2. In a Tableau dashboard, you are working with a dataset that includes a numerical Customer Rating field ranging from 1 to 5. You want to ensure that every time this field is used in a visualization, it is sorted in descending order by default. What should you do to achieve this?

Select 1 option(s):

Manually sort the ‘Customer Rating‘ field in descending order each time it is used in a visualization

Change the default sorting of the ‘Customer Rating‘ field to descending in its field properties

Create a calculated field that inverses the ‘Customer Rating‘ values for sorting purposes

Use a filter on the ‘Customer Rating‘ field to display values in descending order

Q3. You are creating a Tableau visualization to display the sales distribution among different product categories in a retail chain. The dataset includes Product Category and Sales Amount. You decide to use a tree map to show the proportion of sales for each category. What steps should you follow to create this tree map in Tableau?

Select 1 option(s):

Drag ‘Product Category‘ to the Color shelf and ‘Sales Amount‘ to the Size shelf, then choose the tree map chart type

Place ‘Sales Amount‘ on the Rows shelf and ‘Product Category‘ on the Columns shelf, then select the tree map chart type

Use ‘Product Category‘ on the Rows shelf and ‘Sales Amount‘ on the Columns shelf, then convert it to a tree map

Create a pie chart with ‘Product Category‘ and ‘Sales Amount‘, then change it to a tree map

Q4. You are analyzing customer satisfaction survey results in Tableau, displayed as a scatter plot with each point representing a survey response. To provide context to the analysis, you want to add a line that shows the overall average satisfaction score. What is the best method to add this average line in Tableau?

Select 1 option(s):

Use a filter to display only data points that match the average satisfaction score

Create a calculated field for the average satisfaction score and display it as a reference line

Right-click on the scatter plot, go to ‘Analytics‘, and add an ‘Average Line‘ across the entire view

Implement a histogram with bins for satisfaction scores and mark the average bin

Q5. Your companys executives require a monthly update on overall business performance metrics. How should you configure a subscription in Tableau Server to meet this requirement?

Select 1 option(s):

Set up a daily subscription to keep the executives constantly informed

Create a monthly subscription that delivers the dashboard on the first day of each month

Configure a quarterly subscription to provide a comprehensive update

Recommend that executives manually access the dashboard as needed

Q6. You are using Tableau Prep to analyze a dataset containing sales data. The data is structured with each row representing a different product, and columns for each month (e.g., Jan Sales, Feb Sales, Dec Sales). You need to transform this data to analyze total sales trends over the year. Which transformation should you apply?

Select 1 option(s):

Use a join to combine the monthly sales columns

Apply a pivot to transform the monthly sales columns into two columns: one for ‘Month‘ and one for ‘Sales‘

Create a union of the data for each month

Use an aggregation to sum up all monthly sales columns into a single column

Q7. In a Tableau project, you are working with a dataset that has a column named Qty_Sold, which represents the quantity of products sold. For clarity in your report, you want to rename this column to Units Sold. Which approach should you take in Tableau to correctly rename this column?

Select 1 option(s):

Use a calculated field to create a new column with the name ‘Units Sold‘ and the same values as ‘Qty_Sold‘

Directly rename the ‘Qty_Sold‘ column to ‘Units Sold‘ in the data source tab

Change the data type of ‘Qty_Sold‘ to string and then rename it to ‘Units Sold‘

Apply a filter to the ‘Qty_Sold‘ column and label it as ‘Units Sold‘

Q8. In a Tableau report analyzing retail sales data, you want to visually represent the range in which the majority of daily sales values fall. The data includes daily sales figures over multiple years. What is the most appropriate Tableau feature to use for highlighting this range on a visualization?

Select 1 option(s):

Implement a reference line showing the average daily sales

Create a calculated field to display the standard deviation of daily sales

Use distribution bands to visually mark the range containing the majority of daily sales values

Apply a heat map to show the density of sales values over time

Q9. You have a Tableau dashboard that tracks weekly sales performance. The sales team needs to review these metrics every Monday morning. What is the best approach to ensure they receive the latest dashboard data at the start of each week?

Select 1 option(s):

Create a daily subscription for the sales team

Set up a weekly subscription that delivers the dashboard every Monday morning

Recommend that the sales team manually checks the dashboard every Monday

Email a static PDF of the dashboard to the sales team every month

Q10. You are analyzing customer data in Tableau for a retail company and want to create a predictive model to forecast future customer spending based on historical data. The dataset includes customer demographics and past purchase amounts. What is the most suitable approach to create this predictive model in Tableau?

Select 1 option(s):

Use the ‘Regression‘ model in the Analytics pane to predict future spending based on past purchase data

Apply a ‘Moving Average‘ calculation to predict future spending trends

Implement a ‘Cluster‘ analysis to group customers and then predict spending for each cluster

Create a calculated field that uses a formula to estimate future spending based on past behavior

Q11. You are creating a Tableau visualization to display the total sales for each year. The dataset contains a Year column with yearly data. How should you use the Year field in your visualization to effectively display this annual sales data?

Select 1 option(s):

Convert the ‘Year‘ field to a discrete dimension to create individual headers for each year

Keep the ‘Year‘ field as a continuous dimension to create a line chart over time

Use the ‘Year‘ field as a continuous measure to calculate the total sales

Convert the ‘Year‘ field to a discrete measure to sum up sales for each year

Q12. In a Tableau visualization, you are working with a dataset that includes employee performance ratings across different departments. You want to create box plots to compare the distribution of ratings in each department. The dataset includes Department and Performance Rating. How should you set up the box plots?

Select 1 option(s):

Drag ‘Department‘ to the Columns shelf and ‘Performance Rating‘ to the Rows shelf, then select the box plot chart type

Place ‘Performance Rating‘ on the Columns shelf and ‘Department‘ on the Size shelf

Use ‘Department‘ on the Color shelf and ‘Performance Rating‘ on the Rows shelf, then convert it to a box plot

Create a histogram with ‘Performance Rating‘ and then change it to a box plot

Q13. You are analyzing a dataset in Tableau that shows the yearly sales and advertising spend of a company over the last decade. To understand the relationship between advertising spend and sales, you want to add a trend line to your scatter plot visualization. What type of trend line should you add to effectively analyze this relationship?

Select 1 option(s):

A linear trend line to show a direct relationship between advertising spend and sales

A polynomial trend line to account for fluctuations in sales not directly related to advertising spend

An exponential trend line to emphasize the impact of high advertising spend

A moving average trend line to smooth out yearly fluctuations in sales

Q14. You have a Tableau dashboard monitoring daily sales. To proactively manage performance, you want to receive an alert if sales fall below a certain threshold on any given day. How should you set up this alert?

Select 1 option(s):

Create an alert based on a calculated field that triggers when daily sales exceed the threshold

Set up an alert on a visualization that triggers when daily sales fall below the set threshold

Configure an alert to trigger at the end of each day, regardless of the sales figures

Establish an alert that sends weekly summaries of sales figures

Q15. In a Tableau report, you are analyzing the accumulation of total customer support requests over time. The dataset includes Date and Number of Requests. You want to create an area chart to represent how the total number of requests has grown. How should you set up the area chart?

Select 1 option(s):

Drag ‘Date‘ to the Columns shelf and ‘Number of Requests‘ to the Rows shelf, then select the area chart type

Place ‘Number of Requests‘ on the Rows shelf and ‘Date‘ on the Color shelf, then create a pie chart and convert it to an area chart

Use ‘Date‘ on the Rows shelf and ‘Number of Requests‘ on the Size shelf, then choose the area chart type

Create a scatter plot with ‘Date‘ and ‘Number of Requests‘, then change it to an area chart

Q16. In a Tableau report focusing on sales performance, you have a field named Total Sales which is currently set as a dimension. However, you need to create visualizations showing the sum of sales. How should you treat the Total Sales field in this scenario?

Select 1 option(s):

Keep ‘Total Sales‘ as a dimension and use it to categorize other data

Convert ‘Total Sales‘ from a dimension to a measure to aggregate sales data

Create a calculated field from ‘Total Sales‘ to use it as both dimension and measure

Leave ‘Total Sales‘ as a dimension and use a filter to calculate the sum of sales

Q17. You are preparing a customer dataset for analysis in Tableau Prep. The dataset includes a Status column indicating if a customer is Active, Inactive, or Pending. You want to analyze only the Active and Pending customers. Which filtering method should you use in Tableau Prep to include the correct records?

Select 1 option(s):

Apply a wildcard filter to include rows with ‘Active‘ and ‘Pending‘

Use a multi-value list filter on the ‘Status‘ column to select ‘Active‘ and ‘Pending‘

Perform a join based on the ‘Status‘ column to filter the data

Pivot the ‘Status‘ column and exclude the ‘Inactive‘ status

Q18. You are creating a Tableau report where you need to analyze sales data by the day of the week. The dataset has a Date field, but the day of the week is not explicitly provided. How should you modify the Date field in Tableau to facilitate analysis by the day of the week?

Select 1 option(s):

Change the data type of the ‘Date‘ field to string and manually enter day names

Create a calculated field that extracts the day of the week from the ‘Date‘ field

Pivot the ‘Date‘ field to create separate columns for each day of the week

Use a filter to select specific days from the ‘Date‘ field

Q19. You are analyzing sales performance data in Tableau and want to show a range where most sales figures fall, based on historical data. The visualization is a scatter plot with each point representing daily sales. What is the best way to use reference bands to highlight this typical sales range?

Select 1 option(s):

Apply a filter to the scatter plot to only display sales within the typical range

Use a reference band to mark the upper and lower limits of the typical sales range on the scatter plot

Create a calculated field for the average sales and display it as a reference line

Implement a dual-axis chart to show the typical range alongside the scatter plot

Q20. You have a dataset in Tableau with a column named Revenue_FY2022, which represents the revenue for the financial year 2022. For your analysis, you need to compare this data with the revenue from previous years and want to standardize the column naming convention. How should you rename this column to align with your analysis?

Select 1 option(s):

Create a calculated field for each year‘s revenue and name them uniformly

Rename ‘Revenue_FY2022‘ to ‘Annual Revenue‘ in the worksheet where it‘s being used

Directly rename ‘Revenue_FY2022‘ to ‘Revenue 2022‘ in the data source tab

Leave the column name as is and use aliases in your visualizations for clarity

Tableau Data Analyst Test - 12

Q1. You are analyzing sales data in Tableau and want to create a forecast for the next quarter based on historical sales data over the past three years. The dataset includes monthly sales figures. How should you generate a forecast using Tableaus default settings?

Q2. In a Tableau dashboard, you are working with a dataset that includes a numerical Customer Rating field ranging from 1 to 5. You want to ensure that every time this field is used in a visualization, it is sorted in descending order by default. What should you do to achieve this?

Q5. Your companys executives require a monthly update on overall business performance metrics. How should you configure a subscription in Tableau Server to meet this requirement?

Q7. In a Tableau project, you are working with a dataset that has a column named Qty_Sold, which represents the quantity of products sold. For clarity in your report, you want to rename this column to Units Sold. Which approach should you take in Tableau to correctly rename this column?

Q9. You have a Tableau dashboard that tracks weekly sales performance. The sales team needs to review these metrics every Monday morning. What is the best approach to ensure they receive the latest dashboard data at the start of each week?

Q11. You are creating a Tableau visualization to display the total sales for each year. The dataset contains a Year column with yearly data. How should you use the Year field in your visualization to effectively display this annual sales data?

Q14. You have a Tableau dashboard monitoring daily sales. To proactively manage performance, you want to receive an alert if sales fall below a certain threshold on any given day. How should you set up this alert?

Q15. In a Tableau report, you are analyzing the accumulation of total customer support requests over time. The dataset includes Date and Number of Requests. You want to create an area chart to represent how the total number of requests has grown. How should you set up the area chart?

Q16. In a Tableau report focusing on sales performance, you have a field named Total Sales which is currently set as a dimension. However, you need to create visualizations showing the sum of sales. How should you treat the Total Sales field in this scenario?

Q18. You are creating a Tableau report where you need to analyze sales data by the day of the week. The dataset has a Date field, but the day of the week is not explicitly provided. How should you modify the Date field in Tableau to facilitate analysis by the day of the week?

Q19. You are analyzing sales performance data in Tableau and want to show a range where most sales figures fall, based on historical data. The visualization is a scatter plot with each point representing daily sales. What is the best way to use reference bands to highlight this typical sales range?

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!

Tableau Data Analyst Test - 12

Q1. You are analyzing sales data in Tableau and want to create a forecast for the next quarter based on historical sales data over the past three years. The dataset includes monthly sales figures. How should you generate a forecast using Tableaus default settings?

Q2. In a Tableau dashboard, you are working with a dataset that includes a numerical Customer Rating field ranging from 1 to 5. You want to ensure that every time this field is used in a visualization, it is sorted in descending order by default. What should you do to achieve this?

Q5. Your companys executives require a monthly update on overall business performance metrics. How should you configure a subscription in Tableau Server to meet this requirement?

Q7. In a Tableau project, you are working with a dataset that has a column named Qty_Sold, which represents the quantity of products sold. For clarity in your report, you want to rename this column to Units Sold. Which approach should you take in Tableau to correctly rename this column?

Q9. You have a Tableau dashboard that tracks weekly sales performance. The sales team needs to review these metrics every Monday morning. What is the best approach to ensure they receive the latest dashboard data at the start of each week?

Q11. You are creating a Tableau visualization to display the total sales for each year. The dataset contains a Year column with yearly data. How should you use the Year field in your visualization to effectively display this annual sales data?

Q14. You have a Tableau dashboard monitoring daily sales. To proactively manage performance, you want to receive an alert if sales fall below a certain threshold on any given day. How should you set up this alert?

Q15. In a Tableau report, you are analyzing the accumulation of total customer support requests over time. The dataset includes Date and Number of Requests. You want to create an area chart to represent how the total number of requests has grown. How should you set up the area chart?

Q16. In a Tableau report focusing on sales performance, you have a field named Total Sales which is currently set as a dimension. However, you need to create visualizations showing the sum of sales. How should you treat the Total Sales field in this scenario?

Q18. You are creating a Tableau report where you need to analyze sales data by the day of the week. The dataset has a Date field, but the day of the week is not explicitly provided. How should you modify the Date field in Tableau to facilitate analysis by the day of the week?

Q19. You are analyzing sales performance data in Tableau and want to show a range where most sales figures fall, based on historical data. The visualization is a scatter plot with each point representing daily sales. What is the best way to use reference bands to highlight this typical sales range?

Q1. You are analyzing sales data in Tableau and want to create a forecast for the next quarter based on historical sales data over the past three years. The dataset includes monthly sales figures. How should you generate a forecast using Tableaus default settings?

Q2. In a Tableau dashboard, you are working with a dataset that includes a numerical Customer Rating field ranging from 1 to 5. You want to ensure that every time this field is used in a visualization, it is sorted in descending order by default. What should you do to achieve this?

Q5. Your companys executives require a monthly update on overall business performance metrics. How should you configure a subscription in Tableau Server to meet this requirement?

Q7. In a Tableau project, you are working with a dataset that has a column named Qty_Sold, which represents the quantity of products sold. For clarity in your report, you want to rename this column to Units Sold. Which approach should you take in Tableau to correctly rename this column?

Q11. You are creating a Tableau visualization to display the total sales for each year. The dataset contains a Year column with yearly data. How should you use the Year field in your visualization to effectively display this annual sales data?

Q15. In a Tableau report, you are analyzing the accumulation of total customer support requests over time. The dataset includes Date and Number of Requests. You want to create an area chart to represent how the total number of requests has grown. How should you set up the area chart?

Q16. In a Tableau report focusing on sales performance, you have a field named Total Sales which is currently set as a dimension. However, you need to create visualizations showing the sum of sales. How should you treat the Total Sales field in this scenario?

Q18. You are creating a Tableau report where you need to analyze sales data by the day of the week. The dataset has a Date field, but the day of the week is not explicitly provided. How should you modify the Date field in Tableau to facilitate analysis by the day of the week?