Created a Power BI Dashboard which helps to review and compare performances of all the players in tournament. The dashboard also enables us to select best eleven of the tournament based on their performance based on some selection criteria
app link: https://shivanshka.github.io/Cricket_Analytics
-
Scrapped all the data regarding match and world cup from www.espncricinfo.com and all details about players career from cricbuzz.com using Beautifull Soup library of Python.
-
Performed initial data cleaning after scrapping such as player name correction, match id linking etc. using Pandas. Then, transformed the final data for dashboard using Power Query of Power BI.
-
Connected all the datasets with based on some defined primary keys sucha s team and match ids. Also, created many measures, calculated columns and parameters for data analysis and dashboarding using DAX.
-
Craeted final dashboard using Power BI visuals.
- Python -> Beautiful Soup, Pandas
- Power BI -> Power Query, DAX