Tableau Data Analyst Test - 10

Welcome to your Tableau Data Analyst – Test-10

Name

Phone

Q1. You have created a detailed Tableau visualization that needs to be included in a corporate PowerPoint presentation. Which export format should you use to ensure the best quality for presentation purposes?

Select 1 option(s):

Export as a Data Source (.tds) file

Export as a CSV file.

Export as an Image file

Export directly to PowerPoint

Q2. In a Tableau project, you are analyzing sales data from two different data sources. You want to apply a filter based on Region to both data sources. The Region field is common to both sources. What is the best approach to ensure the Region filter is applied consistently to visualizations from both data sources?

Select 1 option(s):

Create separate ‘Region‘ filters for each data source and apply them individually

Utilize data blending and apply a ‘Region‘ filter to the primary data source

Synchronize the ‘Region‘ field across data sources and apply a single filter

Create a dashboard action filter based on ‘Region‘ and apply it to all relevant sheets

Q3. You are analyzing customer data in Tableau and want to identify a group of high-value customers based on their total purchase amount. The dataset includes fields for Customer ID and Total Purchase Amount. Which approach should you take to create a set of high-value customers?

Select 1 option(s):

Apply a filter to the ‘Total Purchase Amount‘ field to show only customers with amounts above a certain threshold

Create a calculated field to categorize customers as high-value based on their purchase amounts

Use a parameter to allow users to define what constitutes a high-value customer

Create a set based on the ‘Total Purchase Amount‘ field to include customers with amounts above a specified threshold

Q4. In a Tableau dashboard, you are creating an interactive report for sales analysis. You want users to be able to choose a specific year from a dropdown menu to view sales data for that year. The dataset includes a Date field. How should you set up a parameter and use it with a filter to enable this functionality?

Select 1 option(s):

Create a parameter with a list of years and use it directly as a filter on the ‘Date‘ field

Create a calculated field that returns true if the year of the ‘Date‘ field matches the parameter, and then use this calculated field as a filter

Use the parameter to dynamically set the range of a date filter

Apply the parameter in a RANK function and filter based on the rank

Q5. You are creating a Tableau dashboard for a marketing team to analyze social media engagement. The team wants to focus on posts that are among the top 10% in terms of engagement. The dataset includes fields for Post ID and Engagement Score. How should you configure the filter settings to display only these top-performing posts?

Select 1 option(s):

Use a range filter on the ‘Engagement Score‘ field to select scores in the top 10%

Apply a Top N filter on the ‘Engagement Score‘ field, setting it to display the top 10% of posts

Create a set based on the ‘Engagement Score‘ field to include only posts in the top 10%

Implement a wildcard filter on the ‘Engagement Score‘ field to select the top 10% of scores

Q6. You want to add a feature in your Tableau dashboard that allows users to navigate from the main dashboard to a detailed view of sales data. What is the most efficient way to implement this?

Select 1 option(s):

Use a Parameter control to switch views

Create a Filter Action to change the view

Add a Navigation Button for direct access to the detailed sales view

Implement a Dashboard Action to redirect to the detailed view

Q7. In a Tableau report on sales data, you want to exclude products with minimal impact on overall sales to streamline the analysis. The dataset includes a Product Name field and a Sales Amount field. Which filter setting should you use to exclude products that fall in the bottom 5% of sales?

Select 1 option(s):

Apply a Bottom N filter on the ‘Sales Amount‘ field, setting it to exclude the bottom 5% of products

Use a range filter on the ‘Sales Amount‘ field to exclude sales amounts in the bottom 5%

Implement a conditional filter on the ‘Sales Amount‘ field, using a formula to exclude the bottom 5% of products

Create a set based on the ‘Sales Amount‘ field to exclude products in the bottom 5% of sales

Q8. You need to print a Tableau dashboard for a presentation, and its crucial that all visualizations and texts are clearly legible in the printed version. What setting should you adjust before printing?

Select 1 option(s):

Set the dashboard to the default size setting

Change the dashboard size to a fixed size that matches the print layout

Print directly from the current view without changing any settings

Convert all visualizations to images before printing

Q9. In a Tableau dashboard, you are tasked with applying a filter to a view that allows users to dynamically select a date range for sales data. Which of the following methods is the most appropriate for adding this interactivity?

Select 1 option(s):

Use a Parameter Control to select specific dates

Apply a Relative Date Filter for predefined ranges.

Implement a Data Blending feature to integrate date fields

Create a Calculated Field for date selection

Q10. You receive an Excel file containing sales data for analysis in Tableau. The first few rows of the file are headers and footnotes, and the actual data begins from row 5. Additionally, the file contains merged cells and some irregular formatting. What is the first step you should take in Tableau to prepare this data for analysis?

Select 1 option(s):

Manually edit the Excel file to remove headers and footnotes before importing it into Tableau

Use Tableau‘s Data Interpreter to clean and format the data correctly

Create calculated fields in Tableau to address the irregularities in the data

Import the data as is into Tableau and use filters to exclude the headers and footnotes

Q11. You are working on a complex Tableau project that involves a large dataset with numerous fields across different categories like sales, customer demographics, and product information. To improve the efficiency of your analysis, what is the best practice for organizing these fields within Tableau?

Select 1 option(s):

Group all fields into a single folder for ease of access

Organize the fields into separate folders based on their categories (e.g., Sales, Customer Demographics, Product Information)

Avoid using folders and instead rename each field to include the category as a prefix

Create calculated fields to combine similar categories and place them in a single folder

Q12. You are working on a Tableau dashboard that includes multiple sheets, each using data from the same data source. You need to apply a filter to show only the current years data across all sheets. What is the most efficient way to apply this filter to the entire dashboard?

Select 1 option(s):

Apply the filter to each sheet individually

Create a global filter by applying the filter to one sheet and then selecting “Apply to Worksheets“ -> “All Using This Data Source“

Use a parameter to control the year across all sheets

Create a calculated field for the current year and use it as a filter

Q13. In your Tableau dashboard, you need to instruct users to click on a specific chart to filter other components of the dashboard. Which approach is most effective for conveying this instruction?

Select 1 option(s):

Configure a Quick Filter with the instruction

Add a Navigation Button with the guideline

Insert a Text Object near the chart with the instruction

Create a Dynamic Caption that changes to show the instruction

Q14. In a Tableau report, you are analyzing sales data and want to analyze the distribution of sales amounts. The sales amounts vary widely, and you decide to group these sales into bins of equal monetary value to understand the distribution better. What approach should you take to create these bins in Tableau?

Select 1 option(s):

Create a calculated field to categorize sales into different ranges

Use a parameter to allow users to define their own sales amount groupings

Implement the binning feature on the ‘Sales Amount‘ field to create bins of equal size

Apply a Top N filter on the ‘Sales Amount‘ field to categorize the sales

Q15. In a Tableau dashboard, you need to create an interaction where selecting a product category in one chart dynamically filters the data displayed in another chart. Which action should you add to achieve this?

Select 1 option(s):

Add a URL action to link between the two charts.

Implement a Highlight action to emphasize the selected category.

Use a Filter action to link the selection between charts.

Create a Parameter control to manage the filter across charts.

Q16. In a Tableau visualization, you are working with a dataset that includes a variety of customer feedback comments. To analyze common themes, you want to group similar comments together. The dataset has a Comments field. What is the best way to structure this data for thematic analysis in Tableau?

Select 1 option(s):

Create a set for each common theme identified in the comments

Implement a calculated field to classify comments based on keywords

Manually group similar comments into themes and analyze these groups

Use a parameter to allow users to categorize comments based on their interpretation

Q17. When preparing to print a Tableau worksheet for a report, what is the best practice to ensure that all data and visualizations are accurately represented in the printout?

Select 1 option(s):

Print the worksheet in landscape mode regardless of its original layout

Use the ‘Fit All‘ option in the print settings to ensure all content is included

Select a high-contrast color scheme for better visibility in the printout

Preview the print layout and adjust the worksheet view as necessary before printing

Q18. You are developing a Tableau visualization where users should be able to filter data based on a range of sales amounts. The dataset includes a Sales field. You decide to use two parameters, Minimum Sales and Maximum Sales, to define this range. How should you integrate these parameters with a filter to achieve the desired interactivity?

Select 1 option(s):

Directly apply the ‘Minimum Sales‘ and ‘Maximum Sales‘ parameters as a range filter on the ‘Sales‘ field

Create a calculated field that checks if ‘Sales‘ is between ‘Minimum Sales‘ and ‘Maximum Sales‘, and use this field as a filter

Use the parameters to dynamically adjust the bins of a histogram of sales

Set the parameters to control the top and bottom N filters on the ‘Sales‘ field

Q19. In your Tableau dashboard, you need to create a user-friendly method for returning from a detailed product analysis page to the main dashboard. Which approach should you use?

Select 1 option(s):

Implement a Calculated Field to navigate back to the main dashboard

Add a Navigation Button that takes the user back to the main dashboard

Use a Quick Filter for returning to the main dashboard

Configure a URL Action to link back to the main dashboard

Q20. In a Tableau workbook, you are dealing with a dataset that includes a variety of fields related to financial metrics, geographical information, and time periods. You want to streamline the process of creating dashboards and reports for different teams. How should you organize these fields to facilitate this process?

Select 1 option(s):

Place all fields in a default folder without categorization

Organize fields into folders named after the teams that will use them

Categorize fields into folders based on their nature (e.g., Financial Metrics, Geographical Information, Time Periods)

Organize fields alphabetically in a single folder for uniformity

Q21. You want to enable users to click on a state in a map view on a Tableau dashboard, which will then open a website showing tourism information for that state. Which action should be configured to achieve this functionality?

Select 1 option(s):

Configure a Filter action to display state-specific data

Set up a Highlight action for the selected state

Implement a URL action that directs to the tourism website

Use a Parameter control to select the state and link to the website

Q22. You are analyzing sales data in Tableau and have two separate data sources: one containing sales transactions and the other containing product information. Each transaction record includes a product ID that matches an ID in the product information dataset. Your analysis requires combining these datasets to provide insights into sales performance by product category. What is the most appropriate method to integrate these data sources in Tableau?

Select 1 option(s):

Use data blending to combine the datasets based on the product ID

Create a union of the two datasets

Establish a relationship between the two datasets using the product ID

Perform a cross-database join using the product ID

Q23. In a Tableau visualization, you are working with sales data and need to compare the performance of top-performing products against all other products. The dataset includes Product ID and Sales fields. How should you structure the data to facilitate this analysis?

Select 1 option(s):

Apply a Top N filter on the ‘Sales‘ field to identify top-performing products

Create a set for top-performing products based on their sales ranking

Use a calculated field to label products as ‘Top-Performing‘ or ‘Others‘

Implement a parameter to allow users to select which products are considered top-performing

Q24. You are designing an interactive dashboard in Tableau where users should be able to filter a product sales view by region. What is the best approach to enable this filtering feature?

Select 1 option(s):

Embed a Web Page object with external filtering options

Use a Quick Filter on the ‘Region‘ field

Create a Group based on the ‘Region‘ field and use it for filtering

Utilize a Histogram to filter by region

Q25. You are designing a Tableau dashboard and want to guide users on how to interact with a complex chart. What is the best method to instruct users to hover over data points for more information?

Select 1 option(s):

Add a Calculated Field to display instructions

Implement a Tooltip that contains user instructions

Use a Dashboard Action for displaying guidance

Place a Text Object with instructions near the chart

Q26. You are working on a Tableau visualization for a dataset that includes ages of individuals. You want to categorize these ages into groups (bins) of 10 years each (0-9, 10-19, 20-29, etc.) for a more effective analysis. How should you structure the data in Tableau to create these age bins?

Select 1 option(s):

Apply a range filter on the ‘Age‘ field to divide the data into the desired age groups

Create calculated fields for each age group

Use the binning feature in Tableau on the ‘Age‘ field and set the size of each bin to 10

Implement a parameter that allows users to define the age groupings

Q27. You are creating a Tableau dashboard where users should be able to choose a sales threshold to identify high-performing products. The dataset includes a Sales field. You decide to use a parameter to allow users to set this threshold dynamically. How should you incorporate this parameter in a calculated field to classify products based on the user-selected sales threshold?

Select 1 option(s):

Use the parameter directly in a filter to show products above the sales threshold

Create a calculated field using an IF statement that compares the ‘Sales‘ field to the parameter value

Apply the parameter to color coding in the visualization without a calculated field

Use the parameter in a RANK function to rank products based on the threshold

Q28. You are working with a dataset in Tableau that contains survey results. The data includes a column Responses with values in the format Question1:Answer; Question2:Answer; Question3:Answer and so on. You need to analyze the answers to each question separately. What is the most effective way to prepare this data in Tableau?

Select 1 option(s):

Use a calculated field to extract each question‘s answer

Pivot the ‘Responses‘ column to transform it into separate columns for each question

Split the ‘Responses‘ column into multiple columns based on the semicolon (;) delimiter

Manually reformat the survey data in the source file before importing it into Tableau

Q29. In a Tableau dashboard, you need to allow users to choose between viewing sales data in a map or a table format. Which technique should you use to enable this functionality?

Select 1 option(s):

Configure a Highlight Action to switch between map and table views

Utilize a Sheet Selector based on a Parameter control

Apply a Filter Action to toggle between the map and table

Create a Calculated Field to determine the view type

Q30. In a Tableau dashboard for a retail chain, you are analyzing sales data to focus on high performing regions. You first apply a filter to select regions with sales over $1 million. Next, you want to analyze product categories within these regions. To ensure that subsequent filters only consider the selected high-performing regions, what should you do with the initial region sales filter?

Select 1 option(s):

Leave the region sales filter as is, without any changes

Convert the region sales filter into a context filter

Apply a Top N filter on the region sales filter

Change the region sales filter to a data source filter

Q31. In preparing a dataset for sales analysis in Tableau, you find that the Sales Amount column contains some negative values, which are not feasible in this context. How should you address this issue in Tableau?

Select 1 option(s):

Remove all records with negative sales amounts from the dataset

Use Tableau‘s data source filters to exclude records with negative sales amounts

Convert negative values to zero using a calculated field in Tableau

Leave the negative values as they are, assuming they are data entry errors that don‘t significantly impact the overall analysis

Q32. You are preparing to publish a large data source to Tableau Server, which is frequently updated and accessed by multiple teams. What is the most appropriate action to take for optimal performance and data freshness?

Select 1 option(s):

Publish the data source as a live connection to ensure real-time data updates

Convert the data source into a static extract before publishing

Schedule regular extract refreshes after publishing the data source

Limit access to the data source to reduce load on the server

Q33. You are analyzing a dataset in Tableau containing monthly sales data for the past year. You want to create a custom table calculation that calculates the difference in sales between the first and last month of the year. Which calculation should you use?

Select 1 option(s):

WINDOW_SUM([Sales])

LAST() FIRST()

LOOKUP(SUM([Sales]), FIRST()) LOOKUP(SUM([Sales]), LAST())

INDEX() SIZE()

Q34. When publishing a data source used in multiple workbooks on Tableau Server, what should you consider to maintain consistency across all workbooks?

Select 1 option(s):

Publish the data source as an independent entity separate from any workbooks

Embed the data source within each workbook before publishing

Manually update each workbook with the data source after publishing

Restrict the data source to be accessible only by a single workbook

Q35. You need to create a visualization in Tableau showing the cumulative sales for the current year compared to the same period last year. Your data includes a Date field and a Sales field. What type of custom table calculation should you use to display the cumulative sales for the current year?

Select 1 option(s):

A RUNNING_SUM calculation using ‘Date‘ and ‘Sales‘, filtered for the current year

A YEAR_OVER_YEAR_GROWTH calculation on the ‘Sales‘ field

An INDEX() calculation based on the ‘Date‘ field

A WINDOW_AVG calculation applied to the ‘Sales‘ field

Q36. You are analyzing a dataset in Tableau containing employee details. You notice that the Date of Birth field has some entries in different formats and some unrealistic dates like 2025-12-01. What is the most effective method to clean this data in Tableau?

Select 1 option(s):

Ignore the date format inconsistencies and focus only on the analysis of other fields

Use Tableau‘s built-in date functions to standardize the date format and filter out unrealistic future dates

Manually correct each date entry in the source file outside of Tableau

Use a calculated field to exclude all records with date issues

Q37. You are analyzing a dataset in Tableau that includes daily sales data. You want to create a visualization showing the month-to-date (MTD) sales total. The dataset includes a Date field and a Sales field. What type of custom table calculation should you use to display the MTD sales?

Select 1 option(s):

A RUNNING_SUM calculation using the ‘Sales‘ field, filtered for the current month

A WINDOW_SUM calculation across the entire dataset

An INDEX() calculation based on the ‘Date‘ field

A YEAR_OVER_YEAR_GROWTH calculation on the ‘Sales‘ field

Q38. You are working on a project where you need to analyze time-sensitive financial data from a SQL Server database. The database is updated daily, and your analysis requires including data up to the previous day. What is the most effective method to ensure that your Tableau reports always reflect the latest complete data?

Select 1 option(s):

Establish a live connection to the SQL Server database and refresh the Tableau view daily

Use a custom SQL query in Tableau to pull data up to the previous day

Create a daily refreshed extract based on the entire SQL Server database

Manually export data from the database to a CSV file daily and connect Tableau to this file

Q39. In a Tableau visualization, you need to analyze the percentage change in monthly revenue year over year. The dataset includes Revenue and Date fields. What calculation should you use to determine the year-over-year percentage change in monthly revenue?

Select 1 option(s):

WINDOW_SUM([Revenue])

PERCENT_DIFFERENCE([Revenue])

IF YEAR([Date]) = YEAR(TODAY()) THEN [Revenue] / LOOKUP([Revenue], -12) 1 END

((SUM([Revenue]) LOOKUP(SUM([Revenue]), -12)) / ABS(LOOKUP(SUM([Revenue]), -12)))

Q40. You have created a Tableau dashboard using data from a SQL database. Due to a change in database platforms, the same data is now being stored in an Oracle database. The structure and field names in the new database are identical to those in the SQL database. How should you update your Tableau dashboard to connect to the new Oracle database?

Select 1 option(s):

Recreate the dashboard from scratch using the Oracle database

Use the “Replace Data Source“ feature in Tableau to switch from the SQL to the Oracle database

Manually edit each field in the dashboard to point to the Oracle database

Export the dashboard as a Tableau Packaged Workbook and then reconnect to the Oracle database

Q41. When adapting a Tableau dashboard for tablet viewing, what is a key consideration to ensure usability and readability?

Select 1 option(s):

Design the dashboard with a high resolution, assuming all tablets have high-resolution displays

Rely on the desktop layout, assuming tablets will automatically adjust the dashboard

Customize the dashboard layout for tablet use, considering screen size and touch interaction

Use the same layout as mobile phones, given the similarity in device types

Q42. You are creating a Tableau dashboard to analyze sales data and need to display a year-to-date (YTD) total of sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to show the YTD sales?

Select 1 option(s):

Use a RUNNING_SUM calculation filtered to include only dates within the current year

Apply a WINDOW_SUM calculation across the entire dataset

Use the TOTAL function to sum up the ‘Sales‘ field for the current year

Implement a FIXED LOD calculation to sum sales for the current year

Q43. As a data analyst, you are required to perform a time-sensitive analysis using a data source that is regularly updated on Tableau Server by another department. The data source is large and complex. What is the best way to access this data source for your analysis in Tableau?

Select 1 option(s):

Create a local extract of the data source and refresh it manually

Connect to a mirror of the data source hosted on a different server

Connect directly to the data source on Tableau Server

Export the data from Tableau Server to an Excel file and connect to the file

Q44. You need to create a Tableau report for a quarterly financial review using data from an Oracle database. The data includes complex financial metrics that are only updated at the end of each quarter. What is the best approach to connect to this data source in Tableau?

Select 1 option(s):

Establish a live connection to the Oracle database

Use a data extract with monthly refreshes

Create a data extract and refresh it quarterly to coincide with data updates

Convert the Oracle database data into Excel spreadsheets and then connect to them

Q45. You are creating a Tableau dashboard to compare annual sales growth. The dataset includes a Date field and a Sales field. You need to calculate the year-over-year (YoY) growth rate in sales. Which type of custom table calculation should you use to display the YoY sales growth rate?

Select 1 option(s):

YEAR([Date])

SUM([Sales])

YEAR_OVER_YEAR_GROWTH([Sales])

RUNNING_SUM([Sales])

Q46. You are designing a Tableau dashboard and want to ensure that it looks organized and uncluttered. How should you apply padding to achieve this?

Select 1 option(s):

Apply maximum padding around all dashboard elements to maximize space

Use minimal padding around all elements to fit more content

Implement consistent and moderate padding around each element for a balanced layout

Avoid padding altogether for a compact design

Q47. You are designing a Tableau dashboard that will be viewed on both desktops and mobile devices. What is the best practice to ensure the dashboard is effectively viewable on a mobile device?

Select 1 option(s):

Design the dashboard specifically for desktop and allow automatic resizing for mobile

Use a fixed size layout that is optimized for desktop viewing only

Create a separate mobile-optimized layout using the Device Designer feature

Increase the font size and element spacing uniformly for better visibility on mobile

Q48. You are working with a Tableau workbook that analyzes yearly sales data. The workbook initially used 2019 sales data, but now you need to update it to use the 2020 sales data. The 2020 data is in a new Excel file with the same column structure as the 2019 data. What is the most efficient way to update the workbook to analyze the 2020 data?

Select 1 option(s):

Import the 2020 data as a new data source and rebuild the workbook

Copy and paste the 2020 data into the 2019 Excel file and refresh the data source in Tableau

Use the “Edit Connection“ feature to update the path to the new 2020 Excel file

Replace the 2019 data source with the 2020 data source using Tableau‘s “Replace Data Source“ feature

Q49. In a Tableau dashboard displaying quarterly revenue, you observe that Q2 shows an unexpected drop. To provide context to this observation, what should you do?

Select 1 option(s):

Place a Text annotation directly on Q2 explaining the reason for the drop

Use an Area annotation to cover all quarters for a general overview

Add a Marker annotation to every quarter for consistency

Implement a Point annotation at the highest revenue quarter for contrast

Q50. In a Tableau report, you are working with weekly visitor data for a website. You need to find the change in the number of visitors from the start of the quarter to the end of the quarter. Assuming the data is appropriately sorted, which custom table calculation can be used to determine this change?

Select 1 option(s):

WINDOW_SUM([Visitors])

INDEX() SIZE()

LOOKUP(SUM([Visitors]), FIRST()) LOOKUP(SUM([Visitors]), LAST())

RUNNING_SUM([Visitors])

Q51. You are analyzing time series data in Tableau and want to provide users with the ability to select a specific year and display it as a vertical reference line on a line chart. The dataset includes a Date field. How should you configure a parameter to enable this interactive functionality?

Select 1 option(s):

Create a parameter with a list of years and use it to filter the data shown on the line chart

Use the parameter to dynamically change the line chart‘s time aggregation level

Create a parameter with a list of years and use it to set a vertical reference line on the line chart for the selected year

Apply the parameter to modify the line style of the chart based on the selected year

Q52. In a Tableau report, you are analyzing customer data and want to allow users to select a specific age range to focus on. The dataset includes a Customer Age field. You decide to create two parameters, Minimum Age and Maximum Age, for this purpose. How should you use these parameters in a calculated field to filter customers within the selected age range?

Select 1 option(s):

Create a set that includes customers within the age range defined by the parameters

Use the parameters in a filter directly without a calculated field

Create a calculated field that returns true if ‘Customer Age‘ is between the ‘Minimum Age‘ and ‘Maximum Age‘ parameters

Apply the parameters in a WINDOW_SUM calculation

Q53. You are creating a Tableau report to analyze customer satisfaction scores across different departments. You first apply a filter to select departments with more than 50 employees. Then, you want to analyze the satisfaction scores within these selected departments. How should you treat the initial department size filter to correctly influence subsequent filters?

Select 1 option(s):

Leave the department size filter as a standard filter

Change the department size filter to a context filter

Implement the department size filter as a Top N filter

Use a calculated field to include departments with more than 50 employees

Q54. You are working with Tableau to analyze customer feedback from different regions. You have one dataset with customer feedback and another with detailed customer demographics. Both datasets have a common Customer ID field. You need to analyze the feedback in conjunction with demographic information. Which method should you use to combine these datasets in Tableau for effective analysis?

Select 1 option(s):

Create a union of the two datasets

Use data blending based on the ‘Customer ID‘

Perform a join on the ‘Customer ID‘ field

Import both datasets as independent sources and analyze them separately

Q55. You are designing a Tableau dashboard where you want users to switch between a bar chart and a line chart representing sales data. The best method to achieve this with minimal interaction is:

Select 1 option(s):

Use a Dashboard Action to switch between sheets

Create a Filter Action to select the chart type

Implement a Parameter to control which sheet is displayed

Employ Data Blending to merge the two charts into one view

Q56. In a Tableau project, you are analyzing geographical sales data that includes fields for Country, State, and City. You want to create a visualization that allows users to drill down from country to state to city level. How should you structure the data to enable this drill-down functionality?

Select 1 option(s):

Apply filters on ‘Country‘, ‘State‘, and ‘City‘ in sequential order

Create a parameter to allow users to select the geographical level (Country, State, or City)

Use calculated fields to combine ‘Country‘, ‘State‘, and ‘City‘ into a single field

Create a hierarchy in Tableau using the ‘Country‘, ‘State‘, and ‘City‘ fields

Q57. You are creating a Tableau report for product sales analysis. The dataset includes Product Category, Product Subcategory, and Product Name. To facilitate an in-depth analysis that can start from category and move to specific products, what data structure should you implement?

Select 1 option(s):

Use a set to group ‘Product Category‘, ‘Product Subcategory‘, and ‘Product Name‘

Implement a parameter for users to choose between ‘Product Category‘, ‘Product Subcategory‘, and ‘Product Name‘

Create individual filters for each product field and apply them independentl

Build a hierarchy with ‘Product Category‘, ‘Product Subcategory‘, and ‘Product Name‘

Q58. You are analyzing sales data in Tableau and have identified several products that are consistently underperforming. To simplify your analysis, you want to group these products into a single category named Low Performing Products. Which approach should you take in Tableau to effectively create this group?

Select 1 option(s):

Apply a filter to exclude underperforming products from the analysis

Use a parameter to allow users to define which products are considered low performing

Create a calculated field that labels these products as ‘Low Performing Products‘

Manually select the underperforming products and create a group named ‘Low Performing Products‘

Q59. You need to export a Tableau dashboard for a client who does not have Tableau. The client needs to interact with the data to some extent. What is the most appropriate format to export the dashboard?

Select 1 option(s):

Export as a static PDF file

Export as a Tableau Workbook (.twbx) file

Export as an interactive Tableau Packaged Workbook (.twbx)

Export as a CSV file containing the dashboard data

Q60. In a Tableau visualization, you are displaying a scatter plot of sales data. You want to allow users to interactively set a benchmark sales amount, which will be displayed as a reference line on the scatter plot. The dataset includes Sales Amount for different products. How should you implement this interactive feature using a parameter?

Select 1 option(s):

Create a parameter for the benchmark sales amount and use it directly as a filter on the ‘Sales Amount‘ field

Apply the parameter to adjust the axis scale of the scatter plot dynamically

Create a parameter for the benchmark sales amount and use it to set a reference line on the scatter plot

Use the parameter to control the color intensity of points on the scatter plot based on their proximity to the benchmark sales amount

Tableau Data Analyst Test - 10

Q1. You have created a detailed Tableau visualization that needs to be included in a corporate PowerPoint presentation. Which export format should you use to ensure the best quality for presentation purposes?

Q3. You are analyzing customer data in Tableau and want to identify a group of high-value customers based on their total purchase amount. The dataset includes fields for Customer ID and Total Purchase Amount. Which approach should you take to create a set of high-value customers?

Q6. You want to add a feature in your Tableau dashboard that allows users to navigate from the main dashboard to a detailed view of sales data. What is the most efficient way to implement this?

Q8. You need to print a Tableau dashboard for a presentation, and its crucial that all visualizations and texts are clearly legible in the printed version. What setting should you adjust before printing?

Q9. In a Tableau dashboard, you are tasked with applying a filter to a view that allows users to dynamically select a date range for sales data. Which of the following methods is the most appropriate for adding this interactivity?

Q12. You are working on a Tableau dashboard that includes multiple sheets, each using data from the same data source. You need to apply a filter to show only the current years data across all sheets. What is the most efficient way to apply this filter to the entire dashboard?

Q13. In your Tableau dashboard, you need to instruct users to click on a specific chart to filter other components of the dashboard. Which approach is most effective for conveying this instruction?

Q15. In a Tableau dashboard, you need to create an interaction where selecting a product category in one chart dynamically filters the data displayed in another chart. Which action should you add to achieve this?

Q17. When preparing to print a Tableau worksheet for a report, what is the best practice to ensure that all data and visualizations are accurately represented in the printout?

Q19. In your Tableau dashboard, you need to create a user-friendly method for returning from a detailed product analysis page to the main dashboard. Which approach should you use?

Q21. You want to enable users to click on a state in a map view on a Tableau dashboard, which will then open a website showing tourism information for that state. Which action should be configured to achieve this functionality?

Q23. In a Tableau visualization, you are working with sales data and need to compare the performance of top-performing products against all other products. The dataset includes Product ID and Sales fields. How should you structure the data to facilitate this analysis?

Q24. You are designing an interactive dashboard in Tableau where users should be able to filter a product sales view by region. What is the best approach to enable this filtering feature?

Q25. You are designing a Tableau dashboard and want to guide users on how to interact with a complex chart. What is the best method to instruct users to hover over data points for more information?

Q26. You are working on a Tableau visualization for a dataset that includes ages of individuals. You want to categorize these ages into groups (bins) of 10 years each (0-9, 10-19, 20-29, etc.) for a more effective analysis. How should you structure the data in Tableau to create these age bins?

Q29. In a Tableau dashboard, you need to allow users to choose between viewing sales data in a map or a table format. Which technique should you use to enable this functionality?

Q31. In preparing a dataset for sales analysis in Tableau, you find that the Sales Amount column contains some negative values, which are not feasible in this context. How should you address this issue in Tableau?

Q32. You are preparing to publish a large data source to Tableau Server, which is frequently updated and accessed by multiple teams. What is the most appropriate action to take for optimal performance and data freshness?

Q33. You are analyzing a dataset in Tableau containing monthly sales data for the past year. You want to create a custom table calculation that calculates the difference in sales between the first and last month of the year. Which calculation should you use?

Q34. When publishing a data source used in multiple workbooks on Tableau Server, what should you consider to maintain consistency across all workbooks?

Q36. You are analyzing a dataset in Tableau containing employee details. You notice that the Date of Birth field has some entries in different formats and some unrealistic dates like 2025-12-01. What is the most effective method to clean this data in Tableau?

Q37. You are analyzing a dataset in Tableau that includes daily sales data. You want to create a visualization showing the month-to-date (MTD) sales total. The dataset includes a Date field and a Sales field. What type of custom table calculation should you use to display the MTD sales?

Q39. In a Tableau visualization, you need to analyze the percentage change in monthly revenue year over year. The dataset includes Revenue and Date fields. What calculation should you use to determine the year-over-year percentage change in monthly revenue?

Q41. When adapting a Tableau dashboard for tablet viewing, what is a key consideration to ensure usability and readability?

Q42. You are creating a Tableau dashboard to analyze sales data and need to display a year-to-date (YTD) total of sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to show the YTD sales?

Q43. As a data analyst, you are required to perform a time-sensitive analysis using a data source that is regularly updated on Tableau Server by another department. The data source is large and complex. What is the best way to access this data source for your analysis in Tableau?

Q44. You need to create a Tableau report for a quarterly financial review using data from an Oracle database. The data includes complex financial metrics that are only updated at the end of each quarter. What is the best approach to connect to this data source in Tableau?

Q45. You are creating a Tableau dashboard to compare annual sales growth. The dataset includes a Date field and a Sales field. You need to calculate the year-over-year (YoY) growth rate in sales. Which type of custom table calculation should you use to display the YoY sales growth rate?

Q46. You are designing a Tableau dashboard and want to ensure that it looks organized and uncluttered. How should you apply padding to achieve this?

Q47. You are designing a Tableau dashboard that will be viewed on both desktops and mobile devices. What is the best practice to ensure the dashboard is effectively viewable on a mobile device?

Q49. In a Tableau dashboard displaying quarterly revenue, you observe that Q2 shows an unexpected drop. To provide context to this observation, what should you do?

Q51. You are analyzing time series data in Tableau and want to provide users with the ability to select a specific year and display it as a vertical reference line on a line chart. The dataset includes a Date field. How should you configure a parameter to enable this interactive functionality?

Q55. You are designing a Tableau dashboard where you want users to switch between a bar chart and a line chart representing sales data. The best method to achieve this with minimal interaction is:

Q57. You are creating a Tableau report for product sales analysis. The dataset includes Product Category, Product Subcategory, and Product Name. To facilitate an in-depth analysis that can start from category and move to specific products, what data structure should you implement?

Q59. You need to export a Tableau dashboard for a client who does not have Tableau. The client needs to interact with the data to some extent. What is the most appropriate format to export the dashboard?

Q3. You are analyzing customer data in Tableau and want to identify a group of high-value customers based on their total purchase amount. The dataset includes fields for Customer ID and Total Purchase Amount. Which approach should you take to create a set of high-value customers?

Q8. You need to print a Tableau dashboard for a presentation, and its crucial that all visualizations and texts are clearly legible in the printed version. What setting should you adjust before printing?

Q12. You are working on a Tableau dashboard that includes multiple sheets, each using data from the same data source. You need to apply a filter to show only the current years data across all sheets. What is the most efficient way to apply this filter to the entire dashboard?

Q23. In a Tableau visualization, you are working with sales data and need to compare the performance of top-performing products against all other products. The dataset includes Product ID and Sales fields. How should you structure the data to facilitate this analysis?

Q31. In preparing a dataset for sales analysis in Tableau, you find that the Sales Amount column contains some negative values, which are not feasible in this context. How should you address this issue in Tableau?

Q36. You are analyzing a dataset in Tableau containing employee details. You notice that the Date of Birth field has some entries in different formats and some unrealistic dates like 2025-12-01. What is the most effective method to clean this data in Tableau?

Q37. You are analyzing a dataset in Tableau that includes daily sales data. You want to create a visualization showing the month-to-date (MTD) sales total. The dataset includes a Date field and a Sales field. What type of custom table calculation should you use to display the MTD sales?

Q39. In a Tableau visualization, you need to analyze the percentage change in monthly revenue year over year. The dataset includes Revenue and Date fields. What calculation should you use to determine the year-over-year percentage change in monthly revenue?

Q42. You are creating a Tableau dashboard to analyze sales data and need to display a year-to-date (YTD) total of sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to show the YTD sales?

Q45. You are creating a Tableau dashboard to compare annual sales growth. The dataset includes a Date field and a Sales field. You need to calculate the year-over-year (YoY) growth rate in sales. Which type of custom table calculation should you use to display the YoY sales growth rate?

Q51. You are analyzing time series data in Tableau and want to provide users with the ability to select a specific year and display it as a vertical reference line on a line chart. The dataset includes a Date field. How should you configure a parameter to enable this interactive functionality?

Q57. You are creating a Tableau report for product sales analysis. The dataset includes Product Category, Product Subcategory, and Product Name. To facilitate an in-depth analysis that can start from category and move to specific products, what data structure should you implement?