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.

2. 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.

3. Can we create sets using measures

No

4. 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.

5. How to do performance testing?

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

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

 Order of execution

LOD

Table Calculations

Reference lines

7. Can we draw 3 reference lines in a single chart?

 No

8. 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.

9. How do we select multiple values in parameters?

We cannot select multiple values in parameters

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

No

 11. 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.

 12. Define fact table?

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

13. 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.

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

Yes. Using sets and combined set.

15. Can parameters have drop down list?

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

16. 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.

17. Difference between scatter 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.

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

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

 19. 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.

Subscribe
to our newsletter

Drop Us A Query

Trending Courses
  • PEGA Testing Training
  • Today application testing is the deciding factor to launch the application into the market. And people do not launch the application unless it goes true.

  • Blockchain Online Course
  • Today many people were enthusiastic, to know the exact details of things happening around him. This can get the proper knowledge on Blockchain.

  • Ethical Hacking Online Course
  • Zeal to learn ethical hacking is common among college students and IT professionals. Because everybody wants to secure their system from cyber attacks.

  • Python 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 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.

  • PEGA 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).


 

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