Tableau Data Analyst Test - 11

Welcome to your Tableau Data Analyst – Test-11

Name

Phone

Q1. In a Tableau visualization, you are working with customer feedback data, which includes Customer Name, Feedback Category, and Feedback Score. You want to create a data table to show each customers feedback score in each category. How should you set up the data table?

Select 1 option(s):

Place ‘Customer Name‘ on the Rows shelf, ‘Feedback Category‘ on the Columns shelf, and ‘Feedback Score‘ on the Text shelf

Drag ‘Feedback Score‘ to the Rows shelf and ‘Customer Name‘ and ‘Feedback Category‘ to the Color shelf

Use ‘Feedback Score‘ on the Size shelf, and ‘Customer Name‘ and ‘Feedback Category‘ on the Rows shelf

Create a pie chart with ‘Feedback Score‘ and then change it to a data table

Q2. You are creating a Tableau dashboard that includes a bar chart, a line chart, and a filter. You want to organize these elements in a way that the filter affects both charts, and the charts are displayed side by side. What is the best approach to arrange these elements using containers and layout options?

Select 1 option(s):

Drag each chart and the filter into separate floating containers

Place both charts into a horizontal container and the filter into a vertical container next to it

Use a vertical container to hold both charts and the filter, arranging them vertically

Add the filter and both charts directly to the dashboard without containers, arranging them side by side

Q3. You are analyzing sales data in Tableau Prep and need to report on total sales by region and month. The dataset contains daily sales records with columns for Date, Region, and Sales Amount. Which transformation should you apply in Tableau Prep to prepare the data for this analysis?

Select 1 option(s):

Create a union of the data based on the ‘Region‘ column

Perform a join on the ‘Date‘ column

Aggregate the data by ‘Region‘ and ‘Month‘, summing up the ‘Sales Amount‘

Pivot the ‘Date‘ column to transform dates into rows

Q4. You are creating a Tableau story to present the year-over-year growth of a companys various departments. The story needs to guide the audience through each departments performance with appropriate visualizations and commentary. How should you structure the story points in Tableau?

Select 1 option(s):

Create a single dashboard combining all departmental data and use this as the only story point

Develop individual story points for each department, each with a customized visualization and narrative

Use one story point with a filter to switch between departments, avoiding individual points for each department

Arrange the story points alphabetically by department name, regardless of the performance data

Q5. You are working on a Tableau project analyzing retail sales data. The dataset is very large, spanning five years, but your current analysis only requires data from the last two years. To improve dashboard performance, what approach should you take when creating a data extract?

Select 1 option(s):

Create an extract of the entire dataset and use Tableau‘s filters to view the last two years

Apply an extract filter to include only data from the last two years

Manually delete data older than two years from the source file before creating the extract

Use a calculated field in Tableau to limit the view to the last two years

Q6. You are creating a Tableau report for a companys quarterly sales data. The report includes a table that shows sales by region and by product category within each region. You want to add totals for each region as well as an overall total for all regions. How should you configure the table in Tableau to display these totals?

Select 1 option(s):

Use a calculated field to manually sum up sales for each region and overall sales

Apply a filter to show only total sales figures

Enable subtotals for the region field and a grand total for the entire table

Create separate worksheets for each region‘s total and one for the overall total

Q7. In a Tableau report, you are analyzing the distribution of retail stores across different regions in the United States. The dataset includes fields for State, City, and Store Count. You want to create a symbol map to represent the number of stores in each city. Which approach should you take to effectively visualize this data on a symbol map?

Select 1 option(s):

Drag ‘State‘ and ‘City‘ to the map and use ‘Store Count‘ to determine the size of the symbols

Create a pie chart using ‘City‘ and ‘Store Count‘ without using a map

Use ‘State‘ as a filter and ‘Store Count‘ as a bar chart

Apply a heat map using ‘City‘ and ‘Store Count‘

Q8. You are working on a Tableau dashboard to analyze traffic data in a city. The dataset includes fields for Location, Number of Vehicles, and Time of Day. You want to create a heat map to visualize the density of traffic at different times of the day across various locations. Which approach should you take to create an effective heat map in Tableau?

Select 1 option(s):

Drag ‘Location‘ to the map and use ‘Number of Vehicles‘ to define the color intensity of the heat map

Create a symbol map using ‘Location‘ and use ‘Time of Day‘ to define the color of the symbols

Use ‘Time of Day‘ as a filter and ‘Number of Vehicles‘ as a bar chart

Create a line chart using ‘Time of Day‘ and ‘Number of Vehicles‘, without a map

Q9. You are creating a Tableau dashboard to visualize the market share of different products sold by a company. The dataset includes fields for Product Name and Total Sales. You want to use a pie chart to represent each products contribution to total sales. What steps should you follow to create this pie chart in Tableau?

Select 1 option(s):

Drag ‘Product Name‘ to the Rows shelf and ‘Total Sales‘ to the Color shelf

Place ‘Total Sales‘ on the Columns shelf and ‘Product Name‘ on the Rows shelf, then select the pie chart type

Use ‘Product Name‘ on the Columns shelf and ‘Total Sales‘ on the Angle shelf, selecting the pie chart type

Create a bar chart with ‘Product Name‘ and ‘Total Sales‘, then convert it to a pie chart

Q10. In a Tableau visualization, you are analyzing sales data for different stores in various regions. The dataset includes Store Location, Sales Amount, and Customer Traffic. You want to create a heat map to show where sales are highest, factoring in customer traffic. How should you structure the visualization to create this heat map?

Select 1 option(s):

Create a symbol map with ‘Store Location‘ and use ‘Sales Amount‘ to determine the size of the symbols

Use ‘Sales Amount‘ and ‘Customer Traffic‘ to create a dual-axis map

Drag ‘Store Location‘ to the map and use ‘Sales Amount‘ for color intensity, factoring in ‘Customer Traffic‘

Implement a scatter plot using ‘Sales Amount‘ and ‘Customer Traffic‘ without geographic mapping

Q11. You are creating a Tableau visualization of sales data and want to sort the data by sales regions in descending order based on total sales. The dataset includes Region and Total Sales. What is the correct approach to sort the data as required?

Select 1 option(s):

Drag ‘Region‘ to the Rows shelf and ‘Total Sales‘ to the Columns shelf, then apply a descending sort on the ‘Region‘ field

Place ‘Total Sales‘ on the Rows shelf and ‘Region‘ on the Columns shelf, then apply a descending sort on the ‘Total Sales‘ field

Use a calculated field to determine the total sales per region and apply a descending sort on this field

Create a bar chart with ‘Region‘ and ‘Total Sales‘, then manually rearrange the bars in descending order of sales

Q12. In a Tableau report, you are analyzing product sales data and want to sort the products by a custom order based on their category ranking, which is not based on sales or alphabetical order. The dataset includes Product, Category, and Sales. How should you implement this custom sort?

Select 1 option(s):

Apply a default ascending sort on the ‘Category‘ field

Drag ‘Category‘ to the Rows shelf and ‘Sales‘ to the Columns shelf, then sort ‘Category‘ based on a custom list

Use a parameter to manually set the order of the categories, then sort ‘Category‘ based on this parameter

Create a calculated field to assign a rank to each category, then sort the products based on this calculated field

Q13. In a Tableau visualization analyzing monthly sales data, you need to create a trend line that shows the progression of sales over time. The dataset includes a Month field formatted as January, February, etc. What is the appropriate way to use the Month field for this analysis?

Select 1 option(s):

Convert the ‘Month‘ field to a discrete dimension to separate each month

Keep the ‘Month‘ field as a continuous dimension to create a smooth trend line

Use the ‘Month‘ field as a continuous measure for a cumulative sales graph

Convert the ‘Month‘ field to a discrete measure to compare individual months

Q14. In a Tableau visualization for a companys monthly revenue over several years, you observe that recent changes in the business model have significantly altered revenue patterns. You want to adjust the forecasting model to place more emphasis on more recent data. What approach should you take to customize the forecast in Tableau?

Select 1 option(s):

Apply a filter to the visualization to only include recent data in the forecast

In the forecast options, adjust the model to give more weight to recent data

Create a calculated field that emphasizes recent revenue data

Use a moving average line instead of a forecast to highlight recent changes

Q15. In a Tableau dashboard, you are visualizing a companys monthly sales data over the past year using a bar chart. You want to add a line to the chart that represents the average monthly sales for the year. How should you incorporate this average line in Tableau?

Select 1 option(s):

Create a calculated field for the average sales and use it as a measure on the bar chart

Right-click on the visualization, select ‘Analytics‘, and drag ‘Average Line‘ to the view

Apply a parameter that allows users to input the average sales value manually

Use a dual-axis chart to display the average sales as a separate line chart

Q16. In a Tableau dashboard, you are combining a scatter plot, a histogram, and a descriptive text box. You want the scatter plot and histogram to be the primary focus, with the text box positioned below them. How should you utilize containers and layout options to achieve this arrangement?

Select 1 option(s):

Place the scatter plot and histogram in a horizontal container and the text box in a separate horizontal container below it

Drag the scatter plot, histogram, and text box into a single vertical container

Use a vertical container for the scatter plot and histogram, and a floating container for the text box

Add the text box into a vertical container and the scatter plot and histogram into a horizontal container above it

Q17. You are analyzing a dataset in Tableau that includes a numerical field Customer Rating, which is currently set as a measure. You need to create a visualization that displays the distribution of ratings as distinct categories. How should you treat the Customer Rating field for this purpose?

Select 1 option(s):

Keep ‘Customer Rating‘ as a measure and use it to calculate the average rating

Convert ‘Customer Rating‘ from a measure to a dimension to categorize ratings

Use ‘Customer Rating‘ as a measure to create a histogram

Create a calculated field to convert the ratings into percentage format

Q18. In Tableau Prep, you are working with a survey dataset where each row represents a respondent and columns represent their responses to various questions (e.g., Question1, Question2, Question10). You want to analyze the frequency of each response to all questions. What is the best way to transform this data?

Select 1 option(s):

Perform a join on the question columns

Pivot the question columns to create a ‘Question‘ column and a ‘Response‘ column

Aggregate the data based on the question columns

Use a union to combine the responses of all questions

Q19. You are working on a Tableau report to analyze the relationship between a companys advertising spend and its sales over the past year. The dataset includes Month, Advertising Spend, and Sales Amount. You decide to create a combo chart (bar and line) to display this information. How should you set up this combo chart in Tableau?

Select 1 option(s):

Drag ‘Month‘ to the Columns shelf, place ‘Advertising Spend‘ on the Rows shelf as a bar chart, and overlay ‘Sales Amount‘ as a line chart

Place ‘Advertising Spend‘ and ‘Sales Amount‘ on the Rows shelf, ‘Month‘ on the Columns shelf, and then create separate bar charts for each metric

Use ‘Month‘ on the Rows shelf, ‘Advertising Spend‘ on the Color shelf, and ‘Sales Amount‘ as a line chart.

Create a dual-axis chart with ‘Advertising Spend‘ and ‘Sales Amount‘, using bars for both

Q20. In a Tableau visualization, you are working with sales data over several years and want to predict future sales trends. The data includes monthly sales figures and various economic indicators. How can you create a predictive model in Tableau to forecast future sales?

Select 1 option(s):

Use the ‘Trend Line‘ feature in the Analytics pane, incorporating economic indicators to predict future sales

Implement a ‘Parameter‘ that allows users to input their sales predictions

Apply a ‘Box Plot‘ to estimate future sales based on historical data distribution

Create a ‘Histogram‘ to visualize the frequency of sales and extrapolate future trends

Q21. You are using Tableau to analyze and forecast sales data for a retail company. The data shows seasonal trends and you need to adjust the forecasting model to account for these trends accurately. How can you customize the forecasting model in Tableau to better reflect the seasonal nature of the sales data?

Select 1 option(s):

Use a linear trend line to model the sales data, as it best fits seasonal trends

Adjust the forecast model to a polynomial trend line for more complex seasonal patterns

In the forecast options, change the forecast model to include seasonality adjustments

Create a calculated field to manually model the seasonal trends in sales

Q22. You are working with a dataset in Tableau that includes a field named ProdID, which refers to product IDs. Each ProdID corresponds to a specific product name. For better readability in your reports, you want to display the product names instead of the ProdID values. What is the best approach to achieve this in Tableau?

Select 1 option(s):

Change the field name from ‘ProdID‘ to the product name directly in the data source

Use a calculated field to replace each ‘ProdID‘ with its corresponding product name

Create aliases for the ‘ProdID‘ field to display the corresponding product names

Apply a filter on the ‘ProdID‘ field to display only the desired product names

Q23. In a Tableau report, you are analyzing a dataset that includes Product Category, Customer Satisfaction Score, and Number of Products Sold. You want to create a bubble chart to visualize how customer satisfaction correlates with the number of products sold in each category. What is the correct way to set up this bubble chart?

Select 1 option(s):

Drag ‘Product Category‘ to the Rows shelf, ‘Customer Satisfaction Score‘ to the Columns shelf, and ‘Number of Products Sold‘ to the Size shelf

Place ‘Customer Satisfaction Score‘ on the Rows shelf and ‘Number of Products Sold‘ on the Size shelf

Use ‘Product Category‘ on the Color shelf, ‘Customer Satisfaction Score‘ on the Rows shelf, and ‘Number of Products Sold‘ on the Columns shelf

Create a bar chart with ‘Customer Satisfaction Score‘ and ‘Number of Products Sold‘, then change it to a bubble chart

Q24. In a Tableau dashboard tracking monthly departmental expenses, you want to set an alert to inform department heads if their expenses exceed the allocated budget. What is the best approach to set this alert?

Select 1 option(s):

Configure an alert to notify department heads when their monthly expenses are updated

Create an alert on the expense visualization that triggers if expenses exceed the budget

Set an alert to send monthly expense reports to all department heads

Establish an alert that triggers at the beginning of each month

Q25. In a Tableau report, you are working with a dataset containing monthly customer acquisition data for a tech company. To assess long-term trends, you decide to add a trend line to your time series visualization. Considering the data shows both seasonal fluctuations and overall growth, what type of trend line would be most appropriate?

Select 1 option(s):

A linear trend line to represent the steady growth of customer acquisitions

An exponential trend line to reflect rapid growth in customer acquisitions

A logarithmic trend line to model the initial rapid growth that stabilizes over time

A polynomial trend line to capture both the seasonal fluctuations and overall growth trend

Q26. You are creating a Tableau dashboard to analyze a companys sales and profit trends over time. The dataset includes Month, Sales, and Profit. You decide to use a dual-axis chart to display both trends on the same graph. What steps should you follow to create a dual-axis chart in Tableau?

Select 1 option(s):

Drag ‘Month‘ to the Columns shelf, ‘Sales‘ to the Rows shelf, then add ‘Profit‘ to the same axis as a dual-axis and synchronize the axes

Place ‘Sales‘ and ‘Profit‘ on the Rows shelf, ‘Month‘ on the Columns shelf, then create separate charts for each metric and overlay them

Use ‘Month‘ on the Rows shelf, ‘Sales‘ on the Color shelf, and ‘Profit‘ on the Size shelf

Create a bar chart for ‘Sales‘ and a line chart for ‘Profit‘, then merge them into a single view

Q27. In a Tableau report, you are examining a companys yearly revenue growth and wish to project this growth into the next year. Your visualization is a line chart showing revenue over the last five years. What is the most appropriate method to add a revenue growth forecast for the next year?

Select 1 option(s):

Extend the line chart manually by extrapolating the existing revenue trend

Drag and drop a trend line from the Analytics pane onto the line chart

Select the ‘Forecast‘ option in the Analytics pane and apply it to the revenue line chart

Create a new calculated field that estimates revenue growth based on historical data

Q28. In a Tableau visualization, you are using a field named RegionCode which includes codes like NAM, APAC, EMEA, etc., representing different geographical regions. For clarity in your visualizations, you want these codes to display as full region names like North America, Asia Pacific, Europe, Middle East & Africa, etc. How should you handle the RegionCode field?

Select 1 option(s):

Change the data type of ‘RegionCode‘ from string to geographic and rename the values

Create a calculated field that maps each ‘RegionCode‘ to its full region name

Create aliases for the ‘RegionCode‘ field to display the full region names

Replace the ‘RegionCode‘ field in the data source with the full region names

Q29. In Tableau, you are creating a visualization to track the progress of various stages in a manufacturing process. The dataset includes Stage Name, Start Date, and Completion Date for each stage. How should you set up a Gantt chart to visualize the duration and overlap of these stages?

Select 1 option(s):

Drag ‘Stage Name‘ to the Rows shelf, ‘Start Date‘ to the Columns shelf, and ‘Completion Date‘ to the Size shelf

Place ‘Start Date‘ and ‘Completion Date‘ on the Columns shelf, and ‘Stage Name‘ on the Rows shelf

Use ‘Stage Name‘ on the Columns shelf and ‘Start Date‘ on the Rows shelf, with ‘Completion Date‘ determining the bar length

Create a timeline with ‘Start Date‘ and ‘Completion Date‘, then change it to a Gantt chart

Q30. You are creating a Tableau visualization for a companys annual employee satisfaction survey results. The dataset includes various satisfaction metrics, and you want to show the range where 50% of responses fall for each metric. Which feature should you use in Tableau to display this data effectively?

Select 1 option(s):

Apply a box-and-whisker plot to show the distribution of responses for each metric

Use distribution bands to highlight the middle 50% range for each satisfaction metric

Create a calculated field to determine the median and quartiles for each metric

Implement a histogram to visualize the distribution of survey responses

Q31. You are tasked with preparing a dataset in Tableau Prep for a marketing analysis project. The dataset includes customer data with fields for FirstName, LastName, and Email. However, for privacy reasons, you need to anonymize the customer names while keeping the email addresses intact for communications. Which data transformation should you perform in Tableau Prep?

Select 1 option(s):

Pivot the ‘FirstName‘ and ‘LastName‘ columns into rows

Aggregate the data by ‘Email‘ and exclude ‘FirstName‘ and ‘LastName

Replace ‘FirstName‘ and ‘LastName‘ with null values or a placeholder text

Split the ‘Email‘ field into multiple columns

Q32. In a Tableau visualization, you are exploring the correlation between customer satisfaction ratings and the number of support tickets resolved by staff. The dataset includes Customer Satisfaction and Tickets Resolved. What is the correct way to set up a scatter plot to investigate this correlation?

Select 1 option(s):

Drag ‘Customer Satisfaction‘ to the Columns shelf and ‘Tickets Resolved‘ to the Rows shelf, then select the scatter plot type

Place ‘Customer Satisfaction‘ on the Color shelf and ‘Tickets Resolved‘ on the Size shelf

Use ‘Customer Satisfaction‘ and ‘Tickets Resolved‘ to create a line chart, then convert it to a scatter plot

Create a pie chart with ‘Customer Satisfaction‘ and ‘Tickets Resolved‘, then change it to a scatter plot

Q33. You are working on a dataset in Tableau Prep that consists of monthly sales data for the year 2022. The data is spread across twelve separate Excel files, one for each month, with identical column structures. Your task is to create a single unified dataset for the entire year. What is the most appropriate method to combine these files in Tableau Prep?

Select 1 option(s):

Use a join to combine the twelve files based on the month column

Create a union of all twelve files

Perform a cross-database join on the files

Aggregate the data in each file and then join them

Q34. You are using Tableau Prep to analyze inventory data. You have one dataset with product details (including product IDs and descriptions) and another dataset with inventory levels (including product IDs and quantities). To assess inventory status for each product, how should you combine these datasets?

Select 1 option(s):

Create a union of both datasets using the product IDs

Aggregate data in each dataset based on product IDs and then join

Perform a join on the product ID field

Use data blending on product ID after importing both datasets into Tableau

Q35. In Tableau Prep, you are tasked with preparing a dataset for analysis of website traffic. The data includes hourly records of website visits, with columns Hour, Visitor Count, and Page. Your goal is to analyze the average number of visits per page per day. What transformation should you apply to the data?

Select 1 option(s):

Pivot the ‘Hour‘ column to organize hourly records into separate columns

Join the data on the ‘Page‘ column

Union the data by the ‘Hour‘ column

Aggregate the data by ‘Page‘, calculating the average ‘Visitor Count‘ per day

Q36. In Tableau Prep, you are tasked with combining quarterly financial reports from different departments. Each report is in a separate CSV file with identical columns such as Revenue, Expenses, and Profit. How should you combine these files for a holistic annual financial analysis?

Select 1 option(s):

Perform a join on the department name column

Use a union to combine the CSV files

Apply a cross-database join for the files

Aggregate data within each file before combining

Q37. In a Tableau visualization, you are working with customer satisfaction survey data for different service categories over several months. The dataset includes Month, Service Category, and Satisfaction Score. You want to create a highlight table to easily identify trends and patterns in customer satisfaction. How should you set up the highlight table?

Select 1 option(s):

Drag ‘Month‘ to the Rows shelf, ‘Service Category‘ to the Columns shelf, and ‘Satisfaction Score‘ to the Color shelf

Place ‘Satisfaction Score‘ on the Rows shelf, ‘Month‘ and ‘Service Category‘ on the Columns shelf, and use a line chart

Use ‘Month‘ and ‘Service Category‘ on the Size shelf, and ‘Satisfaction Score‘ on the Color shelf

Create a pie chart with ‘Month‘ and ‘Service Category‘, then convert it to a highlight table

Q38. In a Tableau visualization analyzing stock market data, you want to highlight periods where the stock price was within a specific range deemed safe by analysts. The dataset includes daily closing prices. How should you use reference bands to indicate this safe price range on a line chart?

Select 1 option(s):

Create a calculated field to define the safe range and use it to color the line chart

Apply a filter to only show data points within the safe range

Add a reference band to the line chart, setting the upper and lower boundaries to the defined safe price range

Use a parameter to allow users to select the safe range and display it as a reference line

Q39. In a Tableau report, you are analyzing a companys monthly sales data and want to add a reference line to show the average sales across the year. The report includes a bar chart with months on the x-axis and sales figures on the y-axis. How should you add a reference line to indicate the average sales?

Select 1 option(s):

Use a calculated field to create a new average sales value for each month and add it to the bar chart

Drag the ‘Average Sales‘ measure to the y-axis and select ‘Dual Axis‘

Right-click on the y-axis, select ‘Add Reference Line‘, and then choose ‘Average‘ from the list of options

Create a parameter that allows users to set and display the average sales line

Q40. In a Tableau report, you are examining educational attainment levels across various counties in a region. The dataset includes County and Percentage of Population with Higher Education. Your goal is to visualize which counties have higher education levels. Which map type should you utilize to effectively represent this data?

Select 1 option(s):

Create a density map showing the concentration of educated individuals in each county

Use a choropleth (filled) map, coloring each county based on the ‘Percentage of Population with Higher Education‘

Implement a symbol map with symbols sized according to education levels in each county

Develop a heat map based on the geographic distribution of educational institutions

Q41. In a Tableau report, you are analyzing the distribution of retail stores across a region. The dataset includes fields for Store Location (latitude and longitude) and Store Size. You want to create a visualization to show where store concentrations are highest. What is the best type of map to use for this analysis?

Select 1 option(s):

Create a symbol map where each store is represented by a symbol, sized by ‘Store Size‘

Use a density map to show the concentration of stores based on their location

Implement a heat map using ‘Store Size‘ to indicate the density of stores

Create a line map connecting all store locations

Q42. Your organization is merging sales data from different regions, each with its own dataset in Tableau Prep. The datasets have a common structure, but the ProductID field uses different formats across regions (e.g., numerical in some, alphanumeric in others). You need to standardize this field for a unified analysis. What transformation should you apply in Tableau Prep?

Select 1 option(s):

Pivot the ‘ProductID‘ field across all datasets

Join all datasets based on the ‘ProductID‘ field

Perform a cleaning operation to standardize the format of the ‘ProductID‘ field across all datasets

Aggregate the datasets based on the ‘ProductID‘ field

Q43. You are tasked with visualizing population density across different neighborhoods in a city using Tableau. The dataset includes Neighborhood names and Population numbers. Which approach should you take to create a density map that effectively represents population density in each neighborhood?

Select 1 option(s):

Use a symbol map with ‘Neighborhood‘ as the location and size the symbols based on ‘Population‘

Create a heat map using ‘Population‘ numbers, without specific location data

Create a density map using geographical data for ‘Neighborhood‘ and ‘Population‘ as the measure

Implement a bar chart using ‘Neighborhood‘ and ‘Population‘

Q44. You have a Tableau dashboard connected to a data source that receives large updates weekly. To manage server load, when should you schedule the extract refresh?

Select 1 option(s):

Immediately after the data source receives the update

Randomly throughout the week

During peak business hours on the day of the data update

During off-peak hours shortly after the weekly data update

Q45. In a Tableau report, you are analyzing the change in a stocks price over the last year. You decide to use a line chart to represent the stocks daily closing prices. The dataset includes fields for Date and Closing Price. How should you set up the line chart?

Select 1 option(s):

Drag ‘Closing Price‘ to the Rows shelf and ‘Date‘ to the Columns shelf, then select the line chart type

Use ‘Closing Price‘ on the Color shelf and ‘Date‘ on the Columns shelf

Place ‘Date‘ on the Rows shelf and ‘Closing Price‘ on the Size shelf, choosing the line chart type

Create a bar chart with ‘Date‘ and ‘Closing Price‘, then convert it to a line chart

Q46. You are creating a Tableau visualization to display the year-over-year growth rate of a companys revenue. You want to add a reference line that shows the overall average growth rate across multiple years. The visualization is a line chart with years on the x-axis and growth rate on the y-axis. What is the best way to add this reference line for the average growth rate?

Select 1 option(s):

Apply a filter to show only the average growth rate each year

Create a calculated field for the average growth rate and use it as a line in the chart

Right-click on the y-axis, choose ‘Add Reference Line‘, and set it to display the average of the growth rate

Use a parameter to allow users to manually input and display the average growth rate

Q47. In a Tableau story aiming to analyze the market trends of different product categories, you need to highlight key findings and guide the audience through a data-driven narrative. The story involves complex data comparisons. What approach should you take when creating the story points?

Select 1 option(s):

Combine all product categories into a single story point to provide a comprehensive overview

Create separate story points for each product category, focusing on specific trends and insights in each point

Use a complex visualization that includes all product categories and add it as the sole story point

Arrange the story points based on the number of products in each category, not the market trends

Q48. You are creating a Tableau dashboard to visualize global sales data. The dataset includes fields for Country, Sales, and Profit. You want to create a symbol map to display each countrys sales and profit data. What steps should you follow to create an effective symbol map in Tableau?

Select 1 option(s):

Drag the ‘Country‘ field to Rows and ‘Sales‘ to Columns, then select the map visualization type

Use the ‘Country‘ field to create a geographical field in the visualization, and use ‘Sales‘ and ‘Profit‘ as size and color attributes of the symbols

Create a calculated field combining ‘Sales‘ and ‘Profit‘, then use this field on a standard bar chart

Drag the ‘Country‘ field to the filter shelf and apply filters for desired countries, then create a scatter plot

Q49. In Tableau Prep, you are preparing data for a sales analysis report. You have two datasets: one containing sales transactions (including transaction IDs and amounts) and another containing detailed customer information (including customer IDs and demographics). Both datasets have a common Customer ID field. How should you combine these datasets to analyze sales amounts by customer demographics?

Select 1 option(s):

Use a union to combine the datasets based on the ‘Customer ID‘

Perform a join on the ‘Customer ID‘ field

Create a calculated field that merges ‘Customer ID‘ from both datasets

Pivot the ‘Customer ID‘ field in both datasets before combining

Q50. In a Tableau dashboard meant to track key performance indicators (KPIs), you need to include several charts, a logo image, and an interactive filter. What is the best practice for adding these objects to your dashboard?

Select 1 option(s):

Add the charts and logo as floating objects and the filter as a tiled object

Place the charts and interactive filter as tiled objects and the logo as a floating object

Use floating objects for both the charts and interactive filter, and add the logo as a tiled object

Combine the charts, logo, and filter into a single image and add it as a floating object

Q51. You are analyzing a dataset in Tableau containing the ages of participants in a study. You want to create a histogram to understand the distribution of ages within the group. Which steps should you follow to create an effective histogram in Tableau?

Select 1 option(s):

Drag the ‘Age‘ field to the Rows shelf and use a bar chart to represent the age distribution

Place the ‘Age‘ field on the Columns shelf and then select ‘Histogram‘ under the ‘Show Me‘ options

Use the ‘Age‘ field on the Color shelf to represent different age groups in the histogram

Create a calculated field to categorize the ages and use this to create a bar chart

Q53. You have developed a Tableau Prep workflow to clean and transform sales data that is updated weekly. To ensure the most current data is used for weekly reporting, how should you schedule the Tableau Prep workflow?

Select 1 option(s):

Schedule the workflow to run monthly

Run the workflow manually every week

Schedule the workflow to run immediately after the weekly data update

Schedule the workflow to run right before the weekly report is generated

Q53. You are creating a Tableau dashboard to compare the annual sales of different product categories in a retail store. You want to use a bar chart to display this comparison. What steps should you follow to create a basic bar chart that effectively represents the annual sales for each product category?

Select 1 option(s):

Drag the ‘Product Category‘ field to the Rows shelf and ‘Annual Sales‘ to the Color shelf

Place the ‘Annual Sales‘ field on the Columns shelf and ‘Product Category‘ on the Rows shelf

Use the ‘Product Category‘ field to create a pie chart and then convert it to a bar chart

Drag the ‘Annual Sales‘ field to the Filters shelf and ‘Product Category‘ to the Columns shelf

Q54. In preparing a dataset for a Tableau analysis focused on recent customer behavior, you decide to create an extract from a large database that includes customer interaction data over 10 years. However, for your analysis, only the data from the past 18 months is relevant. What is the best practice for creating this extract in Tableau?

Select 1 option(s):

Extract the entire dataset and rely on Tableau‘s visual filters to limit the analysis to the last 18 months

During the extract creation, apply a filter to only include data from the past 18 months

Import all the data into Tableau and then create a calculated field to exclude older data

Manually remove older data from the database before creating the extract

Q55. Your organizations financial data is refreshed in the system at the end of each month. To prepare this data for analysis using Tableau Prep, when should you ideally schedule the Tableau Prep workflow?

Select 1 option(s):

Schedule the workflow to run weekly

Schedule the workflow to run daily at midnight

Schedule the workflow to run at the end of each month after data refresh

Schedule the workflow to run at the beginning of each month

Q56. You are designing a Tableau dashboard for a sales report that needs to include a descriptive text area, a filter for sales region, and several visualizations. How should you add these objects to the dashboard effectively?

Select 1 option(s):

Use floating objects for the descriptive text, filter, and visualizations to place them precisely where you want

Drag the descriptive text object to the dashboard, then add the filter and visualizations as tiled objects

Add all objects as tiled, allowing Tableau to automatically adjust their layout

Create the visualizations and text as a single image object and add the filter as a floating object

Q57. In a Tableau visualization, you are working with a dataset that includes sales data by department and by individual salespersons within each department. You want to show the total sales for each department as well as the individual contributions of each salesperson. What approach should you take to appropriately summarize this data?

Select 1 option(s):

Implement row-level calculations to sum up sales for each salesperson and department

Enable subtotals for the department field and individual sales figures for each salesperson

Use a parameter to toggle between department totals and individual salesperson figures

Create a hierarchy from the department to the salesperson level and use it to show totals

Q58. You are creating a Tableau dashboard to analyze the distribution of healthcare facilities across different states in the USA. The dataset includes fields for State and Number of Facilities. You want to create a map that visually represents the number of facilities in each state. What type of map should you use to effectively display this data?

Select 1 option(s):

Create a symbol map with symbols sized based on the ‘Number of Facilities‘ for each state

Use a choropleth (filled) map, coloring each state based on the ‘Number of Facilities‘

Implement a heat map using ‘Number of Facilities‘ to indicate density

Create a line map showing connections between facilities in different states

Q59. In Tableau Prep, you are working on a dataset containing sales data for the last five years. However, for your current analysis, you only need to focus on the data from the most recent year. The dataset includes a Date column with the format YYYY-MM-DD. How should you filter the data to include only the records from the most recent year?

Select 1 option(s):

Create a calculated field that extracts the year from the ‘Date‘ column and filter on this field

Pivot the ‘Date‘ column to separate the data by year

Use a wildcard filter on the ‘Date‘ column to select the desired year

Apply a range filter on the ‘Date‘ column to include only the most recent year‘s data

Q60. Your Tableau dashboard relies on a data extract that needs to be updated regularly to reflect the latest sales figures. Which scheduling approach is most effective for keeping the dashboard up-to-date without overloading the server?

Select 1 option(s):

Schedule the extract to refresh every hour throughout the day and night

Schedule the extract to refresh daily during off-peak hours

Manually refresh the extract weekly

Schedule the extract to refresh monthly on the first day of the month

Tableau Data Analyst Test - 11

Q1. In a Tableau visualization, you are working with customer feedback data, which includes Customer Name, Feedback Category, and Feedback Score. You want to create a data table to show each customers feedback score in each category. How should you set up the data table?

Q3. You are analyzing sales data in Tableau Prep and need to report on total sales by region and month. The dataset contains daily sales records with columns for Date, Region, and Sales Amount. Which transformation should you apply in Tableau Prep to prepare the data for this analysis?

Q4. You are creating a Tableau story to present the year-over-year growth of a companys various departments. The story needs to guide the audience through each departments performance with appropriate visualizations and commentary. How should you structure the story points in Tableau?

Q5. You are working on a Tableau project analyzing retail sales data. The dataset is very large, spanning five years, but your current analysis only requires data from the last two years. To improve dashboard performance, what approach should you take when creating a data extract?

Q11. You are creating a Tableau visualization of sales data and want to sort the data by sales regions in descending order based on total sales. The dataset includes Region and Total Sales. What is the correct approach to sort the data as required?

Q12. In a Tableau report, you are analyzing product sales data and want to sort the products by a custom order based on their category ranking, which is not based on sales or alphabetical order. The dataset includes Product, Category, and Sales. How should you implement this custom sort?

Q13. In a Tableau visualization analyzing monthly sales data, you need to create a trend line that shows the progression of sales over time. The dataset includes a Month field formatted as January, February, etc. What is the appropriate way to use the Month field for this analysis?

Q15. In a Tableau dashboard, you are visualizing a companys monthly sales data over the past year using a bar chart. You want to add a line to the chart that represents the average monthly sales for the year. How should you incorporate this average line in Tableau?

Q16. In a Tableau dashboard, you are combining a scatter plot, a histogram, and a descriptive text box. You want the scatter plot and histogram to be the primary focus, with the text box positioned below them. How should you utilize containers and layout options to achieve this arrangement?

Q17. You are analyzing a dataset in Tableau that includes a numerical field Customer Rating, which is currently set as a measure. You need to create a visualization that displays the distribution of ratings as distinct categories. How should you treat the Customer Rating field for this purpose?

Q20. In a Tableau visualization, you are working with sales data over several years and want to predict future sales trends. The data includes monthly sales figures and various economic indicators. How can you create a predictive model in Tableau to forecast future sales?

Q24. In a Tableau dashboard tracking monthly departmental expenses, you want to set an alert to inform department heads if their expenses exceed the allocated budget. What is the best approach to set this alert?

Q26. You are creating a Tableau dashboard to analyze a companys sales and profit trends over time. The dataset includes Month, Sales, and Profit. You decide to use a dual-axis chart to display both trends on the same graph. What steps should you follow to create a dual-axis chart in Tableau?

Q27. In a Tableau report, you are examining a companys yearly revenue growth and wish to project this growth into the next year. Your visualization is a line chart showing revenue over the last five years. What is the most appropriate method to add a revenue growth forecast for the next year?

Q29. In Tableau, you are creating a visualization to track the progress of various stages in a manufacturing process. The dataset includes Stage Name, Start Date, and Completion Date for each stage. How should you set up a Gantt chart to visualize the duration and overlap of these stages?

Q36. In Tableau Prep, you are tasked with combining quarterly financial reports from different departments. Each report is in a separate CSV file with identical columns such as Revenue, Expenses, and Profit. How should you combine these files for a holistic annual financial analysis?

Q38. In a Tableau visualization analyzing stock market data, you want to highlight periods where the stock price was within a specific range deemed safe by analysts. The dataset includes daily closing prices. How should you use reference bands to indicate this safe price range on a line chart?

Q43. You are tasked with visualizing population density across different neighborhoods in a city using Tableau. The dataset includes Neighborhood names and Population numbers. Which approach should you take to create a density map that effectively represents population density in each neighborhood?

Q44. You have a Tableau dashboard connected to a data source that receives large updates weekly. To manage server load, when should you schedule the extract refresh?

Q45. In a Tableau report, you are analyzing the change in a stocks price over the last year. You decide to use a line chart to represent the stocks daily closing prices. The dataset includes fields for Date and Closing Price. How should you set up the line chart?

Q47. In a Tableau story aiming to analyze the market trends of different product categories, you need to highlight key findings and guide the audience through a data-driven narrative. The story involves complex data comparisons. What approach should you take when creating the story points?

Q48. You are creating a Tableau dashboard to visualize global sales data. The dataset includes fields for Country, Sales, and Profit. You want to create a symbol map to display each countrys sales and profit data. What steps should you follow to create an effective symbol map in Tableau?

Q50. In a Tableau dashboard meant to track key performance indicators (KPIs), you need to include several charts, a logo image, and an interactive filter. What is the best practice for adding these objects to your dashboard?

Q51. You are analyzing a dataset in Tableau containing the ages of participants in a study. You want to create a histogram to understand the distribution of ages within the group. Which steps should you follow to create an effective histogram in Tableau?

Q53. You have developed a Tableau Prep workflow to clean and transform sales data that is updated weekly. To ensure the most current data is used for weekly reporting, how should you schedule the Tableau Prep workflow?

Q55. Your organizations financial data is refreshed in the system at the end of each month. To prepare this data for analysis using Tableau Prep, when should you ideally schedule the Tableau Prep workflow?

Q56. You are designing a Tableau dashboard for a sales report that needs to include a descriptive text area, a filter for sales region, and several visualizations. How should you add these objects to the dashboard effectively?

Q60. Your Tableau dashboard relies on a data extract that needs to be updated regularly to reflect the latest sales figures. Which scheduling approach is most effective for keeping the dashboard up-to-date without overloading the server?

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!

Tableau Data Analyst Test - 11

Q1. In a Tableau visualization, you are working with customer feedback data, which includes Customer Name, Feedback Category, and Feedback Score. You want to create a data table to show each customers feedback score in each category. How should you set up the data table?

Q3. You are analyzing sales data in Tableau Prep and need to report on total sales by region and month. The dataset contains daily sales records with columns for Date, Region, and Sales Amount. Which transformation should you apply in Tableau Prep to prepare the data for this analysis?

Q4. You are creating a Tableau story to present the year-over-year growth of a companys various departments. The story needs to guide the audience through each departments performance with appropriate visualizations and commentary. How should you structure the story points in Tableau?

Q5. You are working on a Tableau project analyzing retail sales data. The dataset is very large, spanning five years, but your current analysis only requires data from the last two years. To improve dashboard performance, what approach should you take when creating a data extract?

Q11. You are creating a Tableau visualization of sales data and want to sort the data by sales regions in descending order based on total sales. The dataset includes Region and Total Sales. What is the correct approach to sort the data as required?

Q13. In a Tableau visualization analyzing monthly sales data, you need to create a trend line that shows the progression of sales over time. The dataset includes a Month field formatted as January, February, etc. What is the appropriate way to use the Month field for this analysis?

Q15. In a Tableau dashboard, you are visualizing a companys monthly sales data over the past year using a bar chart. You want to add a line to the chart that represents the average monthly sales for the year. How should you incorporate this average line in Tableau?

Q16. In a Tableau dashboard, you are combining a scatter plot, a histogram, and a descriptive text box. You want the scatter plot and histogram to be the primary focus, with the text box positioned below them. How should you utilize containers and layout options to achieve this arrangement?

Q20. In a Tableau visualization, you are working with sales data over several years and want to predict future sales trends. The data includes monthly sales figures and various economic indicators. How can you create a predictive model in Tableau to forecast future sales?

Q24. In a Tableau dashboard tracking monthly departmental expenses, you want to set an alert to inform department heads if their expenses exceed the allocated budget. What is the best approach to set this alert?

Q27. In a Tableau report, you are examining a companys yearly revenue growth and wish to project this growth into the next year. Your visualization is a line chart showing revenue over the last five years. What is the most appropriate method to add a revenue growth forecast for the next year?

Q36. In Tableau Prep, you are tasked with combining quarterly financial reports from different departments. Each report is in a separate CSV file with identical columns such as Revenue, Expenses, and Profit. How should you combine these files for a holistic annual financial analysis?

Q38. In a Tableau visualization analyzing stock market data, you want to highlight periods where the stock price was within a specific range deemed safe by analysts. The dataset includes daily closing prices. How should you use reference bands to indicate this safe price range on a line chart?

Q44. You have a Tableau dashboard connected to a data source that receives large updates weekly. To manage server load, when should you schedule the extract refresh?

Q45. In a Tableau report, you are analyzing the change in a stocks price over the last year. You decide to use a line chart to represent the stocks daily closing prices. The dataset includes fields for Date and Closing Price. How should you set up the line chart?

Q47. In a Tableau story aiming to analyze the market trends of different product categories, you need to highlight key findings and guide the audience through a data-driven narrative. The story involves complex data comparisons. What approach should you take when creating the story points?

Q50. In a Tableau dashboard meant to track key performance indicators (KPIs), you need to include several charts, a logo image, and an interactive filter. What is the best practice for adding these objects to your dashboard?

Q51. You are analyzing a dataset in Tableau containing the ages of participants in a study. You want to create a histogram to understand the distribution of ages within the group. Which steps should you follow to create an effective histogram in Tableau?

Q53. You have developed a Tableau Prep workflow to clean and transform sales data that is updated weekly. To ensure the most current data is used for weekly reporting, how should you schedule the Tableau Prep workflow?

Q55. Your organizations financial data is refreshed in the system at the end of each month. To prepare this data for analysis using Tableau Prep, when should you ideally schedule the Tableau Prep workflow?

Q56. You are designing a Tableau dashboard for a sales report that needs to include a descriptive text area, a filter for sales region, and several visualizations. How should you add these objects to the dashboard effectively?

Q60. Your Tableau dashboard relies on a data extract that needs to be updated regularly to reflect the latest sales figures. Which scheduling approach is most effective for keeping the dashboard up-to-date without overloading the server?

Q1. In a Tableau visualization, you are working with customer feedback data, which includes Customer Name, Feedback Category, and Feedback Score. You want to create a data table to show each customers feedback score in each category. How should you set up the data table?

Q3. You are analyzing sales data in Tableau Prep and need to report on total sales by region and month. The dataset contains daily sales records with columns for Date, Region, and Sales Amount. Which transformation should you apply in Tableau Prep to prepare the data for this analysis?

Q4. You are creating a Tableau story to present the year-over-year growth of a companys various departments. The story needs to guide the audience through each departments performance with appropriate visualizations and commentary. How should you structure the story points in Tableau?

Q11. You are creating a Tableau visualization of sales data and want to sort the data by sales regions in descending order based on total sales. The dataset includes Region and Total Sales. What is the correct approach to sort the data as required?

Q13. In a Tableau visualization analyzing monthly sales data, you need to create a trend line that shows the progression of sales over time. The dataset includes a Month field formatted as January, February, etc. What is the appropriate way to use the Month field for this analysis?

Q15. In a Tableau dashboard, you are visualizing a companys monthly sales data over the past year using a bar chart. You want to add a line to the chart that represents the average monthly sales for the year. How should you incorporate this average line in Tableau?

Q27. In a Tableau report, you are examining a companys yearly revenue growth and wish to project this growth into the next year. Your visualization is a line chart showing revenue over the last five years. What is the most appropriate method to add a revenue growth forecast for the next year?

Q36. In Tableau Prep, you are tasked with combining quarterly financial reports from different departments. Each report is in a separate CSV file with identical columns such as Revenue, Expenses, and Profit. How should you combine these files for a holistic annual financial analysis?

Q38. In a Tableau visualization analyzing stock market data, you want to highlight periods where the stock price was within a specific range deemed safe by analysts. The dataset includes daily closing prices. How should you use reference bands to indicate this safe price range on a line chart?

Q45. In a Tableau report, you are analyzing the change in a stocks price over the last year. You decide to use a line chart to represent the stocks daily closing prices. The dataset includes fields for Date and Closing Price. How should you set up the line chart?

Q55. Your organizations financial data is refreshed in the system at the end of each month. To prepare this data for analysis using Tableau Prep, when should you ideally schedule the Tableau Prep workflow?