Cricket is the second most popular sport globally, having originated in England in the late 16th century. It is played in numerous countries, including India, Australia, Scotland, South Africa, England, Ireland,etc. The game consists of two innings, with each team taking turns to bowl and bat. The decision of which team bats first is determined by a coin toss. The team batting first sets a target score for the opposing team to chase within a set number of overs, which varies based on the format. Cricket is played in three major formats: Test matches (lasting five days), One Day Internationals (50 overs), and Twenty20 (20 overs). An over includes six balls.
In India, the Indian Premier League (IPL) is immensely popular and well-known internationally. It follows the Twenty20 format and features two teams of eleven players each, along with four to five substitutes.
With the introduction of the Impact Player rule last year(2023), teams can now list four/five substitutes at the toss and use any one of them as their Impact Player, adding a new tactical and strategic dimension to the game.
To See just the report, Clone this repository using below command
git clone https://github.com/damletanmay/Impact-player-analysis.git
Then, open Impact Player Analysis.pbix
to see the report
The insights and visualizations generated from this project aim to provide valuable support to coaches, enhancing their decision-making processes in the selection of Impact Player.
- Install PostgreSQL, PowerBI and Python
- Create a virutal environment
virutalenv env
- Activate virtual environment
env\Scripts\activate
for windows andenv/bin/activate
for linux/MAC. pip install -r requirements.txt
- Make a database.ini file with credentials for PostgreSQL as formatted in sample_database.ini
- Run
load_data.py
to load data from /Data/*.csv files to PostgreSQL. - Setup ODBC for PostgreSQL
- Open
Impact Player Analysis.pbix
and refresh data
Impact Player Analysis.pbix
report has lot of relationships build in the model view and measures are well-commented.
Below Diagram shows the architecture of techology stack.
Data Visualization samples -
Analysis for Impact Player (Batsmen)
Analysis for Impact Player (Bowler)
Analysis of Player according to Matches
Dataset used: Kaggle
Read Research Paper.docx for more details.