Introduction
Indian Premire League Dataset (GTD) contains the match descriptions, results, winners, player of the matches, ball by ball dataset and much more from the year 2008-2019.
This dataset consists of two seperate CSV files : matches and deliveries. These files contain the information of each match summary and ball by ball details, respectively.
Problem Statement
Our goal is to Perform ‘Exploratory Data Analysis’ on this dataset and As a Sport Analyst, find out the most successful team and players.
And Suggest teams or players a company should endorse for its products.
Solution
After loading the dataset in spreadsheet, I have done cleaning and preprocessing by combining both the dataset and change the team names for inconsistency, removing team which are not part of the IPL franchies,null columns and irrelevant data then moved to the Exploratory Data Analysis (EDA) Part using tableau
In EDA, I have analyzed the succesful team, man of the match, top 10 batsman and bolwers and team performance by seasons.
Cleaned Dataset
Visualization
Conclusion
After fully exploring the data, I have suggested below recommendations:
- Mumbai Indians (MI), Chennai Super Kings (CSK), and Kolkata Knight Riders (CSK) are most successful teams of the franchies.
- After 2010, MI showed great performance in the odd years, CSK has great performance throughout all the years.
- Chris Gayle, Ab de villiers and Rohit Sharma are the most important players in the IPL.
- Andre Russell , Sam Curran and Sunil Narine have scored highest run in the matches.
- Lasith Malinga, Amit Mishra and Harbhajan Singh have taken most number of wickets.
Recommendations
The Sport Aanalyst should/can -
- take into top priority these three teams - MI, CSK & KKR while going for product endorsements.
- consider Chris Gayle, Ab de villiers and Rohit Sharma for most successful ad campaign.
- consider Andre Russell , Sam Curran and Sunil Narine while endorsing any batsman product or ad related to them like product stickers in the bat.
- consider Lasith Malinga, Amit Mishra and Harbhajan Singh for any adverstise related to bowling or fielding products.
Next Steps
Sport or marketing Analyst should take a look into the Women’s cricket to find out players which will increase their product sales.