Analyzing IPL Stats with Tableau — Part 1
“Tableau can play a big role when it comes to making sense of the data across all editions of Indian Premier League (IPL), which is a professional Twenty20 cricket league in India contested during March or April and May of every year by eight teams representing eight different cities in India.” — Definition by Wikipedia
Data Preparation
Kaggle has an exhaustive dataset covering IPL seasons 2008–2019 with granularity to the ball level. The dataset is comprised of two CSVs, one covers the match level detail while second covers the ball by ball level details, so a left join can give us the right view for reporting.
The whole visualization analyzes the league from four angles as shown in the diagram below, under separate dashboards, tied together with navigation buttons on top.
This is Part 1 of the article series covering IPL Analytics, and emphasizes on the first tab on IPL Season level overview.
KPIs in top section
There is a problem in dataset for the years 2018 and 2019, where the extra runs too are credited to batsman and summed in the “Batsman Runs” field. To bypass this, following adjustment has to be done in places where we are showing Runs as a metric.
If Season is less than or equal to 2017 then get Runs else get the difference of Runs and Extra Runs.
Summary Table
Summary Table gives an overview into the team standings in the selected season of IPL using the metrics described below.
Net Run Rate
Net Run rate is the last metric tabulated in Summary Table.
“Net Run Rate (NRR) is a statistical method used in analyzing teamwork and/or performance in cricket. It is the most commonly used method of ranking teams with equal points in limited overs league competitions, similar to goal difference in football.” — Definition by Wikipedia
Nested Sorting On Two Measures
The teams in Summary Table are sorted by two metrics, primarily on “Matches Won” and in case of clash, “Net Run Rate”. This Tableau kb article says more on this.
More on other tabs will be covered in the articles to come.