- Groups: No, we can not use Groups in calculation fields.
- Sets: Yes, we can use Sets in calculation fields.
Q.Difference between Grouping and Sets.? Ans:
- Groups – Combine dimension members into higher level categories.
- Sets – Create a custom field based on existing dimensions that can be used to encode the view with multiple dimension members across varying dimension levels.
Q.What is context filter.? Ans: If you are applying filters to a large data source, you can improve performance by setting up context filters. A context filter is applied to the data source first, and then the other filters are applied only to the resulting records. This sequence avoids applying each filter to each record in the data source. You may create a context filter to:
- Improve performance – If you set a lot of filters or have a large data
source, the queries can be slow. You can set one or more context filters to improve performance.
- Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.
Q.What is Dual Axis.? Ans: You can compare multiple measures using dual axes, which are two independent axes that are layered on top of each other. Dual axes are useful when you have two measures that have different scales. For example, the view below shows Dow Jones and NASDAQ close values over time. To add the measure as dual axis drag the field to the right side of the view and drop it when you see a black dashed line. You can also select Dual Axis on the field menu for the measure. The two axes are independent scales but the marks are layered in the same pane. Q.What is page self..? Ans: The Pages shelf is a powerful part of Tableau that you can use to control the display of output as well as the printed result of that output. Q.Is there any new features implemented in tableau 8.0 regarding the tableau server performance improvement? Ans:
- Use an extract
- Limit your dashboard to fully answering only one scenario
- Limit the data being introduced to each worksheet
- Remove components that add no value
- Eliminate any non-essential components from the visualization
Q.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? Ans: Tableau 8,8.1 and 8.2 also supported for 4GB ram and core processors. Q.How many viz SQL process should I run? Ans: Depending on Data Capacity Q.How many extracts (extract type) can be used on a single server(without effecting server performance like memory) ? Ans: Better 10 Q.How to check the performance step by step manner(DB, Report side, Network) in tableau report ? Ans: Go to help menu and select performance tuning option Q.How to improve the tableau report performance? Ans: 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. Q.I have one scenario like Year in integer and week in String and wanted to calculate the YTD.. how to do this.? Ans: In Tableau, the relative date filter enables flexible analysis of time periods. Sometimes, however, you might want to see both year-to-date (YTD) and month-to-date (MTD) values for a particular measure on the same view. To accomplish this task, you can create date calculations. Create a calculated column which replaces week from string to integer and make use this in another calculation for YTD. YTD: MTD: Q.What kind of join do you see in data blending? Ans: There won't be any joins as such but we will just give the column references like primary and foreign key relation. Q.What is data blending..? When do you use this.? Ans: Data blending is when you blend data from multiple data sources on a single worksheet. The data is joined on common dimensions. Data Blending does not create row level joins and is not a way to add new dimensions or rows to your data. We use this when we want to fetch data from different sources and make use in single worksheet. Q.Can we have multiple value selection in parameter? Ans: No Q.What is Tableau Server? Ans: Tableau Server is a business intelligence solution that provides browser-based visual analytics anyone can use at just a fraction of the cost of typical BI software. With just a few clicks, you can publish or embed live, interactive graphs, dashboards and reports with current data automatically customized to the needs of everyone across your organization. It deploys in minutes and users can produce thousands of reports without the need of IT services — all within your IT infrastructure. Q.What is the Difference between connect live and import all data and Import some data.? Ans:
- Connect live – Creates a direct connect to your data. The speed of your data source will determine performance.
- Import all data – Imports the entire data source into Tableau’s fast data engine as an extract. The extract is saved with the workbook.
- Import some data – Imports a subset of your data into Tableau’s fast data engine as an extract. This option requires you to specify what data you want to extract using filters.
Q.What does Tableau do? Ans: Our goal is to help people see and understand data. Our software products put the power of data into the hands of everyday people, allowing a broad population of business users to engage with their data, ask questions, solve problems and create value. Q.Who are Tableau’s customers? Ans: Our products are used by people of diverse skill levels across all kinds of organizations, including Fortune 500 corporations, small and medium-sized businesses, government agencies, universities, research institutions and non-profits. Organizations employ our products in a broad range of use cases such as increasing sales, streamlining operations, improving customer service, managing investments, assessing quality and safety, studying and treating diseases, completing academic research, addressing environmental problems and improving education. Q.When was Tableau founded? Ans: Tableau was founded in 2003 by Christopher Stolte, Patrick Hanrahan and Christian Chabot. Q.When did Tableau go public and where does its stock trade? Ans: Tableau Software is traded on NYSE under the ticker symbol DATA. The company went public on May 17, 2013 at an initial public offering price of $31 per share. Q.What are the main features of Tableau Software? Ans: Tableau Software offers the following features:
- Reporting & Dashboard
- Data Analytics
- Business Intelligence
- Ad Hock Query
- Data Hierarchy
- Data Mining
- Multi-Dimensional Analytics
- Analytics on Share Point, the iPad, Android tablets
Q.What are the main benefits of using Tableau Software ? Ans: Tableau Software offers the following benefits:
- Tableau Software is faster than other solutions.
- Tableau Software is an intuitive, drag-and-drop tool that lets you see every change as you make it.
- With Tableau Software you can build smart, fit and beautiful dashboards.
- In Tableau you can connect directly to databases, cubes, data warehouses, files and spreadsheets.
contact for more on Tableau Online Training
Tableau Interview Questions Tags
Tableau interview questions and answers,Tableau online training, Tableau interview questions, Tableau training online, Tableau training, Tableau training institute, latest Tableau interview questions, best Tableau interview questions 2019, top 100 Tableau interview questions,sample Tableau interview questions,Tableau interview questions technical, best Tableau interview tips, best Tableau interview basics, Tableau Interview techniques,Tableau Interview Tips. For online training videos