347 647 9001+1 714 797 8196Request a Call
Call Me

Visualizing Cricket Data with Tableau

April 2, 2015
, , ,

What a professional performance by team Australia in CWC 2015! The CWC 2015 has ended but we are going to start our Visualizing Data with Tableau blog series with Cricket. For most of the Indians, Cricket is very close to their heart. In this blog, we will use data to answer a few interesting questions about Cricket with the help of Tableau.


The data has been sourced from and formatted appropriately for Tableau’s consumption. This is the first important and often time-consuming step before data visualization and exploration can take place. We have batting data for One Day International (ODI) matches played between years 1971 to 2011 which is close to 60,000 data points. The below table gives you a quick overview of important dimensions and measures present in the dataset.





Player name

Score Rate (runs per 100 balls faced)

Opponent country




Match Date


Data Exploration & Visualization

It is always a good idea to ask questions that you are interested in finding out answers of for using data. It helps in structuring the thoughts and often leads to interesting visualizations uncovering patterns or insights previously hidden. Let us begin.

Who among the Indian batsmen have scored runs at a faster rate?

Tree Map showing Indian batsman’s strikerate

The above Tree map is generated for Indian ODI players who have scored more than 2,000 runs. Size of the block represents total number of runs scored and colour depicts the strike rate. The more Greener the block, faster the player scores his runs. One can easily conclude that Sehwag, followed by Dhoni, Kapil Dev and Raina are the fastest in scoring runs and Sunil Gavaskar, Sidhu and Laxman have scored their runs at a slower pace as compared to others.

On which grounds bulk of the runs are scored?

Have you ever wondered on which grounds most of runs are scored? The below simple bar chart shows the top five grounds by runs scored. Incidentally, these are also top five grounds by number of matches played which is somewhat intuitive.

top 5 grounds where maximum runs are scored

Which players have scored most number of ducks?

data showing the list of players that scored maximum ducks

Murlitharan has scored most number of ducks (41) interestingly followed by Jayasuriya with 34 ducks and McGrath and Wasim Akram with 32 each and Vaas with 30. Again four out of top five are bowlers, which is quite understandable. What is Jayawardane doing at sixth position with 26 ducks?

How do Indian batsmen score and what rate on a given day?

Is there a correlation between day of the match and runs scored and rate at which they are scored? The below graphic shows the average runs scored and average strike rate of Indian players post 2000. It seems like Wednesdays and Fridays are not so good face_image for Indian players both in terms of average runs scored and average strike rate.

Daywise performance of Indian players

How do players compare in terms of average and strike rate?

Below is a scatter plot depicting average runs scored and average strike rate for all the players who have played more than 50 ODIs. The players in top right quadrant are the ones who score fastest as well as more per match as compared to others. One can see that Afridi is the fastest when it comes to score rate but averaging a meagre 20 runs per match whereas Tendulkar, Amla. Hussey, De Villiers score more and faster as well.

comparison of average and strike rate

This is just the beginning stay tuned for more exciting visualizations and learning with Tableau until then happy data visualization.

About Tableau

Tableau (NYSE:DATA) headquartered in Seattle, Washington has a mission to help people see and understand data. It offers a product portfolio for data visualization focused on business intelligence.

One can visit the official Tableau website to find more details about Tableau and its product offering and features.


About the Author

Pranay Vasani from Mumbai is passionate about Data Visualization and Data Science. He works as a Senior Business Analyst in Business Intelligence and Pricing domain. He is a guest faculty for teaching Data Visualization with Tableau and a guest blogger at Edupristine.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 73730