Which new features added in V9?

What is the difference between tableau 8.0 and 9.0 versions
1) Visual Analytic's 

a) Type-in shelves

b) Free-form Calculation

c) Drag & Drop Calculation

d) New Calculation Editor 

e) Instant reference line & trend line 

g) Geographic Search 

2) Speed (3-4 times faster than current version) a) Muti-core Query Execution b) Vector Operations Support c) Parallel Queries d) Continuous Tool-tips e) Responsive Pan & Zoom f) Persisted Query Cache

3) Data Preparation a) Uninviting b) Web Service API Connector c) Splitting of Data automatically

4) Enterprise a) Now on server with a simple ease you can provide credentials to different business users on fly b) Server will be more secure & faster

5) Mobile a) Tableau has started a program for mobile users & they named it as “Project Elastic”. b) It is more faster & user friendly c) Now you do not need internet connection for running your dashboard on mobile or tablets.


What is the difference between tableau 7.0 and 8.0 versions
• New visualizations are introduced like treemap, bubble chart and box and whisker plot
• We can copy worksheet directly from one workbook to another workbook
• Introduced R script.
• Story, it is new report type it was introduced in 8.2.
• We can customize the “Tool Bar” in 8.2.


Tableau 8.1 to 8.2 

The following new features are added in 8.2 Release:
1) Tree Maps, Bubble,
2) Accessing Tableau Server dashboards through a proxy server using Tableau Mobile would sometimes result in connection errors.
3) 8.2 Supports MAC.
4) Story Points
5) Increased Map features in this release.
6) Visual Data window.

What are the major differences between tableau version 7.0 and tableau version 8.0?

•1) New visualizations are introduced like tree-maps, bubble chart and box, 
whisker plot •We can copy worksheet directly from one workbook to another workbook.

2) •Introduced R script

3) Visualizing the Relationships among the Tables.

If we want to compare values over time, which chart is the best option?

there 2 Different kind of charts are best viz to show the Trend Charts

1) Line Chart

• 2) Area Chart

Heat map: A heat map is a great way to compare members of a Dimension using color and size. In this, 
you can compare two different measures.

Tree Map: It is a very powerful visualization, particularly for illustrating hierarchical (tree-structured) data and part-to-whole relationships.

How to add Custom Color Palette in Tableau?

Tableau offers three types of color palettes: categorical, sequential, and diverging. You can create your own custom color palette by modifying the Preferences.tps file that comes with Tableau Desktop. The Preferences.tps file is located in the My Tableau Repository. The preferences file is a basic XML file that you can open in a text editor to modify. In tableau 9.0 version there is a color picker option.

TDE Limitations

1) TDE file size limitations is 2 GB to 200 GB.

2) Very tough algorithms are used to compress the data size in Tableau TDE .

3) TDE converts the data size into 0.1-2% of original data size.
it means 4 GB of Data in Oracle convert into 500 MB. 

Limitations of TDE (Extracts)

1) TDE file limitaion is 

How to add Custom Color to Tableau?

Adding a Custom Color refers to a power tool in Tableau. Restart you Tableau desktop once you save .tps file. From the Measures pane, drag the one you want to add color to Color. From the color legend menu arrow, select Edit Colors. When a dialog box opens, select the palette drop-down list and customize as per requirement.

How to remove All options from a Tableau auto-filter?

we can easily remove the "All" option from Filter, how that is right click on Filter, click on ‘Customize’ in the drop down and then deselect the ‘Show “All” Value’ attribute. It can be activated by checking the field again.

How many maximum tables can you join in Tableau?

The limitations while connecting from Tableau to Database is : The maximum number of 32 tables can be joined in Tableau. A table size must also be limited to 255 columns (fields).

How to do Performance Testing in Tableau?

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.

Difference between Aggregate & Non-Aggregate Measures

AGGREGATED MEASURES

Aggregate measures means implementing one of the Arithmetic Calculations.
It means After the calculations.

EX: Sum((Sales])

If you want to filter the data where Sales volume is more than 2000000 after the calculation then we can use the following approach.

If Sum([Sales])  >= 2000000 then "Show" end

NON-AGGREGATED MEASURES

NON-AGGREGATED MEASURES means without using the any kind of Arithmetic Calculations.

EX: (Sales])

What is Data Visualization?

Data Visualization is the process of using the Methods & Technologies to interpret & representing the data in right way.

Target Audience of  Data Visualization are : Middle & Top Level Management. These VIZ are used to Understand the BUZ, Make the Decision accordingly and it is sued to know the trends of the BUZ, Analyze the BUZ, Compare with competitors to know where are standing in the market.

Representing the Data means Show the data in meaningful way, Once we build the Views those sould be understandable to the end users without our interpretation.