Monday, 17 March 2014

Tableau Interview Questions -FAQs

  1. Is there any new features implemented in tableau 8.0 regarding the tableau server performance improvement?
  2. What are the other settings I need to reconfigure to get better performance as I am using 7.0 tableau server and planning to upgrade to latest versions?Suggest best configurations based on the provided server details?
  3. How many viz SQL process should I run?
  4. How many extracts (extract type) can be used on a single server(without effecting server performance like memory) ?
  5. What are the possible reasons for slow performance in Tableau?
  6. How to check the performance step by step manner(DB, Report side, Network) in tableau report ?
  7. How to improve the tableau report performance?
  8. How we can find the tableau Report Rendering Time.?
  9. What kind of technology is a Tableau Viz?
  10. Is there a limit on storage space for the data?
  11. How do you create dashboard.? Can you explain the life cycle.?
  12. Can you explain about table calculations?
  13. I have one scenario like Year in integer and week in String and wanted to calculate the YTD.. how to do this.?
  14. What kind of join do you see in data blending?
  15. What is data blending..? When do you use this.?
  16. When do you use horizontal and vertical components?
  17. Name the components of dashboard?
  18. Can we have multiple value selection in parameter?
  19. What are parameters and when do you use it?
  20. What is the difference between tableau 7.0 and 8.0 versions?
  21. How Does Tableau Work?
  22. What is Tableau Reader?
  23. What is Tableau Server?
  24. What is Tableau Desktop?
  25. What is the Defference between quick filter and Normal filter.?
  26. What is the Difference between connect live and import all data and Import some data.?
  27. How do I automate reports using Tableau software?
  28. How does Tableau perform with huge datasets?
  29. How is Tableau so fast when working with databases?
  30. How many types of filters are there in Tableau.?

Is there any new features implemented in tableau 8.0 regarding the tableau server performance improvement?

1. Use an extract:
2. Limit your dashboard to fully answering only one scenario:
3. Limit the data being introduced to each worksheet:
4. Remove components that add no value:
5. Eliminate any non-essential components from the visualization

What are the other settings I need to reconfigure to get better performance as I am using 7.0 tableau server and planning to upgrade to latest versions?Suggest best configurations based on the provided server details?

Tableau 8,8.1 and 8.2 also supported for 4GB ram and core processors.

How many viz SQL process should I run?

Ddepending on Data Capacity 

How many extracts (extract type) can be used on a single server(without effecting server performance like memory) ?

Better 10

What are the possible reasons for slow performance in Tableau?

More Extracts, filters and depends on data sources

How to check the performance step by step manner(DB, Report side, Network) in tableau report ?

Go to help menu and select performance tuning option 

How to improve the tableau report performance?

If you are not planning on using a set of rows, you should filter them out of the data set as early as possible. If your table contains all sales, and you only want to look at US sales, create a Custom SQL query that filters it out. If the filter is worksheet dependent, try using a Context Filter. For more information on filtering, check out my other post Types of Filters in Tableau. You can also click the Down Arrow beside the word "Dimension" and Select "Hide All Unused Fields" to hide any fields you are not using in any of your worksheets. I'm not sure if this improves efficiency; but I'd have to imagine that it does, less data should always improve performance.

How we can find the tableau Report Rendering Time.?

Report rendering time=Network time(request from URL to Report server) +Query execution time + Network time(response from SQL Server)+calculations(table column)+time taken to display the report in desired format(html/ pdf/ excel)

What kind of technology is a Tableau Viz?

It is a thin AJAX based JavaScript application