This project is about find the best combination squad for T20 World Cup
-
Batting Info Table :- This table contains batting data for players who played in matches between 2020 to 2022. This table contain data for runs, balls, fours, sixes, strike rate etc for every batsmen played.
-
Bowling Info table :- This table contains bowling data for players who played in matches between 2020 to 2022. This table contain data for overs, runs, maidens, wickets, economy etc for every bowler played.
-
Bowling Info table :- This table contains bowling data for players who played in matches between 2020 to 2022. This table contain data for overs, runs, maidens, wickets, economy etc for every bowler played.
-
Player Info table :- This table contain player information which contains Team, batting style, bowling style playing role, image and description of the player
-
Match Info table :- This table contain match information which is team names, winner, margin, ground and Date.
-
Collection of Data from ESPN CricInfo Website for T20 Matches held between 2020 to 2022.
-
Performing Data Cleaning such as Removing the NULL values and unwanted data.
-
Adding the columns such as Stage column in Matches Table for dividing data in Group Stage and World Cup Matches then boundary runs in Batting and bowling Info Table.
-
Creating Measures for Total Runs, Total Innings, Batting Average, Bowling Average, Overall Strike Rate, Total bowls faced, Average Batting Position, Boundary%, Total Wickets, Total Runs Conceded, Bowling Economy, Bowling Strike Rate, Bowling Average.
SUM(), COUNT(), AVERAGE(), DIVIDE(), ROUND(), DISTINCTCOUNT(), ISFILTERED(), IF()
-
Playing 11
- Should be able to score 180 runs in an innings and be able to defend 150 runs on an Average.
-
Openers Criteria:-
- Should have batting average above 30
- Strike Rate should be greater than 140
- Total Innings batted should be greater than 3
- Boundary percentage should be greater than 50%
- Average Batting Position should be less than 4
-
Anchors/ Middle Orders:-
- Should have batting average above 40
- Strike Rate should be greater than 125
- Total Innings batted should be greater than 3
- Average Balls Faced should be greater than 20
- Average Batting Position should be greater than 2
-
Finishers:-
- Should have batting average above 25
- Strike Rate should be greater than 130
- Total Innings batted should be greater than 3
- Average Balls Faced should be greater than 12
- Average Batting Position should be greater than 4
- Innings Bowled is greater than 1
-
Allrounders:-
- Should have batting average above 15
- Strike Rate should be greater than 140
- Total Innings batted should be greater than 2
- Average Batting Position should be greater than 4
- Innings Bowled is greater than 2
- Bowling Economy should be less than 7
- Bowling Strike Rate should be less than 20
-
Specialist Fast Bowlers:-
- Innings Bowled should be greater than 4
- Bowling Economy should be less than 7
- Bowling Strike Rate should be less than 16
- Bowling Style of the Player should contain "FAST"
- Bowling Average should be less than 20
Tech: Python, PowerBI Desktop, PowerBI Service, Jupyter Notebook
Libraries: Request, BeautifulSoup, Pandas, DAX
Web Scrapping and Analysing data. Data transformation in power query. PowerBI Chart creation. Adding Measures using DAX Functions. Adding Filters and selecting Final 11.