Hello mate thank you so much for your effort! It means a lot and as a student I learned a lot from you. Just a little advice if I may, the sound of the video wasn't very clear. Might need to use a solild desktop mic man. :)
Beautifully explained, definitely the best end-to-end tutorial I have seen! Really love how you covered every step in great detail and went through the project background and stakeholders to begin with which added an interesting user experience element to the project. Really helped me with my first Power BI project 🙂
Great video. Just one slight correction: Casualties cannot be grouped by “fatal”, “slight” and so on. A casualty is a casualty. Those KPIs should be based on Count of Accidents, not Count of Casualties.
1534 rows contain blank values in road_type column and around 3000+ values contain blank values in weather condition column and still some column have blank values which didn't consider while data cleaning in this video. Can anyone explain??
Really really I'm happy for these kind of help. I would like to join as an developer or analyst for that I spent 10K to an institute where they taught only limited feauters, but when I saw this video I'm completely happy bcz Iearnt something
Your way of teaching is excellent sir...we can understand the concept easily and my suggestion is take the more row data then only we can use all types of tools...thank you so much sir
Please make a video in which you are importing data from a Database for example importing from {Postgresql} and then making a dashboard or a report on it.
Thanks first of all, To be honest you are such a great man as well as great teacher, I really cherish you Sir, today I learnt a lot in your Video thanks again, I don't have a word what I say for your appreciation.
Great job, I have a challenge. I tried to replace the "fetal" with fatal but it is not replacing what should I do. I can further the work without the correction
My only problem is the last map visualizations , I am getting an error and the map is not displaying....any help? I have put the latitude and set the longitude both to average and the legend too...but not displaying
Very nice and educative. Followed from start to end. But I'm having issues understanding this TotalYTD function, if it's actually to calculate the current year, we are in 2023, which is the current year, while is it calculating 2022?
hello sir, you explain very well. But at the time of data cleaning process there is some null value in " Road_surface_Condition" and "weather condition" so what I can do for this. can I remove those null value or replace with other road surface condition.
Great Dashboad and Insights. I was trying to change the % change with conditional formatting to appear values >=0 as red and values less than < as green with Rule but not happening somehow?
Pls I am watching your video, I need the the link to download load this dataset for my practice. Am.a.begginer in data analysis. Don't forget I need more dataset to work on. Thanks
At 1hr, 22 minutes, why measure (CY casualties) not used in the graph. Why two measures like CY casulties and PY casualties mapped on a graph do not give same result?
Total CY accidents are the total accidents taking place in the current year. Total CY Casualties are the people who were injured in the current year in accidents.
@@datatutorials1 Actually data format is in string. So I changed it. But now quick measure values give me blank. I don't know why coz I entered the formula correctly
Please explain why do you have to divide PY casualties, after subtracting CY casualties from PY casualties to get result for YOY casualties. ([CY casualties] - [PY casualties])/[PY casualties] = YOY casualties. Many thanks in advance
Sir I wanted to make my career in data analyst so can we master any one Business intellegence tool like powerBi or we have to do tableau also and which one companis look for.....Thank you sir with help of your videos i created two powerbi project❤
its amazing .we highly required these kind of projects . I request all viewers to share this video as much as possible .
Hello mate thank you so much for your effort! It means a lot and as a student I learned a lot from you. Just a little advice if I may, the sound of the video wasn't very clear. Might need to use a solild desktop mic man. :)
Beautifully explained, definitely the best end-to-end tutorial I have seen! Really love how you covered every step in great detail and went through the project background and stakeholders to begin with which added an interesting user experience element to the project. Really helped me with my first Power BI project 🙂
Glad it was helpful!
Pdlo BDA 1😂
Great video. Just one slight correction: Casualties cannot be grouped by “fatal”, “slight” and so on. A casualty is a casualty. Those KPIs should be based on Count of Accidents, not Count of Casualties.
Casualty doesn't necessarily mean death. It also means a person injured or hurt. Hence, slight or fatal is correct in this context.
Sir ,
Kindly upload the video on Google Data Studio.
Please.
Just completed it, Thank you so much.. Learned so many things through it. ❤
Great job!
How much time u took to complete this project?
30 min just need
1534 rows contain blank values in road_type column and around 3000+ values contain blank values in weather condition column and still some column have blank values which didn't consider while data cleaning in this video. Can anyone explain??
i love that it is really detailed, and you took the time to explain.. Awesome stuff
Glad you liked it ✨
Done Tableau, then Excel now starting Power BI. Thank You !!
This video has a wealth of useful, helpful information. Thanks for everything you do!
Thanks for your support ✨
Thankyou a lot for the amazing video. Really helpful.
Glad you like it ✨
Could you show how to implement this map in excel for this same project? I am finding it difficult
its amazing, but i have problem with map, visual can not represent any data, any solution?
Really really I'm happy for these kind of help. I would like to join as an developer or analyst for that I spent 10K to an institute where they taught only limited feauters, but when I saw this video I'm completely happy bcz Iearnt something
Thanks for the comment 🙂
When I extract the file to the PDF, it became a mess. The format was all out. Any idea what happened? :(
Thank you very much for making this video! I made my first Power Bi Dashboard and I am planning to create a different one for my class project!!
Your way of teaching is excellent sir...we can understand the concept easily and my suggestion is take the more row data then only we can use all types of tools...thank you so much sir
ruclips.net/video/3R7eshUBhfY/видео.html
Please make a video in which you are importing data from a Database for example importing from {Postgresql} and then making a dashboard or a report on it.
The next video will contain connection to Postgres SQL, multiple tables join
Really superb,
Expecting the source as a DB (sql) it would be more helpful , generate a report by using data base pls make a video upon it
Sure
Sir , what is impact of this project could you explain it ?
Fantastic sir.
🙏🙏
Very helpful video for cultivating the skills in BI.
Glad you liked it ✨
Sir i practiced this project..how can i describe this project in my resume
.will u pls write the description
please provide link for background creation
sir after load the data the date format of accident date column name was chnaged
Cool Dashboard 🤩
Thanks for sharing the knowledge bro Appreciate your work.👍
Good evening, and really amazing video and explanation is very nice and i completed it and learn good things
Glad to hear that
Thank u for perfect video ❤
1 video related for construction workplace
Thanks first of all, To be honest you are such a great man as well as great teacher, I really cherish you Sir, today I learnt a lot in your Video thanks again, I don't have a word what I say for your appreciation.
Thanks for your kind words 😊
why convert Latitude & Longitude to avg ??
hello, do you have a video explainig how to do the background on powerpoint if i want another diferent strucutre
Yes, the video is available on my channel
Great video.. thank you much for this wonderful learning.
I have created the same dashboard can I upload this on Linkedin ?
Sure
Last map chart not working 😢how does it work
Great video, so amazing to watch your video
Excellent video helped to get a understanding of how to use Power BI correctly
Glad it was helpful!
Why don't we try maven analytics new powerbi challenge??
Will try, thanks for suggestion
You Made a Good Knowledge able video
bro make sales dashboard using power bi
This is the best channel for Power Bi tutorials... Thank you loved the video😊❤
Wow, thank you!
Great job, I have a challenge. I tried to replace the "fetal" with fatal but it is not replacing what should I do. I can further the work without the correction
put exact case, if there is " F " is capital in "Fetal" then put in capital word .
Quick question, I’m curious as to why you used to the Number of Casualties Provided as opposed to the new measure of CY Casualties we created.
how to remove copyright information thats is appearing with map visual --@2023tom tom microsoft corporation etc. its unwanted information. please help
Map is not working in my power bi
Thanks for a Wonderful video . I Learnt new feature i.e. Group
Glad you liked 🙂
Connecting to models shows error
Thanks For sharing
Great video and very well explained.Will add it to my project portfolio.
Sure
"CY ACCIDENTS COUNT" not showing measure
Thankyou so much sir bcz of this video my many doubt is clear and learned many new things..thanks a lot... your effort is appreciated
why my number seems different from yours after taking ytd calculation
My only problem is the last map visualizations , I am getting an error and the map is not displaying....any help?
I have put the latitude and set the longitude both to average and the legend too...but not displaying
Thanks for this effort. waiting for some more similar practice. 👌
Sure
Awesome. Very helpful.
I iam not able to create month column using same command.It's showing error (cannot find table 'mmm'
How to create measure sir , bcoz my cy casualties is not working and create measure part is skipped
Sir where we use programing language like python and R library numpy and pandas and matplotlib
How we create this type of project please make a videos
To calculate the PY accident, the syntax is incorrect, i need hlep to navigate this part
How to Describe this project in interview. Make a vdo on that .
Sure
Very nice and educative. Followed from start to end. But I'm having issues understanding this TotalYTD function, if it's actually to calculate the current year, we are in 2023, which is the current year, while is it calculating 2022?
bro i have an doubt in this video, you are saying CY casualities which means 2022 data or total casualities
2022
@@datatutorials1 thanks bro
@Data Tutorials
do you have PowerBI notes also as Tableau?
Thank you for explaining in detail.
Glad you liked 🙂
thanks i got many ideas for my final project
Thanks for sharing. Rebuild it. Can you make a video with a use case using drill down (up, through) ?
Thanks for watching, sure will try the drill through function
So beautiful, so elegant, just looking like a WOW
In real time we bring data from SQL database then how edit that data?
hello sir, you explain very well. But at the time of data cleaning process there is some null value in " Road_surface_Condition" and "weather condition" so what I can do for this. can I remove those null value or replace with other road surface condition.
Thankyou so much ❤Great video it was ..looking for more videos🎉
can i ask what exactly your comand in month nw 4x noted
Great Dashboad and Insights. I was trying to change the % change with conditional formatting to appear values >=0 as red and values less than < as green with Rule but not happening somehow?
what is a current year
My only problem is also the last map visualizations , I am getting an error and the map is not displaying I have kept as is...,
could you reply ..?
When Cleared Cache in the options, it is working..
It was great learning from you sir
Glad you liked it ✨
Pls I am watching your video, I need the the link to download load this dataset for my practice. Am.a.begginer in data analysis. Don't forget I need more dataset to work on. Thanks
Link available in description of this video
Thank you for the awesome content
Glad you liked it ✨🙂
At 1hr, 22 minutes, why measure (CY casualties) not used in the graph. Why two measures like CY casulties and PY casualties mapped on a graph do not give same result?
You can show but you have to aggregate them at level of zip code
Particular, with respect to,,,ok,, 30:39 right
Please , give us this dashboard file.
Excellent work! you are really good. Thank you so much!
Thanks
Very helpful ❤️❤️❤️❤️🙏🙏🙏🙏thank you very much.
Great
Sir could u please provide this dataset
Can i ask what exact command of this FORMAT('Calendar'[Date],'
Didn’t understand
@@datatutorials1 yes i did't not understand what exactly command..because i cannot heard properly...
Sir, can you help me how to collect or where to find datasets like yours. Many thanks.
Kaggle website
What is d difference between Total CY Casualties and Total CY Accidents?
Total CY accidents are the total accidents taking place in the current year. Total CY Casualties are the people who were injured in the current year in accidents.
SQL
I am getting current year and previous year casualties both as same that is 417.9 K.
For previous year formula are you adding as -1
@@datatutorials1 What does that mean?
Whenever I use CY using sum(), It says sum cannot do with these type of string. What to do?
What exact calculation you are writing for this?
@@datatutorials1 Actually data format is in string. So I changed it. But now quick measure values give me blank. I don't know why coz I entered the formula correctly
thanks, it is a great one
Glad you liked it ✨
Amazing teaching yr
Thanks a lot 😊
Amazing Video....
Thank you so much 😀
Map is not showing to me
Enable all map options from preview features
Please explain why do you have to divide PY casualties, after subtracting CY casualties from PY casualties to get result for YOY casualties. ([CY casualties] - [PY casualties])/[PY casualties] = YOY casualties. Many thanks in advance
It the formula to calculate year on year growth
@@datatutorials1 thanks so much. I really appreciate your unflinching effort.
Bro When I shared this to Power BI online then map is not showing bro
The map option might not be available for online services
power bi file missing😁😁
File is not provided, you can see complete video and develop on your own.
Can u make extensive data Cleaning video on a super messy dataset
Surely in next video
Sir I wanted to make my career in data analyst so can we master any one Business intellegence tool like powerBi or we have to do tableau also and which one companis look for.....Thank you sir with help of your videos i created two powerbi project❤
Hello, as per current market conditions one should know both power BI and Tableau. Also SQL and an ETL tool is a must.
Sir can you take coaching???