by Shanmugapriya J, on Jun 3, 2023 4:06:48 PM
6. What are the different types of filters in Tableau?
Answer: Tableau offers various filters, including dimension filters, measure filters, table calculations, and context filters.
7. What is a calculated field in Tableau?
Answer: A calculated field in Tableau is a field created by performing calculations on existing fields or measures. It allows users to create new dimensions or measures based on specific criteria or formulas.
8. How do you create a dual-axis chart in Tableau?
Answer: To create a dual-axis chart in Tableau, you can drag two measures onto the Rows or Columns shelf and then right-click on one of the measures and select "Dual Axis."
9. What is data blending in Tableau?
Answer: Data blending in Tableau is the process of combining data from multiple data sources on a single worksheet or dashboard.
10. What are parameters in Tableau?
Answer: Parameters in Tableau allow users to create dynamic, interactive elements that can be used to change values, calculations, or filters in a visualization.
11. How can you enhance performance in Tableau?
Answer: Performance in Tableau can be improved by minimizing the number of rows and columns displayed, using data extracts instead of live connections, optimizing calculations, and filtering data appropriately.
12. What is the difference between a worksheet and a dashboard in Tableau?
Answer: A worksheet is a single view or chart that represents a specific analysis, while a dashboard is a collection of multiple worksheets and other objects arranged on a single canvas for a consolidated view.
13. How can you share Tableau visualizations with others?
Answer: Tableau provides several options for sharing visualizations, such as publishing to Tableau Server or Tableau Online, exporting as an image or PDF, or embedding in other applications.
14. How can you create a calculated field in Tableau?
Answer: To create a calculated field in Tableau, you can right-click on a blank area in the Data pane, select "Create Calculated Field," and then write the calculation using Tableau's formula syntax.
15. What is the use of LOD expressions in Tableau?
Answer: LOD (Level of Detail) expressions in Tableau allow users to perform calculations at different levels of granularity in the data, regardless of the visualization or filters applied.
16. What is the difference between a quick filter and a normal filter in Tableau?
Answer: A quick filter allows users to interactively filter data directly on a visualization, while a normal filter is applied to the entire worksheet or dashboard.
17. How can you create a hierarchy in Tableau?
Answer: To create a hierarchy in Tableau, you can drag and drop related dimensions onto each other in the Dimensions pane, creating a parent-child relationship.
18. How can you sort data in Tableau?
Answer: Tableau provides various options to sort data, such as sorting by a specific field, sorting by a measure, or using a custom sort order.
19. What is the use of the Tableau Desktop Data Source tab?
Answer: The Data Source tab in Tableau Desktop allows users to connect to data sources, manage metadata, perform data preparation tasks, and define relationships between tables.
20. How can you perform forecasting in Tableau?
Answer: Tableau provides forecasting capabilities for time-series data. Users can enable forecasting by right-clicking on a time-series chart and selecting the "Forecast" option.
21. What is the difference between a discrete and continuous field in Tableau?
Answer: A discrete field represents categorical or distinct data, while a continuous field represents quantitative or continuous data.
22. What are the different types of joins in Tableau?
Answer: Tableau supports different types of joins, including inner join, left join, right join, and full outer join.
23. How can you create a parameterized calculation in Tableau?
Answer: To create a parameterized calculation in Tableau, you can use a parameter as an input in a calculation formula to make it dynamic and user-controlled.
24. What are the options for data connection in Tableau?
Answer: Tableau offers various data connection options, including connecting to local files (e.g., Excel, CSV), databases (e.g., SQL Server, Oracle), cloud services (e.g., Salesforce, Google Analytics), and more.
25. How can you perform data blending in Tableau?
Answer: Data blending in Tableau can be done by connecting to multiple data sources, defining a relationship between common fields, and blending the data on a worksheet or dashboard.