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

[@codebasics]

If you want to learn data analytics using projects like this then check our data analyst BootCamp: codebasics.io/bootcamps/data-analytics-bootcamp-with-practical-job-assistance

[@soumyabratanandi3943]

sir , i know basic pyton and pandas and some of power bi working tools but i am not able to make a data analytics project . can you please help me to step wise process for make a project

[@valarmathijeyaraj886]

I want to do internship, what is the procedure, will you provide any certificate?

[@JaaOffendJaa]

codebasics23 not working now bright data code

[@sarthak2981]

can you create the video for Tableau as well

[@mustanserbillah9174]

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

[@AkashSingh-ud9fw]

You are so wrong my friend. Your view of technology is so little.

[@FalakSher-sh3vx]

Which application is he suing for json viewer?

[@RakeshSaineni]

Hot data analyst job?

[@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.

[@FalakSher-sh3vx]

Which application is he suing for json viewer?

[@sankaragamer]

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

[@sahilsingrajput8834]

please help me . i am not getting credits in brightdata account

[@reyanshjain2928]

he says to click on "collector" but I am not finding that thing , can some one pls help me

[@rogelioespinosa8079]

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 :) 🎉

[@RakeshSaineni]

Got any job in data side?

[@mzeeshans58]

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

[@sharad3877]

Hi, did you complete the project, I needed some help

[@Bharat-v2j4n]

@@sharad3877 I found this project to be quite disappointing. It felt more like a brand promotion than a comprehensive tutorial. The instructor didn't complete the web scraping section and only covered half of the data preprocessing. The most frustrating part was the incomplete Power BI segment. While the instructor may be skilled in their field, this course lacks the thorough guidance necessary for teaching.

[@evan9536]

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!

[@codebasics]

👍👍👍

[@sahilsingrajput8834]

please help me . i am not getting credits in brightdata account

[@rajajain7319]

bro synopsis hai kyaa iski tmhare pass.

[@fahadsyed8628]

Hi Evan Even I'm pretty much in the same situation as yourself currently. I'm studying Masters in Applied Data Science & right now I have semester break going on during which I decided to work on a few data analytics projects. I'm just curious to know which exact dataset of American football you used instead of cricket for your project. Can you share the link of the dataset here? Thanks

[@abhisheksharmahappyyouabhi487]

Hy bro please help me regarding this project...

[@amarchanotiya5558]

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. 🙏

[@sahilsingrajput8834]

please help me . i am not getting credits in brightdata account

[@Swarup_1996]

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.

[@RakeshSaineni]

Hi swarup, Got job as analyst?

[@SKAMRANPASHA]

The Pulp Fiction Font is Spot ON!

[@rommel23nb]

Impressed by great command you have on all this coding work and data analyses--- Trying to be on your footsteps

[@codebasics]

Glad you liked it and I wish you all the best for your journey

[@rehanahmad6699]

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.

[@Rs-vi6uh]

Did u get the job ?

[@FalakSher-sh3vx]

Which application is he suing for json viewer?Which application is he suing for json viewer?

[@RakeshSaineni]

@@rehanahmad6699 got any job?

[@DylanOkyere]

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

[@fahadansari9514]

i just wanted to submit my final year project and I was not getting anything related to data science. but now its seem this is the best video for creating a project. thank you so much it really means a lot😍😍😄

[@aryangupttaa]

Hey even I am working on college project can you please help me in making this project? pleaseeeee

[@vaibhavpandey1789]

@@aryangupttaa same bro i need some help

[@ARULJERALDJ]

@@aryangupttaa hii

[@vrindakunj]

He only promotes his paid content.. 😅

[@pillu6743]

Did you complete the project bro?

[@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.

[@khushbuahuja1199]

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.

[@keyurpatel7373]

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.

[@codebasics]

You are most welcome

[@kondibaabhange]

@@codebasicsvery usefull vidio sir please make vidio on how to make HLD and LLD Documents for the project....

[@RakeshSaineni]

Got any job brother?

[@technoseinen]

If u lose, u join as intern . Me as alien:- YESS!

[@reaalbakchod]

haha

[@vamsi9209]

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

[@ApniDuniya_25]

I am going to take the course from my next salary , your teaching is just amazing ...... I tried lots of courses and gained about 20 to 30% but even after completing your half video I gained around 100% .... Thanks a lot U're a Hero Sir !!!!

[@Marcel-f1]

Just discovered this amazing channel

[@wongsimon2387]

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

[@roshanjitmahanta6946]

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!

[@princekha4540]

Have been waiting for this since the announcement 🤩

[@georgekabbazi1837]

I guess Christmas comes early for me 😄 the topic i was studying about in front of me as a project

[@blessythomas7721]

That is a fantastic tutorial and just perfect for us to be creative yet have guidance throughout the project! Thank you!

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@HarshitSingh-qm3oe]

@@mylearners1122 where are you able to get the crawler. i am unable to see that in the scrapping website

[@shakespearea6500]

Hi where can I get alternative for bright data it doesn't work though I used their link

[@HarshitSingh-qm3oe]

@@shakespearea6500 it did not work for me as well

[@RestartUPSC2026]

What a unique way of introducing the scenario sir... You are awesome 👍

[@banumathirajendran5203]

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..

[@codebasics]

You are most welcome

[@Ailearning879]

kzbin.info/www/bejne/kJywhJucl5Vlac0 (End to End ML project - California house price prediction 📈📊💰📈📈📉

[@ThalapathyMaster]

Salute to Codebasics

[@shaidzaman3339]

wow...do this type of vidoes more please....learned a lot today

[@RakeshSaineni]

Got job?

[@IRFANAHAMEDESSA-MSCDS]

Thank you very much code basics 😊.excellent visualization and i learned lot of things in videos, salute sir.!

[@AliTaimoor-s1l]

I think you should use the no of matches to calculate the Super12/Super4, SemiFinal and Semi FInal, by the no of teams and one-to-one matches it would be more genereric and can process multiple data sets

[@AkshayKumar-iz2kd]

Thank you is a small word . Love you sir. Definitely try paid course as well

[@daoudhussain979]

Ahhhh man!! That made me soo interested in Data Analytics field. Hats off!!

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@datascienceworld]

Wow...This is what I neded..Thanks a bunch Sir😇😇

[@haridasjagtap5623]

This project is incredible! Kudos

[@thepenthusiast]

Edit: I had a question but after watching further I got it haha Thank you and Love your videos they are very helpful and informative! :)

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@vickyfoodpoint]

1:08:29 good teaching skills congratulations 🎉🎉🎉

[@kumarraj2012]

“If you lose, join me as an intern..” perfect..! 😂😂❤

[@izainonline]

Many Thanks wanted such like a video which requires data scrapping

[@amanpandey5673]

best learning and fun video on youtube

[@codebasics]

👍👍

[@hrithikwins]

You're nailing it in the right spot

[@dipeshshah502]

It's an amazing project. thank you team.

[@poorvamahto3025]

Hi I am not able to find the dataset, kindly help

[@swapnilpharate146]

tony sharma is gr8, salute to nick Puri

[@codebasics]

😇😇👍

[@pratikchaudhari2631]

Plz make more videos like this and cover projects on different Modules

[@RakeshSaineni]

Got any job bro?

[@darshanapawar399]

It's so so much amazing explanation of project I have watched ever.. Please sir make such more projects !!! I just Loved it :) thanks for making such a Great Video !!! 😊🙌🙌

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@CodingBrainTeaser]

loved the intro

[@rahulp3337]

The match details data is getting scraped correctly, but for batting_summary I am not able to get team 1 and team 2. Rest all data is coming. So, the match and teamInnings is coming blank.

[@shreepadkadam8768]

Nice to meet you BROGU. 😂😂😂

[@ishitachakraborty1362]

Thank you so much for this.Can you please take a session on supplier segmentation based on risk factor of the suppliers

[@sharad3877]

Hi, did you complete the project, I need some help

[@GoogleAccount-p7g1m]

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.

[@bhumeetsolanky138]

Right

[@georgejetson9801]

Obviously this isn't for beginners. Study the individual parts of data analysis first.

[@rajangupta569]

Hello, sir How to add json file in bright data

[@poorvamahto3025]

Hi , i am not able to get the data from bright data , kindly help

[@Bharat-v2j4n]

I found this project to be quite disappointing. It felt more like a brand promotion than a comprehensive tutorial. The instructor didn't complete the web scraping section and only covered half of the data preprocessing. The most frustrating part was the incomplete Power BI segment. While the instructor may be skilled in their field, this course lacks the thorough guidance necessary for teaching.

[@whysid]

Great!! Keep bringing more.

[@harshitkedia2204]

Sir thanks for your handwork for building this educative video, please make tutorials explaining the data scraping part, especially the complex one.

[@codebasics]

Ok I will try

[@hesammohammadi6969]

Thank you CodeBasics🌸🌸

[@pranavanand24]

Fantastic video, but with all due respect, many agree that Virat Kohli is out of this world, i.e. An Alien

[@hemanandvadivel8151]

Exactly the reason he would captain this team.

[@ADodo-f4w]

Excellent video sir, Your videos always help us learn new concepts very easily, I have one suggestion, you should decrease your drama percentage and try to come on the point straightforwardly.

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@dipalikhatua4978]

The Game Changer Tutorial. Thanks a lot sir ..

[@mylearners1122]

i need help!, i'm not capturing all the rows getting just highlighted rows(first 9s), please help me how to get all rows

[@TusharValmiki-g3z]

what a man this is !!!

[@adsonnet]

The intro was awesome 😅

[@sachinmore8938]

Awesome Start :D

[@mahaprasadacharjee5482]

Dhaval Sir can you please make a separate video on how to collect data in Bright Data's new version? Please!

[@ffmp40army99]

brother i didn't find the given link could you don't mind send the files link brother

[@anshtandon1594]

+1

[@naveensarathinawin863]

I am also having the same problem :(

[@ajayrawtani5321]

just a min worth of useful stuff

[@Nnemka]

i really appreciate being put on to maximum! that song is a jam!

[@saptarshigoswami2748]

hello sir, can you please explain me the reason for making the 'custom batting order' calculated field prior analysing data.

[@parvezshaikh9712]

we want more contents like this sir

[@computerpillar8285]

But I have bee waiting to see the game and how they play, with an opponent, thank you they way you provide the tutorial is amazing

[@GowthamRajaS]

i got some new ideas to try out now thanks for the video.

[@OmkarWalunj108]

Where are the additional files like dashboard_screenrecording???

[@perfectionist6624]

Thanks Need more videos like this

[@codebasics]

Sure, I will be building more of these type of projects in the future. Stay tuned!

[@celinesyriac6199]

I am not able to download the files from the resources. It shows some error called access denied.

[@HarishKumar-lg1ti]

I am trying to enhance my skills in data analyst field. For the same , I want to have live classes. Can you please let me know if you provide the live classes??

[@tech-n-data]

So excited!!!

[@kalil4495]

Sir need a dataset for the project plz share the link 🔗

[@bhanu8241]

there is no data collector option while i am doing the project could some one help me

[@andrejohnv]

did you get it?

[@mayankkori1390]

Showing access denied for the dashboard building screen record while downloading .

[@ajithkumaar3473]

Where can i get the data collection files? The interface is completely changed. I dont see " My scrapers " option available. Kindly please help

[@andrejohnv]

did you get it?

[@RakeshSaineni]

Got any job?

[@ArchanaRithika]

data collector option is not there in my pc, where data collector option

[@andrejohnv]

did you get it?

[@AyushmanRath-yk1fp]

SIr, the screen recordings while making the Dashboard aren't available. Please provide us with that, so that we could watch, learn and create our own ideas.

[@adnansattikar3113]

I am not getting the 15$ balance after signing up from the link below. Did anyone else face the same problem ? If yes please help me find a solution for ir

[@ShivamDeora-rm7em]

Same, any solution?

[@bhaskart488]

@@ShivamDeora-rm7em same here

[@bhaskart488]

can I continue with the tutorial or will it create a problem to move forward without the credits?

[@anikajahanchoudhury8754]

same here

[@tiger21823]

Love fromPak Sir ur videos have helped me grow in my career pretty quickly

[@MsChintox]

Sir the web scrapping code is giving error, can you please help to rectify

[@wealthcreation4657]

Please keep uploading real life projects on weekly basis. Thanks in advanced

[@adityaroychowdhury5084]

I have signed up accordingly in bright data but didnt received 15$ balance as promised.

[@sucreation1154]

same with me tried multiple account

[@blazemates]

@@sucreation1154 SAME

[@254vineetpingale9]

you did everything great we followed your each step. we couldnt build the raw visuals and also the final pbix file doesnt have images of players .

[@Boxer9147]

SIR CAN'T FIND THE DAX CALCULATED SHEET IN DESCRIPTION

[@fawwazkhan7380]

Sir I am not able to find your resources dataset

[@reyanshjain2928]

he says to click on "collector" but I am not finding that thing , can some one pls help me

[@anshtandon1594]

same

[@kaushiksanghani9205]

This is pretty amazing.

[@ektasharma9716]

Can anyone help me with creating data collector because I added all the code given in the web scrapping code but it is not collecting anything and also there is no input files been extracting from that link??

[@ravibansal6675]

I am facing same issue. I tried changing name of table elements. Still not working.

[@anushridubey3469]

What's that free website you named before to contribute to data science projects across the globe?

[@rithishragav4928]

HI Sir at present is bright data giving credit sir ? for codebasic students ?

[@AkashSharma-zb8bv]

Sir, the way you explain the concepts is fabulous and the learner like me who is willing to a pursue a career in Data Science(Sports Analytics) is indebted for your contribution. The clarity and depth you bring to your tutorial is truly appreciated. However Sir there can be possibility where the teams have faced each other in the group stage as well as in the knock outs then making the match_ids dictionary like this would result into erroneous data just like in T20 world cup 2007 where India had faced Pakistan twice. There needs some additional key which is unique for both. For the above scenario it would work fine...

[@vikrantbahadur8242]

did you find the further dashboard creation that he is been claiming you will find it in description coz I'm unable to same like his hospitality video

[@AkashSharma-zb8bv]

@@vikrantbahadur8242 Sorry Vikrant Bhai... I didn't get what you are trying to say... Can you please elaborate little further...

[@parthbihani7360]

I am unable to load the data into the jupyter notebook can you tell me how you loaded?

[@deepakvanapalli557]

The webscraping part is not working now , what to do?????????

[@harshithharsha4066]

Data collector is not showing in bright data

[@vaibhavjain1740]

did you find it?

[@andrejohnv]

did you get it?

[@SiddharthChauhan-pf8gj]

where i can get the data to work on power bi

[@faizahmed8015]

Thank You, Sir, *Sir please teach us how to make HLD and LLD documents for Project.*

[@pranavsorte5658]

The coupon is not working anymore it seems, I registered using 2 accounts but not getting $15 in my account

[@tashrifchowdhury8594]

power query so much easier than regex, but I feel like regex may give more freedom in extreme cases. I am still some what new to the field and have only really dealt with clean data.

[@prensudangol1547]

cricket is incomplete without king kolhi ! In any universe if there is cricket then the talk of the town is kolhi !

[@saikatdasgupta9936]

Very innovative ❤😊