Sir! hands down you are the best guy out there on youtube this is an amazing project and I cant thank you enough for making it so easy and simple for us to understand and put all these efforts for us. You earned a sub and I really believe this is the best channel I've subbed to in a long long time. Thank you very much again!
Bro you did a marvellous job by making this video. My rating 9/10 keep making such beautiful videos for data analytics community. Harsh reality that this is a very niche topic and audience is such less to learn that may be reason for poor response. One day will come for your channel will rise to top on this field. Thanks for all teaching 💌
Thanks very much for the Videos you make on PowerBi, but Please some of us don't understand Hindi, so I will love it if you're able to make the videos in English
programação é muito bom, estudem, a leitura nos dar vocábulo e conhecimento; DEUS é tão gentil q quem d verdade RESPEITA O PRÓXIMO cumpre integralmente 10 mandamentos!
That map option not showing in me! What to do. There is a map but it's different. It's saying filled map, and the json file and zoom setting not available in it. I have downloaded the datasets but i am not able to get the icons and flags. It's showing null when expanding after merging.
Bro , Really Awesome you are but i would suggest that if you follow proper format of preparing video like example problem statement , objective , cleaning , processing, transforming, Visulaizing and generating insight . It will help everyone and grow your channel as well.Rest the video is Very Good And I am damn impressed with you. Keep it up and we users will provide the support as well. Thank You Regards, Well Wisher
Thank you so much for your helpful feedback. I truly appreciate and respect your input, and I will definitely implement the points and suggestions you mentioned in my upcoming videos. You'll see them for yourself. Once again, thank you so much, and please continue to stay connected with us!❤️
@@SakshiYadav-q7s When I was creating the dashboard, the data was being updated daily, which required me to download it repeatedly. However, now that the Olympics are over, there's no such issue anymore. You can still download the data, but I mentioned that if you're in a situation where you need daily updates, you don't need to download the data daily. You can simply use this script. This way, whenever you refresh your dataset, it will automatically update. There's more to it as well.
@@The-Developer-BI Thanks ! Also, if the dashboard is published on PBI service, does it require a daily push or is it automatically updated when setting up an automated data refresh for example ?
your dashboard design is top notch no question about that. But how is the total medal count 1436? Official Olympic site shows the total medal is 1036. Wikipedia shows 1044. and i am using the data set you provided from kaggle. Now that updated data shows 2314 medals! The main issue with the data set is its counting the team sports as individual medals. say a 5 men team won gold in volleyball. Its counting 5 medals for that country. But that's not how it works in olympic. So anyone who is using this data, i will suggest to clean your data first.
The behavior you're experiencing is due to the way Power BI handles interactions in the Power BI Desktop environment. When you are in Power BI Desktop, certain actions, such as clicking buttons, require you to hold down the Ctrl key to simulate the click action. This is a safety feature to prevent accidental clicks while designing your reports. However, when you publish your report to the Power BI service (online), this behavior changes, and you will not need to hold down the Ctrl key to interact with buttons. Users will be able to click the buttons directly without needing to press Ctrl.
Sir...aapne Medals jydaa count kiye hai... for example hockey ...toh iss game main 9 players hote hai and iss table main sbhi 9 players ko gold mila hai but count toh hum 1 hi krenge ...so hmne aapke according 8 jydaa count kr liye...and aise bhut games hai jinme 1 se jyda players hote hai...i think you got my logic
@The-Developer-BI I have a doubt, do we have to make script file as well as folder in the starting of this project i.e. Script run and Base_file. Whenever I am refreshing, there is always errors coming, specially in these two files and sometimes related to these two files as well
@@vaishnavinegi4461 you can skip the python process if you are facing many error i have provided dataset in description start with it. I will upload the Latest dataset in same drive folder for you.
Bro i have a facing issue with the setting panel of power bi, i can't enable the shape map. (I checked the box, then select ok, nothing happened, i tried several version of Power bi every time same thing) How to fix the issue? And many many thanks to you. So much detailed video on the Power bi project and quite unique ones. It helps me lot. Thank you Again.
@@allinonetask8189 you will get setup video in that zip folder please follow steps Still having an issue share screenshot on thedeveloper.help@gmail.com
i am using the free desktop version, and i dont have the IMAGE format optino under slicer to add the names and flag images. I guess without the account we dont have access to it. i am just using the flag slicer without names, its difficult with only viewing the flags
@@The-Developer-BI just a quick doubt. When we summerize the total column of the “medals_total” table it should be same as our “total_medals” measure. Its not the same. Also, if we check the total medals won by a particular country say USA. Its not same as the measure. Can you explain y?
I have tried importing the json file of map of countries that you have provided, but it's not showing the option to import in my latest version of powerbi. How can I solve this?
Bro you are brilliant when it comes to Making Dashboard but sorry to say but your teaching style is not as good as any beginner can understand. But at least you are dropping the content, keep it up... Hope you will take it as a feedback to excel yourself.
@@PaUpErMaNaV Thank you for the helpful feedback hope I will try improve as much as possible.😊 I really appreciate your open and straight forward feedback.
Watch Part 2 (Important)🏅
ruclips.net/video/xJPJJ_EXP_o/видео.htmlsi=L_Z87fXfgVh2GTFH
your dashboard designing skill is unmatchable... each time I watch your videos on RUclips, I discover something new to learn
Thank you for the positive feedback ❤️
Excellent hands-on project! You learn so much info and tips that aren't included in classic Power BI courses. Highly recommended!!
This was totally worth it! The visualization are top notch and this session is really in depth. Thank you for this amazing project... Will post soon🙌✨
Sir! hands down you are the best guy out there on youtube this is an amazing project and I cant thank you enough for making it so easy and simple for us to understand and put all these efforts for us. You earned a sub and I really believe this is the best channel I've subbed to in a long long time. Thank you very much again!
I will must say you're on another level of dashboards skills. Tapori style teaching like Rohit Sharma
@@datax_official Thank you 😂
Amazing man!! I am doing another version with this data. When is done i will send the link to you. Thanks a lot!!! I've learned a lot with this video.
Damn, this is going to my resume!!
You are on another level of Dashboard Designing and creation
@@randomshorts113 x😊❤️
Here is one huge shoutout for this amazing dashboard man. That's really awesome...
Well done Bros!! It's fantastic to see you developing your design skills to create more enhanced user experience reports!
Thank you for your positive feedback❤️
Awesome Teaching by the way.
Finally I completed it lol.
I really appreciate your efforts!❤️
Bro you did a marvellous job by making this video.
My rating 9/10
keep making such beautiful videos for data analytics community.
Harsh reality that this is a very niche topic and audience is such less to learn that may be reason for poor response.
One day will come for your channel will rise to top on this field.
Thanks for all teaching 💌
Thanks❤️
Such Amazing motivating feedback 😊
this is masterpiece gold mine for data professionals
😊❤️
This was really good. Next level dashboarding skills
next level of genuine and upskilling others thanks
You are beyond this world bro.
❤️😊
very helpful video in many ways. Thank you Ayan for such an informative video. Keep up the good doing work .
Thank you😊
You create fabulous dashboards. 🤩
Content growing better day by day! Great Videos.
Because of people who comment and appreciate , Thank you😊 ❤️
amazing video bhai I learn lot of new things in this video i watch 2 to 3 times full video
Mehnnat Wasool❤️🤩
i found your channel very late but its worthy... best of all time
No worries, glad you’re here now! Let’s dive into some epic content together!
Amazing work. Whether the dataset is correct because according to the Wikipedia the total medal is 1044.
@@swaminathanm.g1740 unfortunately I am not the owner of the dataset🥲
bro you are on next level plz upload regularly
Thank you for your positive feedback ❤️
Bro you are such a amazing guyyy brooo ❤️🔥😭lots of love
❤️❤️
Amazing stuff, consider making your videos in English for the general public thanks
great work sir amazing dashboard. Sir I don't have powerBI service, what should I add instead of search bar
Sign-up with temp email in power bi and load custom visual
Thanks very much for the Videos you make on PowerBi, but Please some of us don't understand Hindi, so I will love it if you're able to make the videos in English
Sure 😊❤️
Bro You Are Outstanding 🌎
❤️😊
Beautiful Dashboard 😮❤
😊❤️
Amazing bro
programação é muito bom, estudem, a leitura nos dar vocábulo e conhecimento;
DEUS é tão gentil q quem d verdade RESPEITA O PRÓXIMO cumpre integralmente 10 mandamentos!
Nice work brother ❤
Bhai yaar you are Pro Plus of power bi
Aapke postive feedback give more motivation 😍❤️
Thanks!
This is awesome bro really amazing can you please let me know from where did you get the shape map visual?
found it its under global -> preview thank you so much really helpful just subscribed you :)
Started working on it
BEST OF LUCK ❤️
Bht achy se parha rahy hian Bro python p aik video banlena pls
Zaroor 😊
Pls start brand new job oriented playlist on
Excel, SQL, Power BI, Python 😊
With real world projects and interviews questions and answers 😊
That map option not showing in me!
What to do. There is a map but it's different. It's saying filled map, and the json file and zoom setting not available in it.
I have downloaded the datasets but i am not able to get the icons and flags. It's showing null when expanding after merging.
Impressive 🎉
Bro , Really Awesome you are but i would suggest that if you follow proper format of preparing video like example problem statement , objective , cleaning , processing, transforming, Visulaizing and generating insight . It will help everyone and grow your channel as well.Rest the video is Very Good And I am damn impressed with you. Keep it up and we users will provide the support as well.
Thank You
Regards,
Well Wisher
Thank you so much for your helpful feedback. I truly appreciate and respect your input, and I will definitely implement the points and suggestions you mentioned in my upcoming videos. You'll see them for yourself. Once again, thank you so much, and please continue to stay connected with us!❤️
the flag icon of some countries are incorrect. Like Norway
sir you are too good but kindly tell me in which video you taught how to create country name and there flag link
@@Datacrewedtech ❤️❤️ ruclips.net/video/yJRrGkvd16g/видео.html
please give me video link
What is your name, Bro? How do you acquire that knowledge? Liked & Subscribed 😊
Ayan , 😊 by working on many real-time projects.
Can you please explain the advantages of using python script instead of directly using downloaded data.
@@SakshiYadav-q7s When I was creating the dashboard, the data was being updated daily, which required me to download it repeatedly. However, now that the Olympics are over, there's no such issue anymore. You can still download the data, but I mentioned that if you're in a situation where you need daily updates, you don't need to download the data daily. You can simply use this script. This way, whenever you refresh your dataset, it will automatically update. There's more to it as well.
@@The-Developer-BI Thanks ! Also, if the dashboard is published on PBI service, does it require a daily push or is it automatically updated when setting up an automated data refresh for example ?
Pls upload this for memebership thanks for this video u are the best
Okay we'll upload soon
at 1:20:06 :: bhai mein toh har gaya bhai ;)
Sir please upload more advanced level Data Analytics Projects on the trending datasets in Financial and Ecommerce Domains for experienced resumes
your dashboard design is top notch no question about that. But how is the total medal count 1436? Official Olympic site shows the total medal is 1036. Wikipedia shows 1044. and i am using the data set you provided from kaggle. Now that updated data shows 2314 medals! The main issue with the data set is its counting the team sports as individual medals. say a 5 men team won gold in volleyball. Its counting 5 medals for that country. But that's not how it works in olympic. So anyone who is using this data, i will suggest to clean your data first.
@@AsifZaman-i1h Thank you 😊 , Yes we have uploaded second part on this topic
How All_Info table (23:05) created? I am folowing all steps but its not added in Power BI
@@businesscycle7796 don't create it will not use in upcoming video
Thank you really helpful
Love from Pakistan
❤️😊
We do not care whether creater is Indian or Pakistani. If they are doing good work for society, everyone will love 💞
When are you going to make this available in english?
Please make video on real time website analyst'
Open aur close nahi ho raha hai bookmark banane ke baad bhi? Please help. Great video. Please make some more analytics projects.
@@svk0071 Click using CTRL+Click
@@The-Developer-BI Still not opening or closing after CTRL + click on the buttons.
@@The-Developer-BI Thanks bhai ho gaya
The behavior you're experiencing is due to the way Power BI handles interactions in the Power BI Desktop environment. When you are in Power BI Desktop, certain actions, such as clicking buttons, require you to hold down the Ctrl key to simulate the click action. This is a safety feature to prevent accidental clicks while designing your reports.
However, when you publish your report to the Power BI service (online), this behavior changes, and you will not need to hold down the Ctrl key to interact with buttons. Users will be able to click the buttons directly without needing to press Ctrl.
Can we use the jupyter notebook for python script? Also, can we use the dataset directly as the Olympics are over now?
Yes yse directly
How did you create the all_info table? Can you please explain in detail, as I couldn't figure it out from the video.
@@shauryabisht8515 don't create it we'll not use in upcoming part
@@The-Developer-BI In the part 2 video? I'm asking this because without the all info table the map is not looking exactly like the one you have.
Bhai Ap Power Bi pe ek course upload kr do na (for beginners to advance )
Layege jld hi ❤️
Sir...aapne Medals jydaa count kiye hai... for example hockey ...toh iss game main 9 players hote hai and iss table main sbhi 9 players ko gold mila hai but count toh hum 1 hi krenge ...so hmne aapke according 8 jydaa count kr liye...and aise bhut games hai jinme 1 se jyda players hote hai...i think you got my logic
@@ankitkumawat5751
Watch :
ruclips.net/user/shorts6NIIa-VdSJk?feature=share
Watch Second part:
ruclips.net/video/xJPJJ_EXP_o/видео.html
H ust a heads up:I think the boxing icon is the same as basketball
the data in medals section is only having 760 cells when i imported it using python script.
Second part upload
thank you sir lvb u
😊😊
Hey.. this is great piece of work.. thanks so much.. how i can get this excel for icon and flag.. i tried searching for that video but didnt get
Available in description
Can we do the same with static data set now that the Olympics is over
I'm a beginner I don't want to touch Python
Yes you can i have provided a data description.
Bro icon aur unka link create kese kare jane keliye konsa vdo dekhna padega
@@066-pritamjena3 ruclips.net/video/MGWUUToEjuU/видео.html
i have one query sir can we export the power bi report completely into Excel or not or just by visual and visuals
You can export the data by click on three dots and then click on export data
The logo for boxing in game icons is incorrect
Can use make predictions using machine learning??
At 22:14 in the video, could you please explain how ALL_Info table is created?
@@muneebaaslam7920 watch more video we'll not use that table
Thanks you so much sir
Which video you are referring to watch @@The-Developer-BI
i dont find that map option, got other two but not the one you selected
May he have to enable it ... Search on google how to enable shape map in Power bi and use custom map
hi but why my number showing different eg: "code" they're total 2315 in my excel and powerb i too?
Kindly watch second part
ruclips.net/video/xJPJJ_EXP_o/видео.html
I think you didnt count medal for team event as 1 (you count individually), hence why its more than 1044 total medals. im not too sure though
@@anis8969 ruclips.net/user/shorts6NIIa-VdSJk?si=I5kGYuSKS87vYl2h
Very Nice brother..!!
😊❤️
bro yeah mini project mai count hoga yaha major mai ? plzz tell
Middle
Why we joined athletes and medalists for flag
@The-Developer-BI I have a doubt, do we have to make script file as well as folder in the starting of this project i.e. Script run and Base_file. Whenever I am refreshing, there is always errors coming, specially in these two files and sometimes related to these two files as well
When it doesn't find the files or if they already exist, you may encounter errors.
So what to do ? Create both or not? @@The-Developer-BI
@@vaishnavinegi4461 you can skip the python process if you are facing many error i have provided dataset in description start with it.
I will upload the Latest dataset in same drive folder for you.
I have completed the project. Just the finishing is required. Can I send you the dm in insta or linkedin or somewhere else? @@The-Developer-BI
Amazing work
❤️😊
Bro i have a facing issue with the setting panel of power bi, i can't enable the shape map. (I checked the box, then select ok, nothing happened, i tried several version of Power bi every time same thing)
How to fix the issue?
And many many thanks to you.
So much detailed video on the Power bi project and quite unique ones.
It helps me lot.
Thank you Again.
Please give me a solution for this issue. Setting can't be changing. 🐸
Some country flags are not visible in slicer please suggest🙏
Maybe he they are null
@@The-Developer-BI Previously they were null but i have added the country flag url but still they are not visible
Please clear all kis file ko copy krenge pc mai jayega ye smjh nhi nhi aya
I have purchase this Olympic dashboard when i change sources for every file after script and base file it will show error specific column is not found
@@allinonetask8189 you will get setup video in that zip folder please follow steps
Still having an issue share screenshot on thedeveloper.help@gmail.com
Great video brother. Historical dataset ka Python script dedo bhai please.
Available in description
Do you have english for this please? You are amazing..
Your website link that you provided in description is not opening.. can you please give me a solution
Thedeveloperyt.com
bhaya plz make a playlist on DAX and power query plzzz
Thanks for the suggestion! I'll definitely consider creating a playlist on DAX and Power Query. Stay tuned!
Bro is it okay if i do same dashboard and upload it in my resume 😅
@@f1lover785 yes you can 😊
not able to link buttons with bookmark, whats the issue, plz anybody tell
Pls Use CTRL+Click to perform the action
i am using the free desktop version, and i dont have the IMAGE format optino under slicer to add the names and flag images. I guess without the account we dont have access to it.
i am just using the flag slicer without names, its difficult with only viewing the flags
No it's also available in the free version your power bi should be updated and you must choose New silcer visual
How did u get the "All_info" in powerbi?
@@manalishah1152 don't make it will not use in upcoming video That's why i have blur it
Thank you so much for your reply. You have no idea how much your videos are helpful to me. Big thanks again! Wish I discovered this channel before.
@@The-Developer-BI just a quick doubt. When we summerize the total column of the “medals_total” table it should be same as our “total_medals” measure. Its not the same. Also, if we check the total medals won by a particular country say USA. Its not same as the measure. Can you explain y?
Make a course on power bi
Sure❤️
I have tried importing the json file of map of countries that you have provided, but it's not showing the option to import in my latest version of powerbi. How can I solve this?
Choose a Shape map > Choose a custom map option > browse a file
Alright, thanks a lot for the help
@@shauryabisht8515where did you find custom map option my map settings only shows style and control
Bro you are brilliant when it comes to Making Dashboard but sorry to say but your teaching style is not as good as any beginner can understand. But at least you are dropping the content, keep it up... Hope you will take it as a feedback to excel yourself.
@@PaUpErMaNaV Thank you for the helpful feedback hope I will try improve as much as possible.😊
I really appreciate your open and straight forward feedback.
hats offf
how to get country with flags csv
Can anyone tell me how he group this two things in selection part.... I mean which buttons he click.... I'm not able to do this 😢 1:17:27 to 1:17:29
@@pujalinsamal CTRL + G or Select 2 elements and Right Click > And on Click Group Option
@@The-Developer-BIThanks 👍
How to create Power BI report thumbnails similar to those shown at the beginning of the video? This will help us include them in our portfolio.
Sir how could i get the All_info file please help me with it I couldnt find it
@@himanshugupta9787
Don't create it we won't use in upcoming part
@@The-Developer-BI Ok got it sir thanks
sir medallists code ka count medals total k sum k equal kyu nhi h boht zada diff h
To medalist se lelo aap
@@The-Developer-BI hn pr diff kyu ara h data glt h ky. aur sir tableau ka tut daala kro please vo mac m bhi chlta h
can someone please tell , how to create All_info query at 22:10
Could you please watch a video after that part
Because we will not use that table ...aage video me
@@The-Developer-BI oh, great thanks 👍