61. Can we remove the All options from a Tableau auto-filter?
Follow few steps
- Go to the Segment filter, Click on the small drop arrow which is on the right side.
- Select Customize.
- Then we can visible a small dropbox under customize, uncheck the option for “ All” Value.
62. Which one is better? Extract or Live connection?
Extract connection is better than live connection because extract connection can be used from anywhere, anytime without connecting to the database . We can construct our own visualizations on it irrespective of the database connection.
63. Tell me something about the workbook version controlled in Tableau.
Versioning of workbooks can be done in 2 ways in Tableau.
- At the desktop level, you keep copies of your changes and files or use 3rd party systems like Microsoft TFS.
- At the server level, where you publish the data source and version will be saved in revision history on Tableau Server or Online. Reverting to a previous version is also possible here.
64. Where can we apply global filters?
Global filters can be applied to sheets, stories, and dashboards.
65. How to add custom color to Tableau?
To add custom color in Tableau, we need to follow 3 steps
- Generate a custom color code and create it in “Preferences.tps”
- Navigate to Documents→ My Table Repository→ Preferences.tps
- Add a note for custom color code
66. Can we create cascading filters without using context filters?
Cascading filters mean filter2 values are dependent on filter1 values. For Example, filter1 is country and if we select “India” for filter1, filter2 values should show all Indian states. This feature we can achieve by using the option “Only Relevant Values”.
67. How can we display the top and bottom 5 of records in a single Tableau view?
To achieve this, we need to create 2 views
- View1 which contains the top 5 records
- View2 which contains the bottom 5 records
- View3 which is a join of View1 and View2
68. State a few charts that we should not use with valid reasons
Below are a few charts that we should avoid.
- 3D Charts: Visual representation of numbers in 3D charts will be skewed and it makes it difficult to compare and analyze.
- Pie Charts: Pie charts are not as accurate as bar charts. In Pie charts, we have areas and angles to compare instead of length in a bar chart. Areas and angles cannot be analyzed with ease.
- Donut Charts: This is the same as the Pie chart, but here, we have a hole in the middle to make it look like a donut. Due to that hole, we need to compare arc length with other arcs to analyze the values. Comparing arc lengths is also a difficult task for our eyes.
69. Do we have any way to handle null values in Tableau?
Tableau cannot plot null values on the-axis. So, it will display an indicator at the lower right corner of the view. Once you click on that indicator, you have options to handle null values. Below are the options available to handle null values.
- Filter Data – If you choose this option, null values will be filtered out from the view.
- Show Data at Default Position – It replaces the null value with the default value and shows the data at the default position on-axis. These default values depend on the data type of field. Below are the defaults of a specific data type.
- Numbers →0
- Dates → 12-31-1899
- Geographic Location → (0,0)
- Negative Values → 1
70. Do we have any data limitations in Tableau Public?
Yes, Tableau Public can only allow 10 million rows to users for data visualization.
71. Can we download views or workbooks from the server? If yes, in which data formats?
We can download views or workbooks from the server. But, data formats available to us depend on the permissions granted by site administrators or content owners.
- Image: .png format
- Data: .csv file.
We can also download selected sheets into PDF format, but while generating PDF, web page objects won’t be included.
72. Can we use unused columns (Columns that are not used in reports but data source has columns) in Tableau Filters?
Yes, we can use unused columns in tableau filters.
Let us consider one example.
In the data source, I have columns like emp_id, emp_name, emp_sal, emp_dep, and emp_designation. But, in reports, I am using emp_name in columns and emp-sal in rows. I can use emp_designation on filters.
73. What is the benefit of the Tableau extract file over the live connection?
Extract files can be used without any connections and you can build your own visualization without connecting to the database.
74. How many table joins are possible in Tableau?
We can join 32 tables in Tableau.
75. Can we place an excel file in a shared location and use it to develop a report and refresh it in regular intervals?
Yes, we can place an excel file in a shared location and we can use it to develop a report, but for better performance, we need to extract the file.
76. How do we do testing in Tableau?
Yes, we can do testing in Tableau by using tools and the easiest way is using the desktop application. We need to check it before we publish it on the Tableau server.
77. Can you get values from two different sources as a single input into a parameter?
Tableau, currently not supporting the multi-valued parameters. As Tableau parameters are not dynamic, we cannot filter the list of values at runtime.
78. Design a view in a map such that if a user selects any state the cities under that state have to show profit and sales.
If you want to show the profit and sales of each and every city under the state in the same worksheet, then follow a few steps.
The data which you want to display under the state, must be in the same worksheet.
- Double click on the state filed.
- Drag the city and drop it under the state(Mark Card).
- Drag the Sales and drop into the size.
- Drag the Profit and drop it into the color.
- Click on the size legend and increase the size (75%).
- Give a right-click on the State field and select the show filter.
- Select the state and check whether you got the required view or not.
In the View, Size indicates the Sales, and Color indicates the profit of the respective state(which you have selected).
79. How can you set permissions or protect the data in tableau public?
Tableau does not have any security permissions or to protect the data in Tableau public. Whatever we share in Tableau public those files, workbooks can be viewed by all users. There is no security option in Tableau public.
80. If I delete a workbook from tableau public and there are links to other blogs and other web locations. What happens to them?
Tableau public is like a repository, if you delete anything in the Tableau public the data will be lost, even if links are in other locations and blogs. We cannot access those links.
