Types of Filters in Tableau, Quick, Global, Context, At Source, on Measures, Dimensions, Null, Non Null, Not Null, All, General, Wildcard, Condition, Top and Bottom, Range, At Least, At most and Special.

Explain Types of Filters in Tableau - Quick, Global, Context, At Source, On Dimensions and Measures?

Quick Filter: Quick Filter Creates an interactive selection panel on the right top corner of the data view. We can implement Quick Filter on Dimensions or Measures. The interactive selection panel provides the options based on the source data.

Example: Quick Filer on Order Date with Yearly Consolidation provides list of YEARS available from SOURCE DATA for user selection.

Global Filter: Global Filter helps to share the same filter using the same source data across multiple (or) all worksheets within a workbook. We can apply global filter for all the work sheets using the same data (or) It can be applied to only selected worksheets.

Example: Filter with Complex calculation in one worksheet can be applied to some other worksheet which using the same source data to avoid repetetive work.


Context Filter: Context Filter helps to pass the criteria of the filter from one level to other related level.

Example: Top 10 Customers in country by their purchases, here the context is 'Top 10'. We can pass this context to know 'Top 10' Customers by Purchases in a State within the same country.


Filter at Source: After connecting with the data source, filtering the data before getting in to worksheet is called filtering at source. This helps in improved performance because the unwanted data eleminated.

Example: Selecting only one year worth of data from few years of historic data after connecting with the source.


Filter on Measure: This filter provides options - range of values, at least, at most and special. We can select any option that helps to select the right data or eleminate the unwanted data. Special option is to deal with Null values.

Example: Filter on Sum of Sales.


Filter on Dimension: This filter provides options - General, Wildcard, Condition and Top/Bottom. We can select any option that helps to select the right data or eleminate the unwanted data. We can also create own formula then use it in this filter options - Condition and Top/Bottom for the data selection needs. Condition and Top/Bottom provides channel from dimension to measure to get the required data.

Example: Filter on Order Date then selecting sales through dimension.


TABLEAU INTERVIEW QUESTIONS - INDEX

Differences between Tableau 9.3 and Tableau 10.0, 10.1, 10.2, 10.3 and 10.4 ( 9.x vs 10.x versions )

Differences between Tableau 8.3 and Tableau 9.2, 9.1, 9.0 versions ( 8.x vs 9.x versions)

Discuss Difference between 'Data Blending' and 'Data Joining'

Explain Tableau Architecture

MTD, YTD Reports using Tableau Table Calculations

Difference between RANK and INDEX

Types of Data Connections, LIVE vs EXTRACT (IN-MEMORY)

Difference between Individual, Dual and Blended Axis

Types of Filters Quick, Global, Context, At Source, On Dimensions and Measures

Differences between Tiled and Floating in Tableau Dashboard.

Custom Geocoding in Tableau.

Tableau File Types extensions .twb vs .twbx .tde .tdsx .tds .tbs

Tableau Automatic vs Custom Hierarchies Creation

Tableau Actions Difference Filter vs Highlight vs URL

Tableau Workbook Stories Dashboards Worksheets

Tableau Trend Analysis Forecast Models Difference

Summary of Tableau Desktop 9.2 new features (includes Tableau 9.2, 9.1 and 9.0)

Level of detail ( LOD ) expressions, Calculation,Cohort analysis