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

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