Power BI Project End to End | IPL Analysis (Part 2) | Dashboard | Beginners | Power BI Tutorial 2023

[@ranjithanand7445]

Cant thank you enough. Great job. More on data modeling, cleaning and processing. Kindly deep dive into different complex data cleaning and transformation techniques. Thank you.

[@aishwaryapattnaik3082]

An awesome project with very lucid explanation and with the optimum speed. High five ✋ . Please add more END to END SQL Server , Pandas and Power BI Projects.

[@datatutorials1]

Glad you liked it ✨ more projects incoming

[@RonakMishra62]

Sir relly very clear concepts and full informative video that's Great sir That's amazing video on KZbin for IPL Dashboard ❤

[@datatutorials1]

Glad you liked it ✨

[@hellolouis-xj6km]

Great Explanation and Easy way to learn. Thanks

[@datatutorials1]

Glad you liked it ✨

[@monikamanchanda1626]

VERY WELL EXPLAINED

[@anuragshrivastava7855]

amazing work for data comunity

[@risshirajsinghmathuria9050]

Thanks a lot for the detailed analysis, really helpful.

[@iboamah]

Thank you, great video. Well explained

[@datatutorials1]

Glad you liked it ✨

[@Nag-04]

Appreciate you work and keeping going do more projects and try to do more videos on after publishing the reports.. like workspace, my workspace, RLS and soo on which are used on real time ....Thank you soo much for your time....

[@datatutorials1]

Thanks, will do!

[@taizoondean689]

Thank You Sir....God Bless You

[@SachinSharma-qx6oh]

Such an awesome project work for any beginner in power BI. Can really vouch your work..Also a small request if you can make some videos on Dax particulary that will be a great help..

[@MrAjay87]

Thanks for elaborating in depth...can you please make a project with the macros involved in it ?

[@datatutorials1]

Yes sure

[@anjeetkumar1140]

Hi, First thanks for expanation and details. If i want to add the individual Teams innings runs or highest scorer team in a season , what measures i have to give. Like in a section if i select season 2018, it should give the team who secured highest runs

[@RintuRoy-s3e]

thank you so much

[@datatutorials1]

Glad you liked it ✨

[@Raaaajjjjj]

Thank u so much.... With ur help I created my 1st power bi dashboard 😊

[@datatutorials1]

Glad you liked it ✨

[@Raaaajjjjj]

@@datatutorials1 Sir, where can I get full data of ipl 2023 to add in this report ?

[@datatutorials1]

2023 data yet not generated

[@vishalachary6814]

awesome

[@bestahanumanthu5728]

Hi, First thanks for explanation and details as well explained sir

[@datatutorials1]

Glad you liked it ✨

[@aniketshinde4782]

This is really informative video, Sir! Thank you so much. I’m having a doubt at 30:12. While calculating Average by Bowler, we should have filtered out “dismisal_kind” as run out and hit wickets will not be counted. And same thing at 31:53 for calculating bowling strike rate.

[@Nag-04]

Yes i have observed the same thing...May be he forget... This is the Syntax.. Avg of Bowler =DIVIDE(SUMX(FILTER(ipl_ball_by_ball_2008_2022,ipl_ball_by_ball_2008_2022[extra_type]"legbyes"&&ipl_ball_by_ball_2008_2022[extra_type]"byes"),ipl_ball_by_ball_2008_2022[total_run]),SUMX(FILTER(ipl_ball_by_ball_2008_2022,ipl_ball_by_ball_2008_2022[dismisal_kind]"NA"&&ipl_ball_by_ball_2008_2022[dismisal_kind]"retired hurt"&&ipl_ball_by_ball_2008_2022[dismisal_kind]"retired out"&&ipl_ball_by_ball_2008_2022[dismisal_kind]"run out"&&ipl_ball_by_ball_2008_2022[dismisal_kind]"obstructing the field"),ipl_ball_by_ball_2008_2022[iswicket_delivery]))

[@tranthang2104]

i think so, too. Can you help me fix DAX expression for 2 above case ?

[@sanjayvashist6625]

sir in Average function - (aap ne calculate kiya Total_run / Wicket (527/29) = 18.17 but actual Average is Total_run / Wicket (527/27) = 19.52 Thank you sir 🙏

[@tranthang2104]

I also wonder the same as you. So have you solved that problem yet?

[@Burhanuddinawan]

please make a series on DAX from beginner to advance level

[@ambrishbiswas8569]

Hi, thanks for this amazing video explanation. When selecting the 2020 season it showed the title winner as Delhi Capitals, But the actual winner in 2020 was Mumbai Indians. Can you please suggest how to correct it?

[@SandipanSarkar-c8v]

Finished watching

[@kumarsahil9286]

thanks

[@GreenWorldhit]

tjank u

[@facelessedu]

QUESTION : when we calculate the strike rate of a batsman , why do we divide by the count of ball number ?? won't it count all the balls available in dataset rather than , count of balls faced by the particular batsman ???????

[@datatutorials1]

Divide by balls faced that batsman

[@GobindPrasad-dx8wc]

Thank you so Much... Please let me know how to show this dashboard to interviewer, I have free Powerbi version...

[@ramugandhi3500]

How can we get no. of centuries and half centuries made by player. Please suggest.

[@sourabhpatel3834]

For calculating average you need to consider dismisal type also

[@datatutorials1]

Yes, I guess that is considered

[@sourabhpatel3834]

@@datatutorials1 no i think you have not

[@datatutorials1]

@sourabhpatel3834 well I might have missed, you can add from your side

[@Eeshika.damaraju]

Hi, can someone suggest how to show total matches played by a player for all the seasons. For Eg. Virat Kohli played 237 matches for all the seasons.

[@snehapatil7067]

Very nice video with great explanation... Can you please share the dataset which includes 2023 data also.

[@datatutorials1]

U can find it on kaggle

[@snehapatil7067]

​@@datatutorials1 please share the link if possible

[@099_TusharKumar]

For ipl season 2019 the value of wickets in purple cap is wrong and in 2020 the purple cap wicket is wrong and orange cap runs are also incorrect ... Please see it once...

[@johnpaula121]

Hi Bro, this measure, i am not able to achieve : Matches win based on toss decision = CALCULATE(COUNTROWS(ipl_matches_2008_2022),ipl_matches_2008_2022[toss_winner] = Ipl_matches_2008_2022[winning team]) please assist winning team table is not appearing for me...

[@tranthang2104]

In Bowler SR measure, strike rate for a bowler = number of ball / sum of wicket. However, sum of wicket haven't filter (caught, bowled,... ) ?? So result is incorrect ?? please help me !!

[@VekashKUMAR-m9o]

Exactly, even we encountered the same point. Dismissal kind has not been filtered.

[@sujalvaishya7893]

sir I need the latest dataset of ipl including 2023 please suggest me from where can i get

[@techwithchinmay7111]

at 25.08, DAX you are writing is not visible clearly I am not able to understand. it would be good if you zoom or provide DAX in WordPad

[@vinaynarandralal6151]

Hi Swapnjeet, your all videos are awesome. Thanks I world like to ask in IPL DASHBOARD, if I want to see individal player rina against all oppenent by selecting year and batter name?? any clue??

[@vinaynarandralal6151]

Runs against*

[@nivdoshi4072]

Hi actually I am getting a problem like when I am adding slicer and add data field batsman_run then it is showing range from 0-6 and not value. I am also not getting option of aggregate functions can you please what should I do.

[@harshalsawant2866]

2020 kl rahul has scored 670 runs but its showing 676 runs 2019 imran tahir has won purple cap but its showing rabada why?

[@rajeshkundu9421]

if we put Total matches played and batting average in the batting stats charts then what formula or DAX query we should use in measure creation......Can anyone help here according the present data

[@DeepakKumar-p3o3v]

One quick query...shouldn't the match win by toss no. should be 950 in total as the no. of records in IPL_Matches_2008_2022 has 950 rows/games.

[@datatutorials1]

Its the number of one who won the toss and won the match as well.

[@DeepakKumar-p3o3v]

@@datatutorials1 thanks ...this video has been a great learning

[@rahulnaskar167]

How to calculate six / team in dax?

[@darshanchaudhari7969]

Why you didn't divide overs by 6 white calculating bowlers strike rate???

[@dilnawazahmed949]

Nice dashboard and first comment 👍

[@shubhammishra-me2ee]

At 17 : 39 my Sum of iswicket is showing Blank

[@rasranjan5968]

hi sir power bi full course lunch kijiye please

[@datatutorials1]

Sure

[@shahirajlakade7921]

Sir for Economy and Average after applying formula following msg is coming MdxScript(Model) (12, 100) Calculation error in measure ‘ipl_ball_by_ball_2008_2022 [Economy]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

[@shahirajlakade7921]

@@lowbudgetgamer2439 extra type- is text extra run---is text total run ---whole no overs--whole no Its in this format and after applying now its comming SUMX cant be used with string as extra type is string what to do

[@shahirajlakade7921]

@@lowbudgetgamer2439 okay i tried but same msg which come first time

[@datatutorials1]

Hello, send me your pbix file to my mail. I will help you to fix the issue

[@shahirajlakade7921]

@@datatutorials1 Send sir..Thanks for the reply

[@shahirajlakade7921]

@@lowbudgetgamer2439 did you completed this project

[@ambrishbiswas8569]

Every stat is wrong for the 2020 season. Someone, please suggest how to correct this? Is anyone else having the same issue?

[@datatutorials1]

Check once if data and date fields for 2020 season is correct

[@ambrishbiswas8569]

@@datatutorials1 Can you please check it in your system? Wheather it's showing correct/wrong in your report for the 2020 season.

[@ambrishbiswas8569]

Corrected for 2020 season thank you

[@ambrishbiswas8569]

But one more issue is that in 2019 season it showing Purple Cap holder Imran Tahir with 52 Wickets but in IPL bowling Stats for 2019 season showing 26 Wickets for Imran Tahir which is obviously correct. How to correct Purple Cap KPI ??

[@harshalsawant2866]

How bro​@@ambrishbiswas8569

[@SNEHAPATIL-q7s]

will this be updated for 2023

[@datatutorials1]

Yes just add the 2023 data in the excel csv file and hit refresh button in power bi desktop. If using database connections to build the report, then first upload updated csv file in database then refresh power bi report

[@SNEHAPATIL-q7s]

@@datatutorials1 will we have to add the 2023 record manually? ading ball by ball record will be painful

[@datatutorials1]

You will get the records once ipl 2023 is completed. It will be uploaded on kaggle website

[@ASUTOSHTRIPATHY]

2023 data?

[@Vicrock89]

Data from wer u have fetched bro

[@datatutorials1]

Kaggle

[@_SantoshPatil]

Hello Sir I need your help it's urgent how can I contact you?

[@datatutorials1]

My contact available in description of video