Using the new Tableau version 2020.1 onwards. To build a bar chart race is to create many discrete pages of bar charts and then string them together, just like how a traditional cartoon animation is built. In Dec 2019, Tableau released 2020.1 beta version with a new Animations feature for dynamic parameters. This means that the bar chart race below is now very easy to build. Watch it in action: https://www.youtube.com/watch?v=3iZrMkZ3948 Pre-requisites Download and install (latest version 2020.1.2 onwards). It is free of charge with full functionality. The only snag is that any work done can only be published on the Tableau Public server, and not saved locally to your Desktop. This is alright if the data is not sensitive or private. Tableau Public Download the latest (in *.xlsx format) from the European Centre for Disease Prevention and Control , and rename it using a generic filename “COVID-19-geographic-distribution-worldwide.xlsx”. You can replace this file with the updated data later, using the same filename. COVID-19 data website Open the Tableau Public app, and connect to the downloaded data file (click on “Microsoft Excel”). Click on the “Sheet 1” tab at the bottom left. Identify the Quantity to Race There are 2 useful quantities you can choose to race in this dataset: Daily Infected Cases, or Daily Deaths Cases. To choose the race quantity as daily infected cases: Drag “Cases” to Columns. To label the bar chart with country names: Drag “Countries And Territories” to Label. To have the bars in various colours: Drag “Countries And Territories” to Colour. Create Rank for Countries This section requires a simple programming line of code. Click on Dimensions → drop-down menu → Create Calculated Field. Create a new field “Rank”, and key in the code below. RANK_UNIQUE(Sum([Cases])) Click on “Apply” to ensure that calculation is valid, then click “OK”. Drag “Rank” to Rows. Click on (Rows) Rank → drop down menu → Discrete. Click on (Rows) Rank → drop down menu → Compute Using → “Countries And Territories”. Configure Animation (New Feature for Ver 2020.1) To create a snapshot of animation frames: Drag “Date Rep” to Pages. Click on (Pages) Date Rep → drop down menu → Exact Date. Turn on animations: Format → Animations → On. To set the transition duration: Duration → “1.00 seconds (Slow)”. Close Animations window by clicking “X”. Look for a little Animations control which appeared when the animations feature is turned on, and click the “forward play” icon. Drag the slider bar to a different date or use the left/right button to choose a date. Add Simple Customisation Click on Label → ensure “Show mark labels” is checked. Click on Colour → Edit Colours -> replace similar colours if any. (I have replaced the colours for USA, Spain, Italy) Hide the Countries legend card, no need for it anymore. 1. To improve colours: Drag “Cases” to Label. Click on Label → Text → click on “3 dots”. This opens up the label editor. Arrange labels to 1 line only. Underline <Countries And Territories>. Bold <SUM(Cases)>, and use red font. Click on “OK”. 2. To add additional labels for the number of cases to the bars: Double-click on “Sheet 1”, and change it to “COVIT-19 Daily Infected Cases”. 3. To change sheet name: Double-click on the X-axis, this brings up the Axis menu. Choose Range to be “Fixed”, Fixed start=0, Fixed end=40,000. 4. To change X-axis limits: Drag “Rank” to Filters → click on “OK”. Click on (Filters) Rank → drop down menu → Compute Using → “Countries And Territories” . Replace “206” with “15”, and click on “OK”. Change the Standard view to “Fit Height”. 5. To display only the top 15 countries: Click on Label → Font → drop down menu → change to font size “15”. 6. To increase label font size: Right-click on the empty chart area → Annotate → Area. This brings up the annotation editor. Key in <Page Name>, and increase font size to “20”. Click on “OK”. The date label is created. Resize and locate it at the bottom. 7. To add date label on chart: Publish Visualisation When you are satisfied with the customisation, the visualisation is then ready to be published. Click on File → Save to Tableau Public. The work is now . You can then share it using the available link. published on the Tableau Public server Here’s a video tutorial with step-by-step guide for the entire process: Let your creativity flow!

Flow

Microsoft

YouTube

How to Classify Animal Images via a Convolutional Neural Network

How to Build a Bar Chart Race on COVID-19 Cases in 5 Minutes

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Applying Agile Framework To Data Science Projects [A How-To Guide]

100 Stories To Learn About Remote

10 Non-Influencers redefining Influence. Opportunity: $1 Million USD Funding to fight COVID-19

121 Stories To Learn About Coronavirus Impact On Business

278 Stories To Learn About Covid 19

196 Stories To Learn About Covid19

Applying Agile Framework To Data Science Projects [A How-To Guide]

100 Stories To Learn About Remote

10 Non-Influencers redefining Influence. Opportunity: $1 Million USD Funding to fight COVID-19

121 Stories To Learn About Coronavirus Impact On Business

278 Stories To Learn About Covid 19

196 Stories To Learn About Covid19

Light-Mode

Classic

Newspaper

Minty

Dark-Mode

Neon Noir

Minty

HN StartUps