End To End Cricket Data Analytics Project Using Web Scraping, Python, Pandas and Power BI

End-to-end sports data analytics project for your resume. In this project, we will cover web scraping (from the ESPN Cricinfo website), python, pandas, and Power BI to perform analyses on T20 world cup cricket data.

*Note* : The Bright Data interface has been updated as part of their product enhancement. To access the Datasets & Web Scraper IDE, please select the third icon from the left-side menu bar. Then, click on the *'My Scrapers'* option. There, you will find the collectors. From this point, you can proceed with the same process as shown in the video.

⭐️ Timestamps ⭐️
00:00:00 Overview
00:00:29 Problem statement
00:02:33 Requirement scoping
00:09:21 Data collection using web scraping (from ESPN Cricinfo website)
00:21:57 Data cleaning and transformation in Python Pandas
00:44:01 Data transformation in Power Query
00:56:52 Data modeling and building parameters using DAX
01:08:17 Build dashboard in Power BI
01:20:53 Collect insights from the dashboard and select the final 11 players
01:38:04 Challenge for you and prize

In this end-to-end data analytics project for beginners and advanced users, we have used cricket T20 world cup (2022) data to build insights on a best 11 players team that we can assemble from the earth that can go and play with aliens. We used bright data web scraping to collect data from espncricinfo website then we performed some data transformation and cleaning in pandas, followed by building dashboards in power bi. This is a solid data science resume project that will make your resume stand out in the competition. It is a fully guided data analytics project with all the materials included.

🔖Hashtags🔖

#cricketanalysispowerbi #cricketanalysispowerbiproject #powerbiproject #analysisproject #dataanalysisproject #cricketdataanalysispowerbi #dataanalysispowerbi #powerbidashboardproject #powerbidashboard #endtoendpowerbiproject #powerbiproject #powerbiprojects

#️⃣ Social Media #️⃣

[khushbuahuja]

00:04 Starting cricket data analytics project with T20 World Cup data
03:00 Selecting players based on specific parameters for different positions
06:48 Team aims to keep the defense under 150
08:57 Bright Data provides proxy networks and readymade datasets for seamless web scraping.
14:25 Utilizing Bright Data collector for seamless web scraping and data collection.
16:45 Collecting cricket data using web scraping and HTML knowledge
20:55 Creating collectors for web scraping data
23:00 Transforming Json file into CSV format for cricket data analysis.
27:27 Export data into CSV and process batting summary
29:49 Creating a single list in Pandas and data analysis
34:16 Using Pandas to preprocess cricket data
36:26 Creating a match ID dictionary for team combinations
41:26 Data extraction and table linking for CSV export
43:43 Importing CSV file into Power BI
48:13 Data cleaning and transformation using Power Query
50:22 Creating a conditional column called 'stage' based on match date
54:49 Performing data transformation for cricket analytics
57:24 Establishing relationships between tables and creating DAX measures for data visualization.
1:01:59 Check the accuracy of measures and create filters in Fact Batting Summary CSV file.
1:04:21 Create measures and group them into folders
1:08:37 Business managers provide rough mock-ups for dashboard
1:10:46 Using filter tab to identify potential power hitters
1:15:26 Beautifying and customizing visual dashboards in Power BI
1:17:15 Non-technical background to expertise in Power BI
1:21:57 Selecting Jos Buttler and Rilee Russouw as key players for batting strategy.
1:23:45 Selecting players based on statistics for performance analysis.
1:27:25 Selection of fast bowlers based on performance metrics
1:29:14 Key factors for team strength are balanced batting and good bowling
1:32:45 Choosing between Marcus Stoinis and Hardik Pandya for batting and bowling options
1:34:34 Selection of Marcus Stoinis in the final 11
1:38:34 Updating tooltip, visual design, and adding insights to the dashboard.
Crafted by Merlin AI.

[VidishArvind]

I really like the way you discuss about the specifics and problem statement of the projects...and that's the proper way to start building any project or app. Most of the creators I have seen directly jump to code or what the app does but not focusing on the purpose. Love your explaination.

[mustanserbillah]

CodeBasics is not just a channel its a complete university where a person can learn any technology.
Thanks Dhaval Sir

[AshwinKachu]

48:00 When removing duplicate names you should have considered country as well. Sometimes same name players can be in multiple nation especially with Pakistan and Afganistan.

[sankaragamer]

This video is insane it depicts the whole data process in the best way by explaining each single step!

[rogelioespinosa]

there is always an indian who will make it understandable for everybody lol
Thanks for this video and wish you a happy new year from Mexico :) 🎉

[amarchanotiya]

This is truly the Dataverse we all were waiting for...Truly a place to learn and enjoy the process too... Thank you Sir and the Codebasics team. 🙏

[evan]

This project was incredible! I'm currently doing my MS in Data Science and I have a two week break between semesters. I thought it would be a perfect time to do a project - and this guide was perfect. I just used American football data instead of cricket!

[keyurpatel]

I just want to thank you Dhaval Sir!! You are amazing. Best ever Data Analytics video I have ever seen and this shows your dedication and Hard work towards this Data Analytics community.
Lots of love from Bharuch, Gujarat Sir.
And thank you so much Sir I am going to participate in this challenge for sure.
Also thanks to Hemanand sir and Ashish Sir.

[DylanOkyere]

This is such a cool and fun video! Watched it through, can't wait to go through the project myself

[kaushalpawar]

Great walkthrough! Just a small observation—when assigning match IDs based on team combinations (Data Cleaning Part), keep in mind that in T20 World Cups, the same teams can face each other more than once (like in the group stage and then in the knockouts). In such cases, giving them the same match ID might not be accurate. Thought it was worth mentioning!

[rehanahmad]

I learned data analysis I am searching for a project and I think this is the best project to combine all my skills which I learned and also an attractive topic for analysis.

[remingtonrichmond]

This video got me thinking about new ways to scrape data for my projects. Maybe HasData could offer a different approach. What's everyone's go-to method for dealing with large datasets?,

[Swarup_]

This is fantastic video and best for resume as well. And not to forget at 2.04 min .. that shot of Virat Kohli to Haris Rauf .. Woow .. Excellent .. King Kohli at its best.

[mzeeshans]

After watching it completely my first word was Amazing video and explanation infinite likes for the work

[banumathirajendran]

Thank u so much sir for the wonderful session... You are really a great mentor.Code basics is the awesome channel for the data learners..

[vamsi]

What an innovative way of putting up requirements. Thanks for offering continuous learning

[wongsimon]

You are superb! The collecting insights part is especially compelling. Great!

[roshanjitmahanta]

best in the world for fun loving learning approach to teach, u are a revolution, dimaag hil gya tarika he project karne ka and educational video banane kaa. Thank you Codebasic Team!

[GoogleAccount-pgm]

i watched entire video. i am new to data analytics . u can consider me a fresher. to be frank ur first few steps of loading cricket data into bright dashboard. i didnt understand a single thing. you shoulg have atleast explained from scratch how to load the data. simply doing "go from here to here then this and then that " didnt make me understand a single thing.