Oct
14
Head-n-Tail Analysis (Part 2): 30 sec to Dashboard
[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.
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.