Skip to content

Conducted a comprehensive data visualization analysis using PowerBI on IPL data to determine the optimal candidate for the Impact Player role. This analysis focuses on evaluating various match situations to identify which player, among the potential impact players, is most likely to create a significant impact when needed.

Notifications You must be signed in to change notification settings

Chaitanya-0310/Impact-player-analysis

 
 

Repository files navigation

Impact Player Analysis

Introduction

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.

Quick Start

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

Why this Project ?

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.

Project Setup for potential contributors

  1. Install PostgreSQL, PowerBI and Python
  2. Create a virutal environment virutalenv env
  3. Activate virtual environment env\Scripts\activate for windows and env/bin/activate for linux/MAC.
  4. pip install -r requirements.txt
  5. Make a database.ini file with credentials for PostgreSQL as formatted in sample_database.ini
  6. Run load_data.py to load data from /Data/*.csv files to PostgreSQL.
  7. Setup ODBC for PostgreSQL
  8. 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.

Implementation Details

Below Diagram shows the architecture of techology stack.

Tech Stack

Data Visualization samples -

Analysis for Impact Player (Batsmen) Screenshot 2024-07-28 180655

Analysis for Impact Player (Bowler) Screenshot 2024-07-28 180816

Analysis of Player according to Matches Screenshot 2024-07-28 181218

Dataset used: Kaggle

Read Research Paper.docx for more details.

Contact Us

  1. Tanmay Damle - LinkedIn, GitHub

  2. Chaitanya Panchal - LinkedIn, GitHub

  3. Smit Patel - GitHub

  4. Shivam Dalsaniya - LinkedIn, GitHub

About

Conducted a comprehensive data visualization analysis using PowerBI on IPL data to determine the optimal candidate for the Impact Player role. This analysis focuses on evaluating various match situations to identify which player, among the potential impact players, is most likely to create a significant impact when needed.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%