Tableau Hierarchy, Create Custom Hierarchy in Tableau, Relation between Drill downs, Roll ups, Hierarchies. Automatic Hierarchies.

What is a Hierarchy ?
Relation between Drill downs, Roll ups and Hierarchies.
What are Automatic Hierarchies?
How to create Custom Hierarchy in Tableau ?

What is a Hierarchy ?

From Data Warehouse concepts point of view and Data Analytics point of view, Hierarchy is arrangement of UNIQUE ATTRIBUTES in LOGICAL ORDER.

Example: TIME can have YEAR, MONTH and DAY hierarchy (or) LOCATION can have COUNTRY, STATE and CITY hirarchy.

Relation between Drill downs, Roll ups and Hierarchies.

Drill downs and Roll ups are dependent on the Hierarchy unique attributes. In TIME hierarchy we can Drill down from YEAR to MONTH, MONTH to DAY. We can also roll up from DAY to MONTH, then MONTH to YEAR.

What are Automatic Hierarchies?

When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the view by year, quarter, month, etc. We can observe a PLUS symbol adjacent to the field those are part of the HIERARCHY.

How to create Custom Hierarchy in Tableau ?

Tableau allows to create our own custom hierarchies. When the source data related to planned hierarchy is divided in to multiple columns, we will be forced to create our hierarchy.

Example: Assume source table contains columns such as COUNTRY, STATE, CITY. After connecting with Data source using Tableau, we can see three different dimensions COUNTRY, STATE and CITY. We can create a custom hierarchy called LOCATION by selecting COUNTRY, STATE, CITY then right click, in the pop up window name the hierarchy as LOCATION. Now drag drop COUNTRY from LOCATION Hierarchy in to Data Window columns, you can observe a PLUS symbol adjacent to COUNTRY indicating HIERARCHY.

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