Tableau Interview Questions and Answers 

  1. What do you mean by addressing and partitioning?

When you add a table calculation, you must use all dimensions in the level of detail either for partitioning (scoping) or for addressing (direction):

  • The dimensions that define how to group the calculation, that is, define the scope of data it is performed on, are called partitioning fields. The table calculation is performed separately within each partition.
  • The remaining dimensions, upon which the table calculation is performed, are called addressing fields, and determine the direction of the calculation.
  1.  What is the difference between sets and groups?

Group- 1)group is category purpose 2) calculation field not a possible in group

Sets- 1)sets is a grouping purpose based on the some condition. 2) calculation field possible in sets.

  1.  Can we create sets using measures

         No

  1. What is the difference between Data blending and join?

Joining is a SQL term that refers to combining two data sources into a single data source.  Blending is a Tableau term that refers to combining two data sources into a single chart.  The main difference between them is that a join is done once at the data source and used for every chart, while a blend is done individually for each chart.

  1. How to do performance testing?

Performance testing is again an important part of implementing tableau. This can be done by loading Testing Tableau Server with TabJolt, which is a “Point and Run” load generator created to perform QA. While TabJolt is not supported by tableau directly, it has to be installed using other open source products.

  1. What is the order of execution of table calculation, LOD, reference lines?

         Order of execution

  1. LOD
  2. Table Calculations
  3. Reference lines
  4. Can we draw 3 reference lines in a single chart?

        No

  1. What are limitations of context filter?

The context filter is not frequently changed by the user – if the filter is changed the database must recomputed and rewrite the temporary table, slowing performance.

  1. How do we select multiple values in parameters?

We cannot select multiple values in parameters

  1.  Can we perform all kinds of joins using Data blending?

No

  1.  How can we combine database and flat file data in Tableau desktop??

You can combine them by connecting data two times, one for database tables and one for flat file. The Data->Edit Relationships. Give a join condition on common column from db tables to flat file.

  1.  Define fact table?

Fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables.

  1. How do you automate reports using Tableau software?

Steps to automate the reports: while publishing the report to Tableau server, you will find the option to schedule reports. Click on this to select the time when you want to refresh the data.

  1.  Can we display top five and last five sales in same view?

Yes. Using sets and combined set.

  1.  Can parameters have dropdown list?

Yes, parameters do have their independent dropdown lists enabling users to view the data entries available in the parameter during its creation.

  1.  What is the purpose of using page shelf?

The Pages shelf lets you break a view into a series of pages so you can better analyze how a specific field affects the rest of the data in a view.

  1. Difference between scattere plot vs Tree map?

Tree Maps – Display data in nested rectangles. We use dimensions to define structure of the tree maps and measures to design the size or color of the individual rectangle. We cannot add trend lines in Tree maps.

Scatter plot – provides an easy way to visualize relationships between numerical variables. We can add trend lines.

  1.  How To remove the All options from a Tableau auto-filter? 

Edit the quick filter from the pull-down arrow.  Go to “Customize” and uncheck the “Show “All” Value” checkbox.

  1.  How do you optimize performance of dashboard?
  • Minimize the number of fields based on the analysis being performed. Use the hide all unused fields option to remove unused columns from a data source.
  • Minimize the number of records. Use extract filters to keep only the data you need.
  • Optimize extracts to speed up future queries by materializing calculations, removing columns and the use of accelerated views.
  • Remove unneeded dimension from the detail shelf
  • Reduce number of filters
  • Use context filter
  • Use Boolean calculations

  20. How to use group in calculations field?

By adding the same calculation to ‘Group By’ clause in SQL query or creating a Calculated Field in the Data Window and using that field whenever you want to group the fields.
• Using groups in a calculation. You cannot reference ad-hoc groups in a calculation
• Blend data using groups created in the secondary data source: Only calculated groups can be used in data blending if the group was created in the secondary data source.
• Use a group in another workbook. You can easily replicate a group in another workbook by copy and pasting a calculation.

Drop Us A Query

Trending Courses
  • Python and Django Online Training
  • Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.

  • Tableau Online Training
  • Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.

  • MicroStrategy Online Training
  • Micro Strategy is one of the few independent and publicly trading Business Intelligence software provider in the market. The firm is operational in 27 Countries around the globe.

  • PEGA (PRPC) 7.2 Certification Online Training
  • Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).

  • Workday Online Training
  • Workday specialises in providing Human Capital Management, Financial Management and payroll in online domain.It is a major web based ERP software vendor.

  • Power BI Online Training
  • Power BI is business analytics service by Microsoft. With Power BI, end users can develop reports and dashboards without depending on IT staff or Database Administrator.


 

100% Secure Payments. All major credit & debit cards accepted.