Cricket Data Analytics and Visualization
In this project, a Power BI Dashboard was developed to analyze and compare the performances of all players participating in the ICC T20 Men's Cricket World Cup 2024. The dashboard provides an interactive platform to evaluate player performances and facilitates the selection of the best 11 players of the tournament, based on specific performance criteria outlined in the problem statement.
Web Scrapped all the data from ESPN WorldCup 2024 using python and jupyter notebook
You can check webscrapping code HERE
Scrapped all the data regarding match and world cup and all details about players career using Beautiful Soup library and Jupyter Notebook is used to convert the json files into the dataframes and then these dataframes into csv file for further data analysis on power bi.
Performed initial data cleaning after scrapping such as player name correction, handle missing value, match id linking etc. using Pandas. Transformed the final data for dashboard using Power Query of Power BI.
Connected all the datasets with based on some defined primary keys such as team and match ids. Also, created many measures, calculated columns and parameters for data analysis and dash boarding using DAX.
Data visualization for the dataset was done using Microsoft Power BI Desktop:
1.Jupyter Notebook
2.Python
3.Pandas
4.Webscraping
5.Beautifual Soup
6.Power Query Editor
7.Power BI
8.Excel