Tableau Table Calculations - Difference Between RANK and INDEX. These calculations can include FIRST, LAST, COUNT etc.

Explain Difference between RANK and INDEX ?

RANK and INDEX are part of Table calculations in Tableau.

INDEX mainly deals with physical position of the record, incremental numbers are assigned based on the physical order of the records.

Example:

SUM(SALES) INDEX
10000 1
40000 2
20000 3
30000 4

RANK mainly deals with the value of the record, highest value gets highest rank, lowest gets the lowest rank.

Example:

SUM(SALES) RANK
10000 4
40000 1
20000 3
30000 2

TABLEAU INTERVIEW QUESTIONS - INDEX

Can tableau store huge amounts of data in-memory engine?
How to handle huge volume of data in Tableau?


Explain What is Tableau Calculations - Addressing and Partitioning.


Tableau Hyper, Tableau Hyper's Unique Design, Tableau for Faster Analytics.


How to create Tableau Parameters, where to use and how to use Tableau parameters.


Tableau Dashboards Performance Issues and Challenges, data refresh, network and connectivity.


Tableau 2018.1 , 2018.2 and 2018.3 Features


What is performance recording in Tableau Server? How to implement performance recording in Tableau Server?


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