Which Country celebrates New Years the First

COVID-19 definitely made 2020 a year to remember. 2020 was challenging but New Year 2021 brings hope and happiness. Countries all around the world are welcoming the New Year in a bid to forget the trying times of the past. In this blog, we will use Tableau to display which Country celebrates New Years the first.

Checkout the viz on Tableau Public

Use the play button on the viz to get the animated results.

This exercise will be using the customized version of the data presented in the-sun-com. It uses London time to find out when the world will welcome 2021:

I have taken the data from the above mentioned site and modified it according to my requirements,

Data to display Countries and their celebration date/time
Data customized for the dashboard

Comments column is used to combine the Countries located near to each-other and celebrating New Year at the same time.

Which Country celebrates New Years the First

  1. I will connect to my customized data set NewYearCelebrationByCountries.xls. Follow the steps to connect to xls data set.
  2. From the data pane, double click on Countries column. This will create a Map.
  3. On the data pane, right-click on Date and specify the Custom Date format. You can type the values for the format.
Custom Date format
Specifying Custom Date properties to remove seconds from the time

4. From the data pane, place Date on the Color card (under Marks). When you place Date on Color, it will get automatically aggregated and will display as Year(Date). Right-click on it and select Exact Date. The Date may change to continuous and display in Green color, make sure to right-click on it again and select Discrete.

Place Comments on the Detail. This will help in displaying the tool-tip.

5. Click on Color and click on Edit Colors to select your desired color. For this example, I selected the gold color.

This will display your Map with dots.

6. From Menu/Map select Map Layers and choose Background style as dark.

The right-most dots represents the locations where New Years is celebrated first.

Map displaying Countries with New Year celebration times
Map displaying Countries with New Year celebration times

Add Animation to see how the celebration moves from one country to another

To add animation, place Date to the Pages card. If the Date aggregates to Year(Date), right-click and choose the exact date.

This will display a Date play control on the view. This control can be used to play/run the animation.

Play control
Play Control

Checkout the animated Map. Use the play button.


About the Author

Chandraish Sinha has  20+ years of experience in Information Technology. He is an accomplished author and has published 11 books covering Business Intelligence related topics such as, Tableau,Power BI, and Qlik. Checkout his Amazon Author profile.

His latest book Excel Basics to Advanced covers all the aspects of MS Excel and provides exercises for self-learning.

Similarly, his recent book, Dashboarding with Tableau, covers all the features in Tableau and includes exercises for self-learning.

He has implemented IT solutions in different domains viz. Pharmaceutical, Healthcare, Telecom, Financial and Retail.

He blogs regularly on various IT topics. Check them out in the links given below: 

Blogs

Learn Tableau

Learn All Bi

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.