VDS TECH LABS

Q1: What are the different ways to use parameters in Tableau? Ans: 1. Filters 2. calculated fields 3. Actions 4. Measure-swaps 5. changing views 6. auto updates Q2: Are there any limitations of parameters in Tableau? If yes, give details. Ans: Tableau dashboard allows the representation of parameters in four ways only. They don’t allow any multiple values like a filter can do. They only allow a single value. Q3: Explain when would you use Joins vs. Blending in Tableau? Ans: If data resides in a single source, it is always desirable to use Joins. When your data is not in one place blending is the most suitable way to create a left join like the connection between your primary and secondary data sources. Q4: What is the benefit of Tableau extract file over the live connection? Ans: Extract file can be used without any connections and you can build your own visualisation without connecting to the database. Q5: If I delete a workbook from tableau public and there ar...

Q1: Which one is better? Extract or Live connection?  Ans: ​Extract connection is better than live connection because extract connection can be used from anywhere, anytime without connecting to database. We can construct our own visualizations on it irrespective of database connection.  Q2: What is the difference between bar chart and column chart in Tableau?  Ans:​ Both are used to compare two or more values. However, their difference lies in their orientation. A Bar chart is oriented horizontally whereas the Column chart is oriented vertically. Both the Bar and the Column charts display data using rectangular bars where the length of the bar is proportional to the data value.  Q3: What is a Stacked Bar chart and Stacked Column Chart?  Ans:   Stacked Bar Chart​ composed of multiple bars stacked horizontally, one below the other. The length of the bar depends on the value in the data point. Stacked bar chart make the work easier, they will help us...

Q1: What are different Joins in Tableau ? Ans: Tableau works the same as SQL. So, it supports all joins possible in SQL ➢ Left Outer Join ➢ Right Outer Join ➢ Full Outer Join ➢ Inner Join Q2: Define LOD Expression? Ans: LOD Expression stands for Level of Detail Expression, and it is used to run the complex queries involving many dimensions at data sourcing level. Q3: What is a parameter Tableau? And how it works? Ans: Parameters are dynamic values, we can replace the constant values in calculations. Q4: How many maximum tables can you join in Tableau? Ans: You can join a maximum of 32 tables in Tableau. Q5: What is the difference between Traditional BI Tools and Tableau? Q6: What are the different filters in Tableau and how are they different from each other? Ans: In Tableau, filters are used to restrict the data from database. The different filters in Tableau are: ➢ Quick , ➢ Context ➢ Normal/Traditional filter are: Normal Filter is used to restrict...