Tableau Data Analyst Test - 8

Free tableau data analyst certification test. To become a data analyst and have a tech career this test is helpful

Welcome to your Tableau Data Analyst – Test-09

Name

Phone

Q1. You are creating a Tableau dashboard visualizing regional sales data. To enhance the users understanding of each regions performance, what is the most effective use of tooltips?

Select 1 option(s):

Show detailed sales data and trends for the region when hovering over its representation

Display general information about sales unrelated to specific regions in all tooltips

Use tooltips to show external links for additional information on sales strategies

Keep tooltips disabled to maintain a clean and uncluttered dashboard

Q2. You are creating a Tableau dashboard for a marketing analysis and want to use custom shapes to represent different social media platforms. How should you proceed?

Select 1 option(s):

Import the platform logos as custom shapes and assign them to respective data points

Utilize default shapes provided by Tableau for each platform

Apply a uniform shape for all platforms and differentiate them by color

Use text labels instead of shapes to represent each social media platform

Q3. You are creating a Tableau dashboard for financial reporting and need to ensure high readability and professional appearance. What is the best practice for font selection and styling in this context?

Select 1 option(s):

Choose a decorative, stylized font for visual appeal

Use a consistent, sans-serif font throughout the dashboard

Implement multiple font styles to differentiate data categories

Apply bold and italicized fonts extensively for emphasis

Q4. In a Tableau visualization, you have a field Email containing email addresses. You need to create a calculated field that extracts the domain part of each email address (e.g., example.com from user@example.com). Which string function should you use to accomplish this?

Select 1 option(s):

LEFT([Email], FIND([Email], “@“) 1)

RIGHT([Email], LEN([Email]) FIND([Email], “@“))

SPLIT([Email], “@“, 2)

LOWER([Email])

Q5. In a Tableau report, you are analyzing regional sales data and want to compare individual store sales against the total sales of the region they belong to. The dataset includes Store ID, Region, and Sales fields. What LOD calculation should you use to determine the total sales for each region?

Select 1 option(s):

SUM([Sales])

{ FIXED [Region] : SUM([Sales]) }

{ INCLUDE [Region] : SUM([Sales]) }

{ EXCLUDE [Region] : SUM([Sales]) }

Q6. You want to create a Tableau visualization to compare sales performance across different regions. The focus is on both the sales volume and the number of transactions. Which chart type should you choose?

Select 1 option(s):

Construct a pie chart to show the proportion of sales and transactions per region

Create a bubble chart where the size of the bubble represents sales volume and the color represents the number of transactions

Use a bar chart with sales volume on the x-axis and number of transactions on the y-axis

Implement a tree map to display sales volume, with color variations representing the number of transactions

Q7. Your team is working on a demographic analysis project that requires historical data spanning over the past decade. The data includes population, age distribution, and income levels across various regions. Which of the following data sources would be most appropriate for this analysis in Tableau?

Select 1 option(s):

A live streaming data source from social media platforms

An annually updated government census database

A real-time sensor data feed from IoT devices

A daily log file from a website‘s user activity

Q8. You are analyzing sales data in Tableau and need to identify the total number of unique products sold. The dataset includes a Product ID field for each sale. Which calculated field should you create to find the total number of unique products sold?

Select 1 option(s):

SUM([Product ID])

AVG([Product ID])

COUNTD([Product ID])

COUNT([Product ID])

Q9. In Tableau, you need to create a calculated field that returns Yes if the Order Quantity is greater than 10 and No otherwise. Which calculation type should you use?

Select 1 option(s):

A calculated field using a SUM function to total the ‘Order Quantity‘

An arithmetic calculation to compare ‘Order Quantity‘ with 10

A logical IF statement to check if ‘Order Quantity‘ is greater than 10

A Level of Detail expression to evaluate the ‘Order Quantity‘

Q10. You are connecting to a relational database and need to join data from multiple tables for your Tableau analysis. The database contains complex relationships. What is the best practice in this scenario?

Select 1 option(s):

Avoid using custom SQL and rely on Tableau‘s automatic data joining capabilities

Write a custom SQL query to handle the specific joins and relationships required

Import each table separately into Tableau and manually join them within the tool

Simplify the database structure before connecting to Tableau

Q11. You are working on a Tableau dashboard to display the top 5 performing sales representatives based on their total sales. The dataset includes a Sales Rep field and a Total Sales field. How should you create a custom table calculation to display only the top 5 sales representatives?

Select 1 option(s):

Use the TOP N filter on the ‘Sales Rep‘ field based on the sum of ‘Total Sales‘

Create a calculated field using RANK(SUM([Total Sales])) and filter to show ranks 1 through 5

Apply INDEX() to the ‘Sales Rep‘ field and filter for the first 5 indexes

Use WINDOW_SUM([Total Sales]) and sort the sales representatives in descending order

Q12. You are a data analyst in a multinational corporation. The marketing team has published a data source on Tableau Server containing global sales data that you need to use for your analysis. How should you connect to this data source in Tableau for creating your reports?

Select 1 option(s):

Download the data source from Tableau Server and connect to the local copy

Connect directly to the data source published on Tableau Server

Extract the data source from Tableau Server into a .hyper file and then connect

Convert the published data source into a CSV file and then connect

Q13. You are preparing a dataset for analysis in Tableau that includes sales data from various regions. On initial inspection, you notice some inconsistencies and missing values in the region names. What should be your first step in assessing and ensuring the data quality?

Select 1 option(s):

Ignore the inconsistencies as Tableau can automatically correct these during analysis

Use Tableau‘s data interpreter to reformat the entire dataset

Manually edit the data in the source file to correct the inconsistencies

Use Tableau‘s data source page to review and clean the region names

Q14. You have completed a Tableau workbook containing sensitive financial data. What is the key step you must follow when publishing this workbook to Tableau Server to ensure data security?

Select 1 option(s):

Publish the workbook without any extracts or live connections

Set the workbook to ‘Public‘ to enable easy access for all users

Publish the workbook with user-specific data permissions and secure extracts

Save the workbook locally and share it via email with authorized users

Q15. Before publishing a Tableau workbook to Tableau Server, which step is essential to ensure that all users can view the data as intended?

Select 1 option(s):

Convert all data sources to extracts

Remove all filters and parameters

Check data source connections for accessibility

Set the workbook visualization to full screen

Q16. You are analyzing a dataset in Tableau that includes a Customer ID field, which is currently set as a measure. How should you handle this field for effective analysis?

Select 1 option(s):

Keep ‘Customer ID‘ as a measure since it‘s a numeric field

Convert ‘Customer ID‘ into a dimension to analyze data by individual customers

Remove ‘Customer ID‘ from the analysis as its not a quantifiable measure

Summarize the ‘Customer ID‘ field to use it as a measure in aggregations

Q17. In a Tableau visualization, you need to create a calculated field that displays the position of each row in a partition, sorted by the Date field. What custom table calculation should you use to show the row number for each record?

Select 1 option(s):

RANK([Date])

ROW_NUMBER()

INDEX()

RUNNING_SUM([Date])

Q18. Your task involves analyzing sales data from a relational database to identify trends in customer purchasing behavior over the last five years. The database contains extensive data, but you only need information related to sales transactions and customer demographics. What is the most efficient way to pull this specific data into Tableau?

Select 1 option(s):

Import the entire database into Tableau and then filter out unnecessary data

Use a custom SQL query to extract only sales transactions and customer demographics

Create multiple data extracts for each table in the database and then blend them in Tableau

Connect to the database using a live connection and use Tableau filters to select the required data

Q19. In a Tableau report, you need to compare the current months sales to the previous months sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to display the sales for the current month so far?

Select 1 option(s):

Apply a WINDOW_AVG calculation to the ‘Sales‘ field, filtered for the current month

Use a RUNNING_SUM calculation on the ‘Sales‘ field, filtered to include only dates within the current month

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

Use a WINDOW_SUM calculation on the ‘Sales‘ field, partitioned by month

Q20. You are creating a Tableau visualization for a retail stores sales data. You want to focus on products that have sold more than 100 units but less than 500 units. The dataset includes a Product field and a Units Sold field. How should you apply filters to your visualization to achieve this?

Select 1 option(s):

Apply a filter on the ‘Product‘ field to include only products with names indicating high sales

Apply a filter to the ‘Units Sold‘ field to show data where units are greater than 100 and less than 500

Use a top N filter on the ‘Units Sold‘ field to display the top-selling products

Create a calculated field to categorize products based on unit sales and apply a filter on this new field

Q21. In a Tableau report, you are analyzing hotel booking data and want to exclude bookings with a duration of less than 3 days for a more focused analysis on longer stays. The dataset includes a Booking Duration field. What type of filter should you apply to the Booking Duration field?

Select 1 option(s):

Apply a context filter to the ‘Booking Duration‘ field with a minimum value set to 3 days

Use a relative date filter on the ‘Booking Duration‘ field

Apply a range filter to the ‘Booking Duration‘ field to include only bookings of 3 days or more

Create a set based on the ‘Booking Duration‘ field and include only bookings of 3 days or more

Q22. During the analysis of a customer dataset in Tableau, you discover that some customer records have missing email addresses, and others have email addresses that do not follow a standard format. What approach should you take to assess and improve the data quality?

Select 1 option(s):

Disregard the email field as it is not crucial for the analysis

Create calculated fields in Tableau to correct the email format

Use Tableau‘s data profiling feature to identify and highlight these discrepancies

Manually contact customers to verify their email addresses

Q23. In a Tableau dashboard displaying a line chart of monthly sales over a year, how should tooltips be utilized for maximum effectiveness?

Select 1 option(s):

Configure tooltips to display the exact sales figures and percentage change from the previous month when hovering over each data point

Include extensive narrative descriptions of sales strategies in tooltips for each month

Limit tooltips to only show the month and year, without any sales figures

Use a uniform tooltip for all data points, showing the total annual sales

Q24. You are working on a project that requires analyzing customer data from an e-commerce platform. The data is stored in a MySQL database and is updated in real-time. Your analysis includes monitoring current customer behaviors and trends. What is the most appropriate way to connect to this data source in Tableau?

Select 1 option(s):

Use an extract connection with daily refreshes

Connect directly to the MySQL database using a live connection

Convert the MySQL data into a .csv file and connect to this file

Create a .hyper extract from the MySQL database for a weekly refresh

Q25. You are analyzing a sales trend over time in Tableau and notice a significant spike in sales during a particular month. To effectively communicate this insight, what type of annotation should you add?

Select 1 option(s):

A Marker annotation at the point of the sales spike to indicate its significance

A Point annotation on each data point to detail individual sales figures

A Text annotation in the dashboard margin explaining general sales trends

An Area annotation highlighting the entire timeframe of the sales data

Q26. In a Tableau dashboard with multiple charts and text boxes, you notice that the elements appear too close to each other, making it visually overwhelming. What padding strategy should be adopted to improve readability?

Select 1 option(s):

Increase padding uniformly for all elements to create more space between them

Use high padding for text boxes and minimal padding for charts

Apply different padding levels randomly to create a dynamic layout

Remove padding from charts to allocate more space to text boxes

Q27. You are refining a Tableau dashboard that displays financial data in a table format. To improve the professional and sleek appearance of the dashboard, what should you modify?

Select 1 option(s):

Add additional gridlines for a more detailed view

Apply heavy shading to every alternate row for better differentiation

Remove row-level bands and reduce shading to simplify the view

Introduce column-level bands with distinct colors for each financial metric

Q28. You are creating a Tableau report to rank products based on their sales performance. The dataset includes a Product field and a Sales field. You want each product to have a unique rank based on its sales. Which custom table calculation should you use to assign a rank to each product?

Select 1 option(s):

RANK([Sales])

INDEX()

SIZE()

WINDOW_SUM([Sales])

Q29. In a Tableau report, you are analyzing a dataset containing product sales data. You need to rank the products based on the average sales amount and identify products in the top quartile. Which calculation should you use to determine the quartile ranking of each product?

Select 1 option(s):

RANK_PERCENTILE(AVG([Sales Amount]))

INDEX()

PERCENTILE([Sales Amount], 0.25)

WINDOW_AVG([Sales Amount])

Q30. In a Tableau dashboard containing a dense matrix of data, you aim to enhance clarity and reduce visual noise. Which action would most effectively contribute to this goal?

Select 1 option(s):

Intensify the gridlines to delineate data points more clearly

Remove gridlines to create a cleaner, less cluttered appearance

Add more row-level and column-level bands for detailed differentiation

Increase the shading of alternate rows and columns to distinguish data

Q31. You want to create a Tableau visualization that shows both the total sales and the average profit margin for each product category over the last year. Which chart type allows you to effectively display both of these metrics?

Select 1 option(s):

Develop a pie chart to represent total sales and average profit margin for each category

Use a bar chart with dual axes for total sales and average profit margin

Create a bubble chart where the size of the bubble represents total sales and the color represents the average profit margin

Construct a tree map to display total sales with color variations for average profit margin

Q32. Your team needs to analyze a large dataset that is updated monthly. The data is provided to you in a .tde format. What is the most effective way to use this data for monthly analysis in Tableau?

Select 1 option(s):

Convert the .tde file to a CSV file and connect to the CSV

Establish a live connection to the .tde file

Connect directly to the .tde file and refresh it monthly

Create a new data extract from the .tde file in a .hyper format

Q33. In your Tableau project, you have a field Total Sales, which is currently being treated as a dimension. When should you convert this field to a measure?

Select 1 option(s):

Convert ‘Total Sales‘ to a measure when you need to categorize data by sales values

Keep ‘Total Sales‘ as a dimension to ensure accurate record-level detail

Convert ‘Total Sales‘ to a measure to perform aggregations and quantitative analysis

Use ‘Total Sales‘ as a dimension for creating calculated fields

Q34. You are analyzing a dataset of sales transactions in Tableau and want to focus on the top 10 highest selling products. Which filter setting should you use to display only these products in your visualization?

Select 1 option(s):

Apply a wildcard filter to select products with the highest sales

Use a ‘Top N‘ filter based on the sales amount to display the top 10 products

Implement an ‘Include‘ filter and manually select the top 10 products

Set a conditional filter to show products with sales above a certain threshold

Q35. You are working on a business intelligence project that involves analyzing large datasets from multiple sources, including CRM, ERP, and web analytics. The data is updated monthly and does not require real-time analysis. Your goal is to optimize the performance of Tableau dashboards. What is the best approach to connect to these data sources?

Select 1 option(s):

Live connection to each individual data source

Extract connection with daily refreshes

Extract connection with monthly refreshes

Manual extract creation and upload

Q36. To understand customer purchasing behavior, you want to create a Tableau visualization that shows the relationship between the age of customers and the average purchase amount. Which chart type would be most appropriate?

Select 1 option(s):

Develop a pie chart to represent the average purchase amount by different age groups

Use a bar chart to show average purchase amounts for each age group

Create a scatter plot to analyze the relationship between customer age and average purchase amount

Construct a Gantt chart to represent the age-wise distribution of average purchase amounts

Q37. You are analyzing survey data in Tableau and have a field ResponseTime in seconds, currently formatted as a string. For better visualization, you need to convert this time into minutes in a calculated field. What is the appropriate type conversion function to use for ResponseTime?

Select 1 option(s):

FLOAT([ResponseTime]) / 60

INT([ResponseTime]) / 60

DATE([ResponseTime]) / 60

STRING([ResponseTime]) / 60

Q38. In your Tableau dashboard, you need to create a filter that excludes data from a specific region, East, to analyze trends in other regions. What type of filter should you apply?

Select 1 option(s):

Use a ‘Bottom N‘ filter to exclude the ‘East‘ region

Implement a wildcard filter to remove ‘East‘ from the dataset

Apply an ‘Exclude‘ filter specifically for the ‘East‘ region

Set up a conditional filter to show only data not from the ‘East‘ region

Q39. When connecting to a relational database for a Tableau project, you need to retrieve a specific subset of data from a large table. Which approach would be most effective?

Select 1 option(s):

Connect to the entire table and then filter the data in Tableau

Use a custom SQL query to pull only the required subset of data

Manually export the subset of data from the database and import it into Tableau

Use Tableau‘s built-in data connectors without any customization

Q40. In a Tableau project, you need to calculate the number of days passed since the start of the current year for each date entry in your dataset. The dataset includes a Date field. Which calculated field should you create to perform this calculation?

Select 1 option(s):

DATEDIFF(‘day‘, ‘2023-01-01‘, [Date])

DATEDIFF(‘day‘, DATE(‘2023-01-01‘), [Date])

DATEDIFF(‘day‘, DATETRUNC(‘year‘, [Date]), [Date])

DAY([Date])

Q41. You are working with a dataset in Tableau that includes a field CustomerName formatted as LastName, FirstName. You need to create a calculated field to display the customers first name only. Which string function should you use in the calculated field to extract the first name?

Select 1 option(s):

LEFT([CustomerName], FIND([CustomerName], “,“) 1)

RIGHT([CustomerName], LEN([CustomerName]) FIND([CustomerName], “,“) 1)

TRIM(SPLIT([CustomerName], “,“, 2))

UPPER([CustomerName])

Q42. You are preparing a dataset for analysis in Tableau and notice several inconsistencies in the Date of Sale column, with some dates recorded in different formats. What action should you take to ensure data quality in terms of consistency?

Select 1 option(s):

Ignore the inconsistencies as Tableau can automatically interpret different date formats

Standardize the date format across the dataset to ensure consistency

Remove the ‘Date of Sale‘ column as it may lead to inaccurate analysis

Replace all inconsistent dates with a default value to simplify the analysis

Q43. In a Tableau report, you are working with a dataset that includes a string field TotalSales representing sales figures. For analytical purposes, you need to use these sales figures in calculations. How should you convert the TotalSales field in your calculated field expression?

Select 1 option(s):

STRING([TotalSales])

FLOAT([TotalSales])

DATE([TotalSales])

ATTR([TotalSales])

Q44. In a Tableau visualization, you are working with a dataset that includes individual customer purchase amounts. You need to create a calculated field that will display the average purchase amount for each customer. Which aggregate function should you use in your calculated field?

Select 1 option(s):

SUM([Purchase Amount]) / COUNT([Customer ID])

AVG([Purchase Amount])

MAX([Purchase Amount])

COUNTD([Purchase Amount])

Q45. You are working on a project where the primary task involves analyzing time-series data related to stock market trends. The data is updated every minute and is crucial for making quick trading decisions. Which data source would be most appropriate to connect with Tableau for real-time analytics?

Select 1 option(s):

A static Excel spreadsheet updated daily

A real-time API providing live stock market data

A monthly updated SQL database

A CSV file updated weekly

Q46. You are analyzing a dataset in Tableau containing employee sales data. You need to create a calculated field to calculate the commission for each employee, which is 5% of their total sales if their sales exceed $10,000, and 3% otherwise. Which calculated field expression should you use?

Select 1 option(s):

IF SUM([Sales]) > 10000 THEN SUM([Sales]) * 0.05 ELSE SUM([Sales]) * 0.03 END

0.05 * [Sales]

IF [Sales] > 10000 THEN [Sales] * 0.05 ELSE [Sales] * 0.03 END

SUM([Sales]) * 0.03 + 0.02 * (SUM([Sales]) 10000)

Q47. You are analyzing sales data from a small business. The dataset is relatively small and is updated weekly. The business needs to access the latest sales trends and analysis through Tableau. What is the most effective way to connect to this data in Tableau?

Select 1 option(s):

Live connection to the business‘s sales database

Extract connection with real-time refreshes

Extract connection with weekly refreshes

Manual extract creation and upload every month

Q48. You are analyzing sales data for a large retail chain. The data includes millions of transactions and is growing daily. Your analysis requires high-speed interaction with the data for various complex calculations and visualizations. Which connection type should you choose in Tableau?

Select 1 option(s):

Live connection to a cloud-based database

Live connection to an on-premises SQL server

Extract connection with daily refresh

Extract connection with monthly refresh

Q49. In a Tableau dashboard focused on sales performance, you want to apply a color scheme that intuitively represents different levels of sales figures. Which approach is most effective?

Select 1 option(s):

Use varying shapes for different sales levels

Apply a single, neutral color across all sales levels

Implement a gradient color scale where color intensity corresponds to sales figures

Assign random colors to each sales level for distinction

Q50. You need to visualize the distribution of customer ages in your dataset to identify the most common age ranges among your customers. Which type of chart would be most appropriate for this analysis in Tableau?

Select 1 option(s):

Use a pie chart to represent different age groups as slices

Create a line chart to show the trend of customer ages

Display the data in a histogram to show the distribution of ages

Implement a scatter plot to analyze the distribution of customer ages

Q51. You are tasked with creating a calculated field in Tableau to identify whether customers are eligible for a loyalty program. The criteria for eligibility are: customers with more than three years of membership and an average purchase amount of over $500. The dataset includes Years of Membership and Average Purchase Amount fields. What expression should you use for this calculated field?

Select 1 option(s):

IF [Years of Membership] > 3 AND [Average Purchase Amount] > 500 THEN ‘Eligible‘ ELSE ‘Not Eligible‘ END

IF [Years of Membership] > 3 OR [Average Purchase Amount] > 500 THEN ‘Eligible‘ ELSE ‘Not Eligible‘ END

CASE WHEN [Years of Membership] > 3 AND [Average Purchase Amount] > 500 THEN ‘Eligible‘ ELSE ‘Not Eligible‘ END

IF [Years of Membership] > 3 THEN ‘Eligible‘ ELSEIF [Average Purchase Amount] > 500 THEN ‘Eligible‘ ELSE ‘Not Eligible‘ END

Q52. You are analyzing sales data over time and want to show both the total sales and the average sales per month. Which type of chart is most suitable for this analysis in Tableau?

Select 1 option(s):

Use a pie chart to represent total and average sales for each month

Create a dual-axis chart with one axis for total sales and another for average sales

Display data in a histogram to show the distribution of sales over time

Use a scatter plot to compare total and average sales each month

Q53. Your team is working on a project to analyze historical weather data over the past 20 years. The data is static and will not change. The primary focus is on creating detailed reports and visualizations that can be accessed without real-time data updates. What is the most appropriate connection type to use in Tableau for this scenario?

Select 1 option(s):

Live connection to a real-time weather data API

Live connection to a static historical database

Extract connection with weekly refresh

Extract connection without scheduled refreshes

Q54. In a Tableau visualization, you have a field Total Cost and a field Units Sold. You need to create a calculated field to determine the average cost per unit sold. Which expression should you use for this calculated field?

Select 1 option(s):

SUM([Total Cost]) / COUNT([Units Sold])

[Total Cost] / [Units Sold]

AVG([Total Cost] / [Units Sold])

SUM([Total Cost]) / SUM([Units Sold])

Q55. You are creating a calculated field in Tableau to categorize sales data into High, Medium, and Low tiers based on the sales amount. Which type of calculation is most suitable for this categorization?

Select 1 option(s):

Use a simple arithmetic calculation to divide the sales amount into tiers

Apply an aggregate function like SUM or AVG to categorize the sales

Implement a logical CASE statement to assign sales into ‘High‘, ‘Medium‘, or ‘Low‘ categories

Create a calculated field using a FIXED Level of Detail expression

Q56. You are analyzing sales data in Tableau and need to create a report that shows sales performance by the day of the week. The dataset contains a Date field in the format YYYY-MM-DD. Which calculated field should you create to extract the day of the week from the Date field?

Select 1 option(s):

DATEPARSE(‘YYYY-MM-DD‘, [Date])

DATENAME(‘weekday‘, [Date])

DATEDIFF(‘day‘, [Date], TODAY())

YEAR([Date])

Q57. You are working on a Tableau dashboard and need to calculate the average sales per store, regardless of the filters applied to your visualization. The dataset includes Store ID and Sales fields. Which type of calculation should you use to ensure the average sales per store calculation remains constant, even when filters are applied?

Select 1 option(s):

AVG([Sales])

{ FIXED [Store ID] : AVG([Sales]) }

{ INCLUDE [Store ID] : AVG([Sales]) }

{ EXCLUDE [Store ID] : AVG([Sales]) }

Q58. In a Tableau visualization, you are analyzing a dataset that contains sales data, including a Sales Amount field and a Region field. You need to create a calculated field to classify each sale as High, Medium, or Low based on the following criteria: Sales above $5000 in Region A are classified as High, sales between $2000 and $5000 in Region A as Medium, and all other sales as Low. Which calculated field expression should you use?

Select 1 option(s):

IF [Sales Amount] > 5000 AND [Region] = ‘Region A‘ THEN ‘High‘ ELSEIF [Sales Amount] >= 2000 AND [Sales Amount] <= 5000 AND [Region] = ‘Region A‘ THEN ‘Medium‘ ELSE ‘Low‘ END

IF [Sales Amount] > 5000 OR [Region] = ‘Region A‘ THEN ‘High‘ ELSEIF [Sales Amount] > 2000 THEN ‘Medium‘ ELSE ‘Low‘ END

CASE WHEN [Sales Amount] > 5000 THEN ‘High‘ WHEN [Sales Amount] > 2000 THEN ‘Medium‘ ELSE ‘Low‘ END

IF [Sales Amount] > 5000 THEN ‘High‘ ELSEIF [Sales Amount] > 2000 THEN ‘Medium‘ ELSE ‘Low‘ END

Q59. You are working on a project that requires the analysis of quarterly financial data. The data is provided in an Excel spreadsheet that is updated at the end of each quarter. Your goal is to perform a year-over-year comparison using Tableau. What is the best approach to connect to this spreadsheet?

Select 1 option(s):

Establish a live connection to the Excel spreadsheet

Create an extract of the spreadsheet and set up a quarterly refresh schedule

Manually update the data in Tableau each quarter by re-importing the spreadsheet

Use Tableau‘s web data connector to link to the spreadsheet

Q60. You are tasked with creating a Tableau dashboard to analyze monthly sales data for a retail company. The data is stored in multiple Excel spreadsheets, each representing a different stores sales for the month. How should you connect to these spreadsheets to create an effective analysis in Tableau?

Select 1 option(s):

Import each spreadsheet as a separate data source and analyze them individually

Use Tableau‘s data blending feature to combine the spreadsheets after importing them separately

Connect to a single consolidated spreadsheet that combines all stores‘ data

Use a live connection to each spreadsheet individually

Tableau Data Analyst Test - 8

Q1. You are creating a Tableau dashboard visualizing regional sales data. To enhance the users understanding of each regions performance, what is the most effective use of tooltips?

Q2. You are creating a Tableau dashboard for a marketing analysis and want to use custom shapes to represent different social media platforms. How should you proceed?

Q3. You are creating a Tableau dashboard for financial reporting and need to ensure high readability and professional appearance. What is the best practice for font selection and styling in this context?

Q4. In a Tableau visualization, you have a field Email containing email addresses. You need to create a calculated field that extracts the domain part of each email address (e.g., example.com from user@example.com). Which string function should you use to accomplish this?

Q6. You want to create a Tableau visualization to compare sales performance across different regions. The focus is on both the sales volume and the number of transactions. Which chart type should you choose?

Q8. You are analyzing sales data in Tableau and need to identify the total number of unique products sold. The dataset includes a Product ID field for each sale. Which calculated field should you create to find the total number of unique products sold?

Q9. In Tableau, you need to create a calculated field that returns Yes if the Order Quantity is greater than 10 and No otherwise. Which calculation type should you use?

Q10. You are connecting to a relational database and need to join data from multiple tables for your Tableau analysis. The database contains complex relationships. What is the best practice in this scenario?

Q11. You are working on a Tableau dashboard to display the top 5 performing sales representatives based on their total sales. The dataset includes a Sales Rep field and a Total Sales field. How should you create a custom table calculation to display only the top 5 sales representatives?

Q12. You are a data analyst in a multinational corporation. The marketing team has published a data source on Tableau Server containing global sales data that you need to use for your analysis. How should you connect to this data source in Tableau for creating your reports?

Q13. You are preparing a dataset for analysis in Tableau that includes sales data from various regions. On initial inspection, you notice some inconsistencies and missing values in the region names. What should be your first step in assessing and ensuring the data quality?

Q14. You have completed a Tableau workbook containing sensitive financial data. What is the key step you must follow when publishing this workbook to Tableau Server to ensure data security?

Q15. Before publishing a Tableau workbook to Tableau Server, which step is essential to ensure that all users can view the data as intended?

Q16. You are analyzing a dataset in Tableau that includes a Customer ID field, which is currently set as a measure. How should you handle this field for effective analysis?

Q17. In a Tableau visualization, you need to create a calculated field that displays the position of each row in a partition, sorted by the Date field. What custom table calculation should you use to show the row number for each record?

Q19. In a Tableau report, you need to compare the current months sales to the previous months sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to display the sales for the current month so far?

Q21. In a Tableau report, you are analyzing hotel booking data and want to exclude bookings with a duration of less than 3 days for a more focused analysis on longer stays. The dataset includes a Booking Duration field. What type of filter should you apply to the Booking Duration field?

Q22. During the analysis of a customer dataset in Tableau, you discover that some customer records have missing email addresses, and others have email addresses that do not follow a standard format. What approach should you take to assess and improve the data quality?

Q23. In a Tableau dashboard displaying a line chart of monthly sales over a year, how should tooltips be utilized for maximum effectiveness?

Q25. You are analyzing a sales trend over time in Tableau and notice a significant spike in sales during a particular month. To effectively communicate this insight, what type of annotation should you add?

Q26. In a Tableau dashboard with multiple charts and text boxes, you notice that the elements appear too close to each other, making it visually overwhelming. What padding strategy should be adopted to improve readability?

Q27. You are refining a Tableau dashboard that displays financial data in a table format. To improve the professional and sleek appearance of the dashboard, what should you modify?

Q28. You are creating a Tableau report to rank products based on their sales performance. The dataset includes a Product field and a Sales field. You want each product to have a unique rank based on its sales. Which custom table calculation should you use to assign a rank to each product?

Q29. In a Tableau report, you are analyzing a dataset containing product sales data. You need to rank the products based on the average sales amount and identify products in the top quartile. Which calculation should you use to determine the quartile ranking of each product?

Q30. In a Tableau dashboard containing a dense matrix of data, you aim to enhance clarity and reduce visual noise. Which action would most effectively contribute to this goal?

Q31. You want to create a Tableau visualization that shows both the total sales and the average profit margin for each product category over the last year. Which chart type allows you to effectively display both of these metrics?

Q32. Your team needs to analyze a large dataset that is updated monthly. The data is provided to you in a .tde format. What is the most effective way to use this data for monthly analysis in Tableau?

Q33. In your Tableau project, you have a field Total Sales, which is currently being treated as a dimension. When should you convert this field to a measure?

Q34. You are analyzing a dataset of sales transactions in Tableau and want to focus on the top 10 highest selling products. Which filter setting should you use to display only these products in your visualization?

Q36. To understand customer purchasing behavior, you want to create a Tableau visualization that shows the relationship between the age of customers and the average purchase amount. Which chart type would be most appropriate?

Q37. You are analyzing survey data in Tableau and have a field ResponseTime in seconds, currently formatted as a string. For better visualization, you need to convert this time into minutes in a calculated field. What is the appropriate type conversion function to use for ResponseTime?

Q38. In your Tableau dashboard, you need to create a filter that excludes data from a specific region, East, to analyze trends in other regions. What type of filter should you apply?

Q39. When connecting to a relational database for a Tableau project, you need to retrieve a specific subset of data from a large table. Which approach would be most effective?

Q40. In a Tableau project, you need to calculate the number of days passed since the start of the current year for each date entry in your dataset. The dataset includes a Date field. Which calculated field should you create to perform this calculation?

Q41. You are working with a dataset in Tableau that includes a field CustomerName formatted as LastName, FirstName. You need to create a calculated field to display the customers first name only. Which string function should you use in the calculated field to extract the first name?

Q42. You are preparing a dataset for analysis in Tableau and notice several inconsistencies in the Date of Sale column, with some dates recorded in different formats. What action should you take to ensure data quality in terms of consistency?

Q43. In a Tableau report, you are working with a dataset that includes a string field TotalSales representing sales figures. For analytical purposes, you need to use these sales figures in calculations. How should you convert the TotalSales field in your calculated field expression?

Q44. In a Tableau visualization, you are working with a dataset that includes individual customer purchase amounts. You need to create a calculated field that will display the average purchase amount for each customer. Which aggregate function should you use in your calculated field?

Q46. You are analyzing a dataset in Tableau containing employee sales data. You need to create a calculated field to calculate the commission for each employee, which is 5% of their total sales if their sales exceed $10,000, and 3% otherwise. Which calculated field expression should you use?

Q47. You are analyzing sales data from a small business. The dataset is relatively small and is updated weekly. The business needs to access the latest sales trends and analysis through Tableau. What is the most effective way to connect to this data in Tableau?

Q48. You are analyzing sales data for a large retail chain. The data includes millions of transactions and is growing daily. Your analysis requires high-speed interaction with the data for various complex calculations and visualizations. Which connection type should you choose in Tableau?

Q49. In a Tableau dashboard focused on sales performance, you want to apply a color scheme that intuitively represents different levels of sales figures. Which approach is most effective?

Q50. You need to visualize the distribution of customer ages in your dataset to identify the most common age ranges among your customers. Which type of chart would be most appropriate for this analysis in Tableau?

Q52. You are analyzing sales data over time and want to show both the total sales and the average sales per month. Which type of chart is most suitable for this analysis in Tableau?

Q54. In a Tableau visualization, you have a field Total Cost and a field Units Sold. You need to create a calculated field to determine the average cost per unit sold. Which expression should you use for this calculated field?

Q55. You are creating a calculated field in Tableau to categorize sales data into High, Medium, and Low tiers based on the sales amount. Which type of calculation is most suitable for this categorization?

Q56. You are analyzing sales data in Tableau and need to create a report that shows sales performance by the day of the week. The dataset contains a Date field in the format YYYY-MM-DD. Which calculated field should you create to extract the day of the week from the Date field?

Q1. You are creating a Tableau dashboard visualizing regional sales data. To enhance the users understanding of each regions performance, what is the most effective use of tooltips?

Q4. In a Tableau visualization, you have a field Email containing email addresses. You need to create a calculated field that extracts the domain part of each email address (e.g., example.com from user@example.com). Which string function should you use to accomplish this?

Q8. You are analyzing sales data in Tableau and need to identify the total number of unique products sold. The dataset includes a Product ID field for each sale. Which calculated field should you create to find the total number of unique products sold?

Q9. In Tableau, you need to create a calculated field that returns Yes if the Order Quantity is greater than 10 and No otherwise. Which calculation type should you use?

Q11. You are working on a Tableau dashboard to display the top 5 performing sales representatives based on their total sales. The dataset includes a Sales Rep field and a Total Sales field. How should you create a custom table calculation to display only the top 5 sales representatives?

Q16. You are analyzing a dataset in Tableau that includes a Customer ID field, which is currently set as a measure. How should you handle this field for effective analysis?

Q17. In a Tableau visualization, you need to create a calculated field that displays the position of each row in a partition, sorted by the Date field. What custom table calculation should you use to show the row number for each record?

Q19. In a Tableau report, you need to compare the current months sales to the previous months sales. Your dataset includes a Date field and a Sales field. How should you create a custom table calculation to display the sales for the current month so far?

Q21. In a Tableau report, you are analyzing hotel booking data and want to exclude bookings with a duration of less than 3 days for a more focused analysis on longer stays. The dataset includes a Booking Duration field. What type of filter should you apply to the Booking Duration field?

Q28. You are creating a Tableau report to rank products based on their sales performance. The dataset includes a Product field and a Sales field. You want each product to have a unique rank based on its sales. Which custom table calculation should you use to assign a rank to each product?

Q33. In your Tableau project, you have a field Total Sales, which is currently being treated as a dimension. When should you convert this field to a measure?

Q37. You are analyzing survey data in Tableau and have a field ResponseTime in seconds, currently formatted as a string. For better visualization, you need to convert this time into minutes in a calculated field. What is the appropriate type conversion function to use for ResponseTime?

Q38. In your Tableau dashboard, you need to create a filter that excludes data from a specific region, East, to analyze trends in other regions. What type of filter should you apply?

Q40. In a Tableau project, you need to calculate the number of days passed since the start of the current year for each date entry in your dataset. The dataset includes a Date field. Which calculated field should you create to perform this calculation?

Q41. You are working with a dataset in Tableau that includes a field CustomerName formatted as LastName, FirstName. You need to create a calculated field to display the customers first name only. Which string function should you use in the calculated field to extract the first name?

Q42. You are preparing a dataset for analysis in Tableau and notice several inconsistencies in the Date of Sale column, with some dates recorded in different formats. What action should you take to ensure data quality in terms of consistency?

Q43. In a Tableau report, you are working with a dataset that includes a string field TotalSales representing sales figures. For analytical purposes, you need to use these sales figures in calculations. How should you convert the TotalSales field in your calculated field expression?

Q54. In a Tableau visualization, you have a field Total Cost and a field Units Sold. You need to create a calculated field to determine the average cost per unit sold. Which expression should you use for this calculated field?

Q55. You are creating a calculated field in Tableau to categorize sales data into High, Medium, and Low tiers based on the sales amount. Which type of calculation is most suitable for this categorization?

Q56. You are analyzing sales data in Tableau and need to create a report that shows sales performance by the day of the week. The dataset contains a Date field in the format YYYY-MM-DD. Which calculated field should you create to extract the day of the week from the Date field?