The IPL, or Indian Premier League, is a professional Twenty20 cricket league in India. Founded by the Board of Control for Cricket in India (BCCI) in 2007, it has since become one of the most popular and lucrative cricket leagues globally. The league features franchise teams representing various cities in India and has attracted top cricket players worldwide. Typically held annually during the Indian summer, from March to May, the IPL enjoys a significant following both in India and internationally. For this project the data was taken for the period of 2008 to 2017 (Source File : https://data.world/mkhuzaima/ipl-data-till-2017)
Tools Used: MySQL
The dataset comprises five primary categories:
Teams: Details of participating teams
Players: Information on players affiliated with each team, including demographic data
Matches: Key summaries of individual matches and their outcomes
Player_Match: Roster of players for each match along with their performance summaries
Ball_by_Ball: Granular data at the ball level
Analytical Queries Link to Wiki Page
- Quick Insights
1.1 Number of Matches conducted in each year and the period of the tournament
1.2 Number of matches conducted in each year and in each stadium
1.3 Number of matches played by each team in each year in each stadium
1.4 Demographics of the Players - Key Performance Metrics
2.1 Tournament wise Key Metrics
2.2 Venue wise Key Metrics
2.3 Team wise Key Metrics
2.4 Player wise Key Metrics
Annexures
All the detailed MySQL queries used to create the desired outputs were documented in the Annexures tab in the Wiki Page.
This analysis provides comprehensive insights into various aspects of IPL cricket, including match statistics, team and player performance, and demographic trends over the years.