[Head-n-Tail Analysis (Part 1): The Toolkit]

In Part I, I explained what head-n-tail analysis is. Here I will show how you can make an analysis dashboard of your own data in no time.

To make it simple, I made a dashboard template (on English Premiere League teams TV revenue) for download. All you need to do is to plug in your data and generate a dashboard of your own in 30 seconds.

Assume that you have your data ready in an excel file with one dimension and one measure. Make sure the data is on "Sheet1". Here is a few data sets for you to try: File1 and File2.

Then follow these 3 steps: (based on File1)

1.Edit Data Source (data connection) to load your excel file. The data must be on "Sheet1".

You may see columns with nulls and  red ! sign.
2

[Head-n-Tail Analysis (Part 2): 30 sec to Dashboard]

What is head-n-tail analysis? It consists of top ranking and tail aggregation.

Recently I have had a few different analysis cases which can all use the same simple yet powerful methodology. It seems quite a fundamental analysis that can be applied widely.

The color palette we use the most in Tableau is either discrete or gradient. Discrete colors are applied to categorical data or dimensions. Gradient colors are applied to numerical data or measures.

Here we try to go beyond the dichotomy of discrete and gradient. Rather our approach is a combination of both discrete and gradient color palette. We will use color to categorize numerical data and apply gradient color to a subset of the data.
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.