Data Analysis and Insights | MySQL - SampathVSS/DataAnalysis-IPL-Datasets-2008-to-2017 GitHub Wiki

The IPL data analysis reveals several key insights across various aspects of the tournament:

  • Each IPL season averages 63 matches, although there are notable variations in tournament duration over the years. The period from 2011 to 2013 stands out for its longer duration compared to the average, indicating potential shifts in scheduling or tournament structure during those years.
  • Major stadiums such as Chinnaswamy (Bangalore), Eden (Kolkata), and Wankhede (Mumbai) significantly contribute to match numbers, showcasing their importance as hosts.
  • During the seasons from 2011 to 2013, there was a substantial increase in matches per team per stadium, leading to extended tournament durations. Home stadiums are predominant venues for most teams, indicating a potential advantage for teams playing in familiar environments.
  • Indian players form the majority of IPL participants, followed by Australian players, with other nationalities making up the rest. Notably, teams like Hyderabad, Pune, and Gujarat have a higher percentage of foreign players.
  • Batting trends have evolved over the years, with explosive phases characterized by increased boundaries observed from 2011 to 2013. Post-2014, there has been a general increase in overall strike rates.
  • Stadiums like Chinnaswamy (Bangalore), Feroz Shah (Delhi), and Eden (Kolkata) witnessed the highest number of boundaries during the analyzed period.
  • Mumbai Indians excel in bowling, leading in total bowled counts and recording the highest number of dot balls, demonstrating their bowling prowess. Additionally, Mumbai tops the rankings in total runs scored, half-centuries, and boundaries hit, showcasing their all-round performance.
  • Rankings based on player performance highlight a mix of foreign and domestic players in the top 10, emphasizing the IPL's diverse talent pool. Foreign players also feature prominently in the rankings for centuries scored, indicating their significant contributions to IPL matches. Overall, these insights offer a comprehensive understanding of IPL dynamics, encompassing match statistics, player performances, and demographic trends.

1. Quick Insights

1.1 Number of Matches conducted in each year and the period of the tournament

image

Annexure of the Process

  • Each tournament averaged 63 matches.
  • The period spanning from 2011 to 2013 stands out as notably longer compared to the average.

1.2 Number of matches conducted in each year and in each stadium

image

Annexure of the Process

  • The stadiums contributing the most to match numbers are Chinnaswamy (Bangalore), Eden (Kolkata), Feroz Shah (Delhi), Wankhede (Mumbai), and Chepauk (Chennai).

1.3 Number of matches played by each team in each year in each stadium

image

  • Notably, the period from 2011 to 2013 saw a significant increase in matches per team per stadium, extending those tournaments.

image

  • Home stadiums saw the majority of matches for most teams.

Annexure of the Process

1.4 Demographics of the Players

Over the entire dataset, around 55% of players were Indian, followed by Australian players, with players from various other countries making up the rest.

image

  • Percentage of foreign players in each team and in each season
  • Notably, Hyderabad, Pune, and Gujarat had more foreign players compared to other teams, while others had around 3% to 4% foreign players.

image

  • Country wise participation in the entire period. After India, Austraila and South African players were given importance in the squad

Annexure of the Process

2. Key Performance Metrics

2.1 Tournament wise Key Metrics

image

  • Metrics such as total runs, balls faced, average strike rate, sixes, fours, 50s, and 100s were analyzed.
  • The seasons from 2011 to 2013 were marked by explosive batting with increased boundaries, while the overall strike rate increased post-2014.
  • The 2016 season saw the highest number of sixes, centuries, and half-centuries.
  • The period from 2011 to 2013 witnessed the highest number of dot balls bowled, coinciding with the highest number of sixes.
  • The 2013 season recorded the most wickets taken by bowled.

Annexure of the Process

2.2 Venue wise Key Metrics

image

  • Chinnaswamy Stadium (Bangalore), Feroz Shah Stadium (Delhi), Eden (Kolkata), Wankhede (Mumbai), and Chepauk (Chennai) witnessed the maximum boundaries during the data period.

2.3 Team wise Key Metrics

image

  • Rankings based on total runs scored showed Mumbai with the most half-centuries, while Bangalore had the most centuries and Mumbai had the most boundaries overall.

image

  • Mumbai Indians led in total bowled counts and also recorded the highest number of dot balls.

2.4 Player wise Key Metrics

image

  • Rankings based on total runs scored saw a mix of foreign and domestic players in the top 10.

image

  • Rankings based on highest strike rates.

image

  • Rankings based on centuries scored, with foreign players prominent in the top positions.

image

  • Rankings based on total bowled counts.

image

image

  • The majority of the performance is drawn from Australia and South African players apart from the domestic players.

3. Analysis

3.1 Chasing Vs Defending

image

  • Rajasthan Royals, Chennai Super Kings and Kolkata Knight Riders has the teams with higher winning percentage.

image

Filtering the teams which has win percentage more than 50%

  • Chennai Super Kings, Rajasthan Royals and Delhi Daredevils has won most of their matches by chasing which shows the team's batting lineup.
  • Where as Royal Challengers Bangalore, Kings XI Punjab and Mumbai Indians has won most of their matches by defending.

3.2 Most Consistent Player in each team by their contribution

image

  • The contribution was calculated by deriving each player's individual runs scored against the target.
  • In the final output table, the average of the contribution parameter was considered, and the ranking was allotted based on that.

image

  • Only the above teams having the domestic players in their consistent players list.
  • The dominance of foreign players were prominent in other teams by their consistent performance.

image

  • Like said earlier, majority of the performance was drawn from Australian and South African Players.
  • In Majority of the teams, they hold rank = 1 in terms of their consistence performance in each match.