81. Mention whether you can create relational joins in Tableau without creating a new table?
Yes, we can create relational joins in Tableau without creating a new table
82. When publishing workbooks on Tableau online, sometimes an error about needing to extract appears. Why does it happen occasionally?
It happens when the user is trying to publish the workbook which is connected to the internal or local server that means the company’s network.
83. Can parameters have a drop-down list?
Yes, Parameters have their own drop-down list, which enables the users to view the data entries which are available in the parameter during the creation.
84. How do you optimize the performance of the dashboard?
- Minimize the number of fields.
- Minimize the number of records.
- Reduce the marks (data points) in your view( remove unneeded dimensions).
- Reduce the number of filters.
- Use an include filter.
- Use a continuous data filter.
- Use action filters and parameters.
- Reduce the number of nested calculations.
- Remove custom SQL.
- Clean up your workbooks.
85. How to use groups in the calculation field?
Option 1:
We can create the group by using the calculated field.
- Step 1: Select Analysis-> click the calculated field
- Step 2: Enter the field name (a dialogue box will appear)
- Step 3: Enter the calculation -> Click Ok.
Example:
IF [Container]=’Jumbo Box’ then ‘Big Containers’
ELSEIF [Container]=’Jumbo Drum’ then ‘Big Containers’
ELSEIF [Container]=’Large Box’ then ‘Big Containers’
ELSEIF [Container]=’Medium Box’ then ‘Midsize Containers’
ELSEIF [Container]=’Wrap Bag’ then ‘Midsize Containers’
ELSEIF [Container]=’Small Box’ then ‘Little Containers’
ELSEIF [Container]=’Small Pack’ then ‘Little Containers’
END
The above calculation creates the group with four values: Little Containers, Big Containers, Small Containers, Midsize Containers.
Option 2:
Create a set from the group, and use the set in the calculated field.
Step 1: Right-click on the Data Pane and then select Create Set.
Step 2: Create a set dialogue box that will open,
Enter the field name.
Select the group, on the general tab.
Step 3: Click Ok.
86. Can Tableau be installed on macOS?
Yes, Tableau can be installed on both the Windows Operating system and macOS.
87. How to automate reports in Tableau?
When we are publishing the reports to Tableau Server, there we will find an option to schedule the report, just select the time when you want to refresh the data.
88. Which databases give the best performance when connected live?
Native Database gives the best performance when connected live.
89. What are the challenges faced when working with huge volumes of data?
- View running will be slow.
- Data Extraction.
- Alignment issues with data.
- Testing Data.
90. State limitation of context filters in Tableau
Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time the view is triggered. So, if the context filter is changed, the database needs to recompute and rewrite the temp table, which in turn slows down the performance.
91. What is a marks card in Tableau?
There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip.
92. Define a published data source
The published data source has connection information in it. It is independent of any workbook and can be accessed by multiple workbooks.
93. Define blended axis
Multiple measures can share a single axis so that all the marks will be shown in a single pane. We can blend measures by dragging the 1st measure on one axis and the 2nd on the existing axis.
94. Can we remove the “All” option from the auto-filter in Tableau?
Yes, we can. Navigate to filter→ Right-click on it→ select customize→ uncheck the option “Show All”
95. Define Bullet graph
A bullet graph is a variant of a Bar graph. It is responsible for comparing the performance of one measure with other measures.
96. Define Gantt chart
Gantt Chart displays the progress of value over the period. It consists of bars along with the time axis. It is a project management tool. Here, each bar is a measure of a task in the project framework.
97. Define Histogram chart
A histogram chart shows the distribution of continuous information over a certain period of time. This chart helps us to find extreme points, gaps, unusual values, and more concentrated values.
98. What is Tableau Public?
Tableau Public is an open-source and free service that allows anyone to publish the data source and visualizations to the web. These visualizations can then be embedded into blogs or web pages. They can also be distributed through email or social media. Moreover, they can be made downloadable by other end users. For Tableau Public, no programming skills are needed. It can be accessed by anyone free of cost.
99. What are groups?
A group is a combination of dimension members that make higher-level categories. For instance, if one is working with a view that shows average test scores by major, then certain majors can be grouped together for major categories.
100. How can you share your Tableau workbooks with others?
- There are various ways to share the Tableau workbooks
- You can publish your workbook on the Tableau server.
- Export the workbook as an image file or PDF
- Create interactive Tableau stories that can be shared as web links.
